SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002602s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '20007%' OR `brand` LIKE '20007%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030006s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.005442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17296921 LIMIT 5 [ RunTime:0.006204s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17296921 ORDER BY `minOrder` ASC [ RunTime:0.009382s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.015342s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17296921 ORDER BY `unit` DESC [ RunTime:0.030531s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17296921 LIMIT 2 [ RunTime:0.004977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17296921 ORDER BY `minOrder` ASC [ RunTime:0.012383s ]
select * from pdf where partno='2000713-6' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.011683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17296922 LIMIT 5 [ RunTime:0.015577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17296922 ORDER BY `minOrder` ASC [ RunTime:0.017655s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17296922 ORDER BY `unit` DESC [ RunTime:0.007713s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17296922 LIMIT 2 [ RunTime:0.005001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17296922 ORDER BY `minOrder` ASC [ RunTime:0.024567s ]
select * from pdf where partno='2000713-1' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.013683s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11178359 LIMIT 5 [ RunTime:0.022102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11178359 ORDER BY `minOrder` ASC [ RunTime:0.026165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11178359 ORDER BY `unit` DESC [ RunTime:0.010998s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11178359 LIMIT 2 [ RunTime:0.040594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11178359 ORDER BY `minOrder` ASC [ RunTime:0.010440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15439261 LIMIT 5 [ RunTime:0.022816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15439261 ORDER BY `minOrder` ASC [ RunTime:0.006146s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15439261 ORDER BY `unit` DESC [ RunTime:0.017556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15439261 LIMIT 2 [ RunTime:0.003744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15439261 ORDER BY `minOrder` ASC [ RunTime:0.007933s ]
select * from pdf where partno='2000713-3' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.083571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19572778 LIMIT 5 [ RunTime:0.006888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19572778 ORDER BY `minOrder` ASC [ RunTime:0.015474s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19572778 ORDER BY `unit` DESC [ RunTime:0.044578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19572778 LIMIT 2 [ RunTime:0.035832s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19572778 ORDER BY `minOrder` ASC [ RunTime:0.001275s ]
select * from pdf where partno='2000713-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.023011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19573895 LIMIT 5 [ RunTime:0.016924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19573895 ORDER BY `minOrder` ASC [ RunTime:0.018184s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19573895 ORDER BY `unit` DESC [ RunTime:0.032920s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19573895 LIMIT 2 [ RunTime:0.008730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19573895 ORDER BY `minOrder` ASC [ RunTime:0.003728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19572782 LIMIT 5 [ RunTime:0.005549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19572782 ORDER BY `minOrder` ASC [ RunTime:0.000701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19572782 ORDER BY `unit` DESC [ RunTime:0.010849s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19572782 LIMIT 2 [ RunTime:0.003563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19572782 ORDER BY `minOrder` ASC [ RunTime:0.004427s ]
select * from pdf where partno='2000713-7' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.009825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15439254 LIMIT 5 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15439254 ORDER BY `minOrder` ASC [ RunTime:0.013081s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15439254 ORDER BY `unit` DESC [ RunTime:0.011385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15439254 LIMIT 2 [ RunTime:0.001954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15439254 ORDER BY `minOrder` ASC [ RunTime:0.000372s ]
select * from pdf where partno='2000713-4' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.001038s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15439255 LIMIT 5 [ RunTime:0.000539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15439255 ORDER BY `minOrder` ASC [ RunTime:0.003370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15439255 ORDER BY `unit` DESC [ RunTime:0.000383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15439255 LIMIT 2 [ RunTime:0.000442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15439255 ORDER BY `minOrder` ASC [ RunTime:0.002387s ]
select * from pdf where partno='2000713-5' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.000366s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20081655 LIMIT 5 [ RunTime:0.008571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20081655 ORDER BY `minOrder` ASC [ RunTime:0.000975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20081655 ORDER BY `unit` DESC [ RunTime:0.000344s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20081655 LIMIT 2 [ RunTime:0.000293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20081655 ORDER BY `minOrder` ASC [ RunTime:0.000227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20081557 LIMIT 5 [ RunTime:0.000679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20081557 ORDER BY `minOrder` ASC [ RunTime:0.007732s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20081557 ORDER BY `unit` DESC [ RunTime:0.001023s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20081557 LIMIT 2 [ RunTime:0.000510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20081557 ORDER BY `minOrder` ASC [ RunTime:0.000213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20081302 LIMIT 5 [ RunTime:0.000789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20081302 ORDER BY `minOrder` ASC [ RunTime:0.000351s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20081302 ORDER BY `unit` DESC [ RunTime:0.012355s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20081302 LIMIT 2 [ RunTime:0.006763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20081302 ORDER BY `minOrder` ASC [ RunTime:0.002269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19584305 LIMIT 5 [ RunTime:0.001042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584305 ORDER BY `minOrder` ASC [ RunTime:0.000553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19584305 ORDER BY `unit` DESC [ RunTime:0.002842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19584305 LIMIT 2 [ RunTime:0.000436s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19584305 ORDER BY `minOrder` ASC [ RunTime:0.000287s ]
select * from pdf where partno='20007' and brandshort='3M' limit 1 [ RunTime:0.002675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19573475 LIMIT 5 [ RunTime:0.003661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19573475 ORDER BY `minOrder` ASC [ RunTime:0.000682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19573475 ORDER BY `unit` DESC [ RunTime:0.000550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19573475 LIMIT 2 [ RunTime:0.004367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19573475 ORDER BY `minOrder` ASC [ RunTime:0.005663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19573474 LIMIT 5 [ RunTime:0.002321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19573474 ORDER BY `minOrder` ASC [ RunTime:0.005408s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19573474 ORDER BY `unit` DESC [ RunTime:0.001699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19573474 LIMIT 2 [ RunTime:0.000654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19573474 ORDER BY `minOrder` ASC [ RunTime:0.000328s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18820754 LIMIT 5 [ RunTime:0.001030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18820754 ORDER BY `minOrder` ASC [ RunTime:0.003371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18820754 ORDER BY `unit` DESC [ RunTime:0.006643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18820754 LIMIT 2 [ RunTime:0.009814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18820754 ORDER BY `minOrder` ASC [ RunTime:0.000226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18798304 LIMIT 5 [ RunTime:0.000665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18798304 ORDER BY `minOrder` ASC [ RunTime:0.010941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18798304 ORDER BY `unit` DESC [ RunTime:0.009971s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18798304 LIMIT 2 [ RunTime:0.002914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18798304 ORDER BY `minOrder` ASC [ RunTime:0.007097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18798225 LIMIT 5 [ RunTime:0.003440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18798225 ORDER BY `minOrder` ASC [ RunTime:0.000580s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18798225 ORDER BY `unit` DESC [ RunTime:0.002056s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18798225 LIMIT 2 [ RunTime:0.001665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18798225 ORDER BY `minOrder` ASC [ RunTime:0.000223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18798174 LIMIT 5 [ RunTime:0.000465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18798174 ORDER BY `minOrder` ASC [ RunTime:0.000309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18798174 ORDER BY `unit` DESC [ RunTime:0.002712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18798174 LIMIT 2 [ RunTime:0.001135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18798174 ORDER BY `minOrder` ASC [ RunTime:0.004987s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16993902 LIMIT 5 [ RunTime:0.011597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16993902 ORDER BY `minOrder` ASC [ RunTime:0.013786s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16993902 ORDER BY `unit` DESC [ RunTime:0.005641s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16993902 LIMIT 2 [ RunTime:0.004054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16993902 ORDER BY `minOrder` ASC [ RunTime:0.000195s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '20007%' OR `brand` LIKE '20007%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004022s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270718 LIMIT 5 [ RunTime:0.002946s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270718 ORDER BY `minOrder` ASC [ RunTime:0.024415s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270718 ORDER BY `unit` DESC [ RunTime:0.005316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270718 LIMIT 2 [ RunTime:0.010939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270718 ORDER BY `minOrder` ASC [ RunTime:0.001093s ]
select * from pdf where partno='2000713-6' and brandshort='te connectivity' limit 1 [ RunTime:0.000919s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002688s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000713-6' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.030907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270783 LIMIT 5 [ RunTime:0.000728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270783 ORDER BY `minOrder` ASC [ RunTime:0.003662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270783 ORDER BY `unit` DESC [ RunTime:0.005352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270783 LIMIT 2 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270783 ORDER BY `minOrder` ASC [ RunTime:0.006656s ]
select * from pdf where partno='2000713-5' and brandshort='te connectivity' limit 1 [ RunTime:0.001052s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000713-5' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.024471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270781 LIMIT 5 [ RunTime:0.007215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270781 ORDER BY `minOrder` ASC [ RunTime:0.002350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270781 ORDER BY `unit` DESC [ RunTime:0.000467s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270781 LIMIT 2 [ RunTime:0.001777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270781 ORDER BY `minOrder` ASC [ RunTime:0.000301s ]
select * from pdf where partno='2000713-1' and brandshort='te connectivity' limit 1 [ RunTime:0.001433s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000713-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.009419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270782 LIMIT 5 [ RunTime:0.005639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270782 ORDER BY `minOrder` ASC [ RunTime:0.000476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270782 ORDER BY `unit` DESC [ RunTime:0.001182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270782 LIMIT 2 [ RunTime:0.000787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270782 ORDER BY `minOrder` ASC [ RunTime:0.000219s ]
select * from pdf where partno='2000713-2' and brandshort='te connectivity' limit 1 [ RunTime:0.000526s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000713-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.010426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270784 LIMIT 5 [ RunTime:0.006658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270784 ORDER BY `minOrder` ASC [ RunTime:0.002558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270784 ORDER BY `unit` DESC [ RunTime:0.008818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270784 LIMIT 2 [ RunTime:0.000672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270784 ORDER BY `minOrder` ASC [ RunTime:0.001885s ]
select * from pdf where partno='2000713-7' and brandshort='te connectivity' limit 1 [ RunTime:0.000716s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000713-7' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.016462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51076622 LIMIT 5 [ RunTime:0.003504s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51076622 ORDER BY `minOrder` ASC [ RunTime:0.008839s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51076622 ORDER BY `unit` DESC [ RunTime:0.001815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51076622 LIMIT 2 [ RunTime:0.004804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51076622 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
select * from pdf where partno='2000742107' and brandshort='advanced energy' limit 1 [ RunTime:0.000587s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000742107' OR `brand` LIKE 'advanced energy%' ) ) LIMIT 1 [ RunTime:0.000893s ]
SELECT `id` FROM `stock` WHERE `id` <> 51076622 AND `partno` = '2000742107' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%advanced energy%' ) [ RunTime:0.001849s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51076312 LIMIT 5 [ RunTime:0.002375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51076312 ORDER BY `minOrder` ASC [ RunTime:0.001527s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51076312 ORDER BY `unit` DESC [ RunTime:0.000731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51076312 LIMIT 2 [ RunTime:0.001515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51076312 ORDER BY `minOrder` ASC [ RunTime:0.000337s ]
select * from pdf where partno='2000745106' and brandshort='advanced energy' limit 1 [ RunTime:0.000854s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000745106' OR `brand` LIKE 'advanced energy%' ) ) LIMIT 1 [ RunTime:0.001090s ]
SELECT `id` FROM `stock` WHERE `id` <> 51076312 AND `partno` = '2000745106' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%advanced energy%' ) [ RunTime:0.000670s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '20007%' OR `brand` LIKE '20007%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58568183 LIMIT 5 [ RunTime:0.000616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58568183 ORDER BY `minOrder` ASC [ RunTime:0.002110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58568183 ORDER BY `unit` DESC [ RunTime:0.002453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58568183 LIMIT 2 [ RunTime:0.000541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58568183 ORDER BY `minOrder` ASC [ RunTime:0.000781s ]
select * from pdf where partno='20007' and brandshort='Excel Blades' limit 1 [ RunTime:0.001231s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20007' OR `brand` LIKE 'Excel Blades%' ) ) LIMIT 1 [ RunTime:0.003935s ]
SELECT `id` FROM `stock` WHERE `id` <> 58568183 AND `partno` = '20007' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%excel blades%' ) [ RunTime:0.005382s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11178359 [ RunTime:0.001704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60372234 LIMIT 5 [ RunTime:0.012514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60372234 ORDER BY `minOrder` ASC [ RunTime:0.007234s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60372234 ORDER BY `unit` DESC [ RunTime:0.000791s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60372234 LIMIT 2 [ RunTime:0.003079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60372234 ORDER BY `minOrder` ASC [ RunTime:0.013680s ]
select * from pdf where partno='2000713-7' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.002808s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000713-7' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.005555s ]
SELECT `id` FROM `stock` WHERE `id` <> 60372234 AND `partno` = '2000713-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.001025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19572782 [ RunTime:0.000439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60372152 LIMIT 5 [ RunTime:0.010655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60372152 ORDER BY `minOrder` ASC [ RunTime:0.011990s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60372152 ORDER BY `unit` DESC [ RunTime:0.013154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60372152 LIMIT 2 [ RunTime:0.008298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60372152 ORDER BY `minOrder` ASC [ RunTime:0.001756s ]
select * from pdf where partno='2000713-6' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.001684s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000713-6' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.004159s ]
SELECT `id` FROM `stock` WHERE `id` <> 60372152 AND `partno` = '2000713-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.010593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17296921 [ RunTime:0.008211s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60372227 LIMIT 5 [ RunTime:0.012409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60372227 ORDER BY `minOrder` ASC [ RunTime:0.003785s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60372227 ORDER BY `unit` DESC [ RunTime:0.004125s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60372227 LIMIT 2 [ RunTime:0.010513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60372227 ORDER BY `minOrder` ASC [ RunTime:0.012584s ]
select * from pdf where partno='2000713-5' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.000537s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000713-5' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.000733s ]
SELECT `id` FROM `stock` WHERE `id` <> 60372227 AND `partno` = '2000713-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.000659s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15439255 [ RunTime:0.000292s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60372153 LIMIT 5 [ RunTime:0.003370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60372153 ORDER BY `minOrder` ASC [ RunTime:0.028241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60372153 ORDER BY `unit` DESC [ RunTime:0.009084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60372153 LIMIT 2 [ RunTime:0.008878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60372153 ORDER BY `minOrder` ASC [ RunTime:0.002666s ]
select * from pdf where partno='2000713-2' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.000733s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000713-2' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.001003s ]
SELECT `id` FROM `stock` WHERE `id` <> 60372153 AND `partno` = '2000713-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.009646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19572778 [ RunTime:0.000934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60944013 LIMIT 5 [ RunTime:0.002643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60944013 ORDER BY `minOrder` ASC [ RunTime:0.007210s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60944013 ORDER BY `unit` DESC [ RunTime:0.005474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60944013 LIMIT 2 [ RunTime:0.000657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60944013 ORDER BY `minOrder` ASC [ RunTime:0.005840s ]
select * from pdf where partno='2000713-5' and brandshort='TE Connectivity' limit 1 [ RunTime:0.004766s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000713-5' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.033755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60372228 LIMIT 5 [ RunTime:0.002419s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60372228 ORDER BY `minOrder` ASC [ RunTime:0.001296s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60372228 ORDER BY `unit` DESC [ RunTime:0.000738s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60372228 LIMIT 2 [ RunTime:0.000728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60372228 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
select * from pdf where partno='2000713-3' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.000477s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000713-3' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.000773s ]
SELECT `id` FROM `stock` WHERE `id` <> 60372228 AND `partno` = '2000713-3' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.000930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15439261 [ RunTime:0.000717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60372380 LIMIT 5 [ RunTime:0.000974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60372380 ORDER BY `minOrder` ASC [ RunTime:0.001219s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60372380 ORDER BY `unit` DESC [ RunTime:0.004351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60372380 LIMIT 2 [ RunTime:0.001143s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60372380 ORDER BY `minOrder` ASC [ RunTime:0.000375s ]
select * from pdf where partno='2000713-9' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.000980s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000713-9' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.002260s ]
SELECT `id` FROM `stock` WHERE `id` <> 60372380 AND `partno` = '2000713-9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.004794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19573475 [ RunTime:0.000607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60372237 LIMIT 5 [ RunTime:0.001348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60372237 ORDER BY `minOrder` ASC [ RunTime:0.002208s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60372237 ORDER BY `unit` DESC [ RunTime:0.000546s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60372237 LIMIT 2 [ RunTime:0.001604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60372237 ORDER BY `minOrder` ASC [ RunTime:0.005148s ]
select * from pdf where partno='2000713-8' and brandshort='TE Connectivity Aerospace, Defense and Marine' limit 1 [ RunTime:0.000999s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000713-8' OR `brand` LIKE 'TE Connectivity Aerospace, Defense and Marine%' ) ) LIMIT 1 [ RunTime:0.001333s ]
SELECT `id` FROM `stock` WHERE `id` <> 60372237 AND `partno` = '2000713-8' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity aerospace, defense and marine%' ) [ RunTime:0.001327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19573474 [ RunTime:0.000614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60372708 LIMIT 5 [ RunTime:0.000540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60372708 ORDER BY `minOrder` ASC [ RunTime:0.002035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60372708 ORDER BY `unit` DESC [ RunTime:0.001720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60372708 LIMIT 2 [ RunTime:0.003767s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60372708 ORDER BY `minOrder` ASC [ RunTime:0.005893s ]
select * from pdf where partno='2000713-8' and brandshort='WEC' limit 1 [ RunTime:0.004940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2000713-8' OR `brand` LIKE 'WEC%' ) ) LIMIT 1 [ RunTime:0.001895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64776779 LIMIT 5 [ RunTime:0.014240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64776779 ORDER BY `minOrder` ASC [ RunTime:0.037637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64776779 ORDER BY `unit` DESC [ RunTime:0.012420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64776779 LIMIT 2 [ RunTime:0.002275s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64776779 ORDER BY `minOrder` ASC [ RunTime:0.002300s ]
select * from pdf where partno='20007470-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.003651s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20007470-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.014987s ]
SELECT `id` FROM `stock` WHERE `id` <> 64776779 AND `partno` = '20007470-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.007966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64776685 LIMIT 5 [ RunTime:0.017563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64776685 ORDER BY `minOrder` ASC [ RunTime:0.001421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64776685 ORDER BY `unit` DESC [ RunTime:0.005888s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64776685 LIMIT 2 [ RunTime:0.013881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64776685 ORDER BY `minOrder` ASC [ RunTime:0.001315s ]
select * from pdf where partno='20007765-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.000907s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20007765-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.008919s ]
SELECT `id` FROM `stock` WHERE `id` <> 64776685 AND `partno` = '20007765-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.025514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64773372 LIMIT 5 [ RunTime:0.026071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64773372 ORDER BY `minOrder` ASC [ RunTime:0.030449s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64773372 ORDER BY `unit` DESC [ RunTime:0.007553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64773372 LIMIT 2 [ RunTime:0.004093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64773372 ORDER BY `minOrder` ASC [ RunTime:0.012642s ]
select * from pdf where partno='20007845-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.004796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20007845-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.009660s ]
SELECT `id` FROM `stock` WHERE `id` <> 64773372 AND `partno` = '20007845-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.013491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64773367 LIMIT 5 [ RunTime:0.006222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64773367 ORDER BY `minOrder` ASC [ RunTime:0.005984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64773367 ORDER BY `unit` DESC [ RunTime:0.001060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64773367 LIMIT 2 [ RunTime:0.000295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64773367 ORDER BY `minOrder` ASC [ RunTime:0.000203s ]
select * from pdf where partno='20007505-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.000564s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20007505-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.007367s ]
SELECT `id` FROM `stock` WHERE `id` <> 64773367 AND `partno` = '20007505-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.015512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18820754 [ RunTime:0.005387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64773257 LIMIT 5 [ RunTime:0.007425s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64773257 ORDER BY `minOrder` ASC [ RunTime:0.012456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64773257 ORDER BY `unit` DESC [ RunTime:0.013435s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64773257 LIMIT 2 [ RunTime:0.027363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64773257 ORDER BY `minOrder` ASC [ RunTime:0.010367s ]
select * from pdf where partno='20007259-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.008810s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20007259-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.017897s ]
SELECT `id` FROM `stock` WHERE `id` <> 64773257 AND `partno` = '20007259-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.011511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14183198 [ RunTime:0.007056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64750026 LIMIT 5 [ RunTime:0.010180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64750026 ORDER BY `minOrder` ASC [ RunTime:0.012807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64750026 ORDER BY `unit` DESC [ RunTime:0.002673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64750026 LIMIT 2 [ RunTime:0.003971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64750026 ORDER BY `minOrder` ASC [ RunTime:0.006836s ]
select * from pdf where partno='20007379-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.001568s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20007379-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.016591s ]
SELECT `id` FROM `stock` WHERE `id` <> 64750026 AND `partno` = '20007379-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.001002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64749930 LIMIT 5 [ RunTime:0.000632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64749930 ORDER BY `minOrder` ASC [ RunTime:0.001011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64749930 ORDER BY `unit` DESC [ RunTime:0.000623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64749930 LIMIT 2 [ RunTime:0.000595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64749930 ORDER BY `minOrder` ASC [ RunTime:0.000456s ]
select * from pdf where partno='20007315-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.002612s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20007315-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.000799s ]
SELECT `id` FROM `stock` WHERE `id` <> 64749930 AND `partno` = '20007315-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.002859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64749882 LIMIT 5 [ RunTime:0.005844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64749882 ORDER BY `minOrder` ASC [ RunTime:0.004834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64749882 ORDER BY `unit` DESC [ RunTime:0.012039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64749882 LIMIT 2 [ RunTime:0.000909s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64749882 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
select * from pdf where partno='20007671-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.001009s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20007671-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.001947s ]
SELECT `id` FROM `stock` WHERE `id` <> 64749882 AND `partno` = '20007671-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.002406s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64749813 LIMIT 5 [ RunTime:0.008581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64749813 ORDER BY `minOrder` ASC [ RunTime:0.003377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64749813 ORDER BY `unit` DESC [ RunTime:0.002416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64749813 LIMIT 2 [ RunTime:0.006189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64749813 ORDER BY `minOrder` ASC [ RunTime:0.004527s ]
select * from pdf where partno='20007518-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.004558s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20007518-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.006237s ]
SELECT `id` FROM `stock` WHERE `id` <> 64749813 AND `partno` = '20007518-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.001963s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64726425 LIMIT 5 [ RunTime:0.007219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64726425 ORDER BY `minOrder` ASC [ RunTime:0.013276s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64726425 ORDER BY `unit` DESC [ RunTime:0.003499s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64726425 LIMIT 2 [ RunTime:0.002317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64726425 ORDER BY `minOrder` ASC [ RunTime:0.000425s ]
select * from pdf where partno='20007519-00' and brandshort='TE Connectivity Measurement Specialties' limit 1 [ RunTime:0.000965s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '20007519-00' OR `brand` LIKE 'TE Connectivity Measurement Specialties%' ) ) LIMIT 1 [ RunTime:0.002766s ]
SELECT `id` FROM `stock` WHERE `id` <> 64726425 AND `partno` = '20007519-00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity measurement specialties%' ) [ RunTime:0.000903s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '20007%' OR `brand` LIKE '20007%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001460s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '20007%' OR `brand` LIKE '20007%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001675s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '20007%' OR `brand` LIKE '20007%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001204s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '20007%' OR `brand` LIKE '20007%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014907s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '20007%' OR `brand` LIKE '20007%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012445s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '20007%' OR `brand` LIKE '20007%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000823s ]
SELECT `s`.`id`,`s`.`userid`,`s`.`status`,`havePdf`,`categoryid`,`categories`,`minOrderPrice`,`minOrderQuantity`,`deliveryNum`,`sellNum`,`stockNum`,`code`,`partno`,`brand`,`package`,`imgurl`,`note`,`description`,`expiretime`,`pdfurl`,`t`.`name` FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '20007%' OR `brand` LIKE '20007%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005570s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '20007%' OR `brand` LIKE '20007%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001605s ]