SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001674s ]
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 '22174%' OR `brand` LIKE '22174%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.038361s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18729077 LIMIT 5 [ RunTime:0.006660s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18729077 ORDER BY `minOrder` ASC [ RunTime:0.010538s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.013189s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18729077 ORDER BY `unit` DESC [ RunTime:0.016595s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18729077 LIMIT 2 [ RunTime:0.012901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18729077 ORDER BY `minOrder` ASC [ RunTime:0.008649s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16999819 LIMIT 5 [ RunTime:0.013513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16999819 ORDER BY `minOrder` ASC [ RunTime:0.004525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16999819 ORDER BY `unit` DESC [ RunTime:0.007797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16999819 LIMIT 2 [ RunTime:0.034364s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16999819 ORDER BY `minOrder` ASC [ RunTime:0.003454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18725233 LIMIT 5 [ RunTime:0.018108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18725233 ORDER BY `minOrder` ASC [ RunTime:0.016683s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18725233 ORDER BY `unit` DESC [ RunTime:0.029717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18725233 LIMIT 2 [ RunTime:0.028571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18725233 ORDER BY `minOrder` ASC [ RunTime:0.008102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15212792 LIMIT 5 [ RunTime:0.015689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15212792 ORDER BY `minOrder` ASC [ RunTime:0.008766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15212792 ORDER BY `unit` DESC [ RunTime:0.044032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15212792 LIMIT 2 [ RunTime:0.038138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15212792 ORDER BY `minOrder` ASC [ RunTime:0.026663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18754160 LIMIT 5 [ RunTime:0.013732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754160 ORDER BY `minOrder` ASC [ RunTime:0.022038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18754160 ORDER BY `unit` DESC [ RunTime:0.013940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18754160 LIMIT 2 [ RunTime:0.017691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754160 ORDER BY `minOrder` ASC [ RunTime:0.002621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18754137 LIMIT 5 [ RunTime:0.016285s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754137 ORDER BY `minOrder` ASC [ RunTime:0.008258s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18754137 ORDER BY `unit` DESC [ RunTime:0.006034s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18754137 LIMIT 2 [ RunTime:0.000691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754137 ORDER BY `minOrder` ASC [ RunTime:0.001803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18754132 LIMIT 5 [ RunTime:0.002063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754132 ORDER BY `minOrder` ASC [ RunTime:0.001291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18754132 ORDER BY `unit` DESC [ RunTime:0.001445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18754132 LIMIT 2 [ RunTime:0.004452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754132 ORDER BY `minOrder` ASC [ RunTime:0.007617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18725118 LIMIT 5 [ RunTime:0.012993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18725118 ORDER BY `minOrder` ASC [ RunTime:0.003331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18725118 ORDER BY `unit` DESC [ RunTime:0.000732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18725118 LIMIT 2 [ RunTime:0.000708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18725118 ORDER BY `minOrder` ASC [ RunTime:0.001652s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18757355 LIMIT 5 [ RunTime:0.004881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18757355 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18757355 ORDER BY `unit` DESC [ RunTime:0.006328s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18757355 LIMIT 2 [ RunTime:0.003560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18757355 ORDER BY `minOrder` ASC [ RunTime:0.005522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18757181 LIMIT 5 [ RunTime:0.001924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18757181 ORDER BY `minOrder` ASC [ RunTime:0.002123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18757181 ORDER BY `unit` DESC [ RunTime:0.001479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18757181 LIMIT 2 [ RunTime:0.002334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18757181 ORDER BY `minOrder` ASC [ RunTime:0.001334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18754135 LIMIT 5 [ RunTime:0.003179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754135 ORDER BY `minOrder` ASC [ RunTime:0.000321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18754135 ORDER BY `unit` DESC [ RunTime:0.000299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18754135 LIMIT 2 [ RunTime:0.000996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18754135 ORDER BY `minOrder` ASC [ RunTime:0.002168s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18750573 LIMIT 5 [ RunTime:0.000667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18750573 ORDER BY `minOrder` ASC [ RunTime:0.000265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18750573 ORDER BY `unit` DESC [ RunTime:0.001454s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18750573 LIMIT 2 [ RunTime:0.004600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18750573 ORDER BY `minOrder` ASC [ RunTime:0.000183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18750390 LIMIT 5 [ RunTime:0.003334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18750390 ORDER BY `minOrder` ASC [ RunTime:0.003232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18750390 ORDER BY `unit` DESC [ RunTime:0.002169s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18750390 LIMIT 2 [ RunTime:0.003854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18750390 ORDER BY `minOrder` ASC [ RunTime:0.000505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18749132 LIMIT 5 [ RunTime:0.003545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18749132 ORDER BY `minOrder` ASC [ RunTime:0.001039s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18749132 ORDER BY `unit` DESC [ RunTime:0.000319s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18749132 LIMIT 2 [ RunTime:0.001859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18749132 ORDER BY `minOrder` ASC [ RunTime:0.000206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18720121 LIMIT 5 [ RunTime:0.002453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18720121 ORDER BY `minOrder` ASC [ RunTime:0.000606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18720121 ORDER BY `unit` DESC [ RunTime:0.000327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18720121 LIMIT 2 [ RunTime:0.002117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18720121 ORDER BY `minOrder` ASC [ RunTime:0.000913s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18719622 LIMIT 5 [ RunTime:0.001246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18719622 ORDER BY `minOrder` ASC [ RunTime:0.000280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18719622 ORDER BY `unit` DESC [ RunTime:0.001192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18719622 LIMIT 2 [ RunTime:0.000246s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18719622 ORDER BY `minOrder` ASC [ RunTime:0.000169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18719544 LIMIT 5 [ RunTime:0.000427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18719544 ORDER BY `minOrder` ASC [ RunTime:0.000324s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18719544 ORDER BY `unit` DESC [ RunTime:0.001265s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18719544 LIMIT 2 [ RunTime:0.000823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18719544 ORDER BY `minOrder` ASC [ RunTime:0.002920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17005365 LIMIT 5 [ RunTime:0.002847s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17005365 ORDER BY `minOrder` ASC [ RunTime:0.002086s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17005365 ORDER BY `unit` DESC [ RunTime:0.000307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17005365 LIMIT 2 [ RunTime:0.000363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17005365 ORDER BY `minOrder` ASC [ RunTime:0.000174s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16997982 LIMIT 5 [ RunTime:0.000534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16997982 ORDER BY `minOrder` ASC [ RunTime:0.002539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16997982 ORDER BY `unit` DESC [ RunTime:0.000901s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16997982 LIMIT 2 [ RunTime:0.000746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16997982 ORDER BY `minOrder` ASC [ RunTime:0.003225s ]
select * from pdf where partno='2217484-2' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.001957s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15217986 LIMIT 5 [ RunTime:0.002247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15217986 ORDER BY `minOrder` ASC [ RunTime:0.000724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15217986 ORDER BY `unit` DESC [ RunTime:0.005291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15217986 LIMIT 2 [ RunTime:0.000992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15217986 ORDER BY `minOrder` ASC [ RunTime:0.000421s ]
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 '22174%' OR `brand` LIKE '22174%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001806s ]
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 '22174%' OR `brand` LIKE '22174%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58527560 LIMIT 5 [ RunTime:0.006083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58527560 ORDER BY `minOrder` ASC [ RunTime:0.001681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58527560 ORDER BY `unit` DESC [ RunTime:0.000366s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58527560 LIMIT 2 [ RunTime:0.003357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58527560 ORDER BY `minOrder` ASC [ RunTime:0.001422s ]
select * from pdf where partno='2217485-1' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.001781s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002217s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2217485-1' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.002884s ]
SELECT `id` FROM `stock` WHERE `id` <> 58527560 AND `partno` = '2217485-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.002731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58527063 LIMIT 5 [ RunTime:0.000738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58527063 ORDER BY `minOrder` ASC [ RunTime:0.002757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58527063 ORDER BY `unit` DESC [ RunTime:0.006415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58527063 LIMIT 2 [ RunTime:0.004787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58527063 ORDER BY `minOrder` ASC [ RunTime:0.001900s ]
select * from pdf where partno='2217480-1' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.003854s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2217480-1' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000881s ]
SELECT `id` FROM `stock` WHERE `id` <> 58527063 AND `partno` = '2217480-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.000875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44626676 LIMIT 5 [ RunTime:0.001701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44626676 ORDER BY `minOrder` ASC [ RunTime:0.009454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44626676 ORDER BY `unit` DESC [ RunTime:0.000956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44626676 LIMIT 2 [ RunTime:0.003676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44626676 ORDER BY `minOrder` ASC [ RunTime:0.000466s ]
select * from pdf where partno='2217485-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.001222s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2217485-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.001438s ]
SELECT `id` FROM `stock` WHERE `id` <> 44626676 AND `partno` = '2217485-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.000844s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16999819 [ RunTime:0.001054s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33107978 LIMIT 5 [ RunTime:0.001041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33107978 ORDER BY `minOrder` ASC [ RunTime:0.009921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33107978 ORDER BY `unit` DESC [ RunTime:0.001924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33107978 LIMIT 2 [ RunTime:0.000969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33107978 ORDER BY `minOrder` ASC [ RunTime:0.000336s ]
select * from pdf where partno='2217485-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.000406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2217485-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000328s ]
SELECT `id` FROM `stock` WHERE `id` <> 33107978 AND `partno` = '2217485-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.001970s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16999819 [ RunTime:0.001827s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58527364 LIMIT 5 [ RunTime:0.000730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58527364 ORDER BY `minOrder` ASC [ RunTime:0.000950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58527364 ORDER BY `unit` DESC [ RunTime:0.002963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58527364 LIMIT 2 [ RunTime:0.000956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58527364 ORDER BY `minOrder` ASC [ RunTime:0.000337s ]
select * from pdf where partno='2217484-1' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.000789s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2217484-1' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.004380s ]
SELECT `id` FROM `stock` WHERE `id` <> 58527364 AND `partno` = '2217484-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.004014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58527082 LIMIT 5 [ RunTime:0.001408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58527082 ORDER BY `minOrder` ASC [ RunTime:0.003963s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58527082 ORDER BY `unit` DESC [ RunTime:0.007485s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58527082 LIMIT 2 [ RunTime:0.007075s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58527082 ORDER BY `minOrder` ASC [ RunTime:0.000855s ]
select * from pdf where partno='2217483-1' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.011036s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2217483-1' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.006021s ]
SELECT `id` FROM `stock` WHERE `id` <> 58527082 AND `partno` = '2217483-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.000995s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44626669 LIMIT 5 [ RunTime:0.001073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44626669 ORDER BY `minOrder` ASC [ RunTime:0.002252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44626669 ORDER BY `unit` DESC [ RunTime:0.001101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44626669 LIMIT 2 [ RunTime:0.000680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44626669 ORDER BY `minOrder` ASC [ RunTime:0.004055s ]
select * from pdf where partno='2217484-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.010461s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2217484-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000969s ]
SELECT `id` FROM `stock` WHERE `id` <> 44626669 AND `partno` = '2217484-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.008083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18725233 [ RunTime:0.004904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33107972 LIMIT 5 [ RunTime:0.004770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33107972 ORDER BY `minOrder` ASC [ RunTime:0.001827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33107972 ORDER BY `unit` DESC [ RunTime:0.001323s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33107972 LIMIT 2 [ RunTime:0.004961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33107972 ORDER BY `minOrder` ASC [ RunTime:0.001545s ]
select * from pdf where partno='2217484-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.001941s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2217484-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.005960s ]
SELECT `id` FROM `stock` WHERE `id` <> 33107972 AND `partno` = '2217484-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.001306s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18725233 [ RunTime:0.000449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58529798 LIMIT 5 [ RunTime:0.000727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58529798 ORDER BY `minOrder` ASC [ RunTime:0.001166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58529798 ORDER BY `unit` DESC [ RunTime:0.006200s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58529798 LIMIT 2 [ RunTime:0.000671s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58529798 ORDER BY `minOrder` ASC [ RunTime:0.002857s ]
select * from pdf where partno='2217400-1' and brandshort='TE Connectivity Application Tooling' limit 1 [ RunTime:0.001150s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2217400-1' OR `brand` LIKE 'TE Connectivity Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000818s ]
SELECT `id` FROM `stock` WHERE `id` <> 58529798 AND `partno` = '2217400-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity application tooling%' ) [ RunTime:0.005558s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44629096 LIMIT 5 [ RunTime:0.006378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44629096 ORDER BY `minOrder` ASC [ RunTime:0.003021s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44629096 ORDER BY `unit` DESC [ RunTime:0.001022s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44629096 LIMIT 2 [ RunTime:0.003426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44629096 ORDER BY `minOrder` ASC [ RunTime:0.003007s ]
select * from pdf where partno='2217400-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.001973s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2217400-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.003421s ]
SELECT `id` FROM `stock` WHERE `id` <> 44629096 AND `partno` = '2217400-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.002387s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18725118 [ RunTime:0.002638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44627180 LIMIT 5 [ RunTime:0.000625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44627180 ORDER BY `minOrder` ASC [ RunTime:0.002253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44627180 ORDER BY `unit` DESC [ RunTime:0.003959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44627180 LIMIT 2 [ RunTime:0.000638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44627180 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
select * from pdf where partno='2217480-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.001091s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2217480-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000755s ]
SELECT `id` FROM `stock` WHERE `id` <> 44627180 AND `partno` = '2217480-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.001028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15211292 [ RunTime:0.003920s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44010492 LIMIT 5 [ RunTime:0.000666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44010492 ORDER BY `minOrder` ASC [ RunTime:0.004226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44010492 ORDER BY `unit` DESC [ RunTime:0.000649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44010492 LIMIT 2 [ RunTime:0.001389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44010492 ORDER BY `minOrder` ASC [ RunTime:0.000700s ]
select * from pdf where partno='2217414-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.002507s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2217414-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.002266s ]
SELECT `id` FROM `stock` WHERE `id` <> 44010492 AND `partno` = '2217414-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.000887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18754160 [ RunTime:0.004780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44010464 LIMIT 5 [ RunTime:0.000667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44010464 ORDER BY `minOrder` ASC [ RunTime:0.002465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44010464 ORDER BY `unit` DESC [ RunTime:0.000766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44010464 LIMIT 2 [ RunTime:0.001235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44010464 ORDER BY `minOrder` ASC [ RunTime:0.000537s ]
select * from pdf where partno='2217411-2' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.006668s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2217411-2' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.003350s ]
SELECT `id` FROM `stock` WHERE `id` <> 44010464 AND `partno` = '2217411-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.003001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18754137 [ RunTime:0.003498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44010462 LIMIT 5 [ RunTime:0.001003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44010462 ORDER BY `minOrder` ASC [ RunTime:0.000752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44010462 ORDER BY `unit` DESC [ RunTime:0.003559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44010462 LIMIT 2 [ RunTime:0.010485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44010462 ORDER BY `minOrder` ASC [ RunTime:0.000469s ]
select * from pdf where partno='2217413-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.002239s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2217413-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.009843s ]
SELECT `id` FROM `stock` WHERE `id` <> 44010462 AND `partno` = '2217413-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.005803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18754135 [ RunTime:0.006343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44010458 LIMIT 5 [ RunTime:0.002185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44010458 ORDER BY `minOrder` ASC [ RunTime:0.007085s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44010458 ORDER BY `unit` DESC [ RunTime:0.000976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44010458 LIMIT 2 [ RunTime:0.000577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44010458 ORDER BY `minOrder` ASC [ RunTime:0.001405s ]
select * from pdf where partno='2217411-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.001121s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2217411-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000569s ]
SELECT `id` FROM `stock` WHERE `id` <> 44010458 AND `partno` = '2217411-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.000623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18754132 [ RunTime:0.001456s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33110713 LIMIT 5 [ RunTime:0.003064s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33110713 ORDER BY `minOrder` ASC [ RunTime:0.005830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33110713 ORDER BY `unit` DESC [ RunTime:0.000861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33110713 LIMIT 2 [ RunTime:0.000526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33110713 ORDER BY `minOrder` ASC [ RunTime:0.000210s ]
select * from pdf where partno='2217400-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.000395s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2217400-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000192s ]
SELECT `id` FROM `stock` WHERE `id` <> 33110713 AND `partno` = '2217400-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.000471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18725118 [ RunTime:0.000169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33108678 LIMIT 5 [ RunTime:0.000252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33108678 ORDER BY `minOrder` ASC [ RunTime:0.001921s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33108678 ORDER BY `unit` DESC [ RunTime:0.001451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33108678 LIMIT 2 [ RunTime:0.000247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33108678 ORDER BY `minOrder` ASC [ RunTime:0.000173s ]
select * from pdf where partno='2217480-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.000363s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2217480-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.000180s ]
SELECT `id` FROM `stock` WHERE `id` <> 33108678 AND `partno` = '2217480-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.000407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15211292 [ RunTime:0.000947s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64530685 LIMIT 5 [ RunTime:0.000534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64530685 ORDER BY `minOrder` ASC [ RunTime:0.003593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64530685 ORDER BY `unit` DESC [ RunTime:0.004590s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64530685 LIMIT 2 [ RunTime:0.000595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64530685 ORDER BY `minOrder` ASC [ RunTime:0.000168s ]
select * from pdf where partno='22174' and brandshort='Brady Corporation' limit 1 [ RunTime:0.001114s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '22174' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.001911s ]
SELECT `id` FROM `stock` WHERE `id` <> 64530685 AND `partno` = '22174' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13554585 [ RunTime:0.001634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62970992 LIMIT 5 [ RunTime:0.000443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62970992 ORDER BY `minOrder` ASC [ RunTime:0.000635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62970992 ORDER BY `unit` DESC [ RunTime:0.000256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62970992 LIMIT 2 [ RunTime:0.000242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62970992 ORDER BY `minOrder` ASC [ RunTime:0.000570s ]
select * from pdf where partno='2217440700' and brandshort='Molex' limit 1 [ RunTime:0.000914s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2217440700' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.004949s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62970876 LIMIT 5 [ RunTime:0.002991s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62970876 ORDER BY `minOrder` ASC [ RunTime:0.000810s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62970876 ORDER BY `unit` DESC [ RunTime:0.001398s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62970876 LIMIT 2 [ RunTime:0.004428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62970876 ORDER BY `minOrder` ASC [ RunTime:0.000691s ]
select * from pdf where partno='2217440500' and brandshort='Molex' limit 1 [ RunTime:0.000716s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2217440500' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.005780s ]
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 '22174%' OR `brand` LIKE '22174%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003288s ]
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 '22174%' OR `brand` LIKE '22174%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000498s ]
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 '22174%' OR `brand` LIKE '22174%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000922s ]
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 '22174%' OR `brand` LIKE '22174%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000456s ]
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 '22174%' OR `brand` LIKE '22174%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002715s ]
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 '22174%' OR `brand` LIKE '22174%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001716s ]
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 '22174%' OR `brand` LIKE '22174%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000532s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '22174%' OR `brand` LIKE '22174%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000815s ]