SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001305s ]
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 '13715%' OR `brand` LIKE '13715%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009331s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001325s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11185739 LIMIT 5 [ RunTime:0.013824s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11185739 ORDER BY `minOrder` ASC [ RunTime:0.000865s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003412s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11185739 ORDER BY `unit` DESC [ RunTime:0.000410s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002202s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11185739 LIMIT 2 [ RunTime:0.006221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11185739 ORDER BY `minOrder` ASC [ RunTime:0.018434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19637061 LIMIT 5 [ RunTime:0.006427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19637061 ORDER BY `minOrder` ASC [ RunTime:0.000581s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19637061 ORDER BY `unit` DESC [ RunTime:0.002828s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19637061 LIMIT 2 [ RunTime:0.010424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19637061 ORDER BY `minOrder` ASC [ RunTime:0.008759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18914327 LIMIT 5 [ RunTime:0.001155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18914327 ORDER BY `minOrder` ASC [ RunTime:0.004874s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18914327 ORDER BY `unit` DESC [ RunTime:0.001359s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18914327 LIMIT 2 [ RunTime:0.006235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18914327 ORDER BY `minOrder` ASC [ RunTime:0.000585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18914326 LIMIT 5 [ RunTime:0.006871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18914326 ORDER BY `minOrder` ASC [ RunTime:0.008951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18914326 ORDER BY `unit` DESC [ RunTime:0.000332s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18914326 LIMIT 2 [ RunTime:0.003667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18914326 ORDER BY `minOrder` ASC [ RunTime:0.006066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18914309 LIMIT 5 [ RunTime:0.007016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18914309 ORDER BY `minOrder` ASC [ RunTime:0.011045s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18914309 ORDER BY `unit` DESC [ RunTime:0.006235s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18914309 LIMIT 2 [ RunTime:0.005223s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18914309 ORDER BY `minOrder` ASC [ RunTime:0.010604s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15251272 LIMIT 5 [ RunTime:0.004415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15251272 ORDER BY `minOrder` ASC [ RunTime:0.003292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15251272 ORDER BY `unit` DESC [ RunTime:0.006049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15251272 LIMIT 2 [ RunTime:0.005267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15251272 ORDER BY `minOrder` ASC [ RunTime:0.002677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265625 LIMIT 5 [ RunTime:0.006084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265625 ORDER BY `minOrder` ASC [ RunTime:0.001041s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13265625 ORDER BY `unit` DESC [ RunTime:0.002890s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13265625 LIMIT 2 [ RunTime:0.004236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13265625 ORDER BY `minOrder` ASC [ RunTime:0.004378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12542068 LIMIT 5 [ RunTime:0.002412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12542068 ORDER BY `minOrder` ASC [ RunTime:0.000773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12542068 ORDER BY `unit` DESC [ RunTime:0.001029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12542068 LIMIT 2 [ RunTime:0.000673s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12542068 ORDER BY `minOrder` ASC [ RunTime:0.001190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12541595 LIMIT 5 [ RunTime:0.000993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12541595 ORDER BY `minOrder` ASC [ RunTime:0.002645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12541595 ORDER BY `unit` DESC [ RunTime:0.001684s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12541595 LIMIT 2 [ RunTime:0.000548s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12541595 ORDER BY `minOrder` ASC [ RunTime:0.000592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12541577 LIMIT 5 [ RunTime:0.001384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12541577 ORDER BY `minOrder` ASC [ RunTime:0.001037s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12541577 ORDER BY `unit` DESC [ RunTime:0.000685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12541577 LIMIT 2 [ RunTime:0.008357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12541577 ORDER BY `minOrder` ASC [ RunTime:0.006004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11433664 LIMIT 5 [ RunTime:0.001030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11433664 ORDER BY `minOrder` ASC [ RunTime:0.006448s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11433664 ORDER BY `unit` DESC [ RunTime:0.018441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11433664 LIMIT 2 [ RunTime:0.009627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11433664 ORDER BY `minOrder` ASC [ RunTime:0.018972s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11433663 LIMIT 5 [ RunTime:0.010851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11433663 ORDER BY `minOrder` ASC [ RunTime:0.000682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11433663 ORDER BY `unit` DESC [ RunTime:0.000710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11433663 LIMIT 2 [ RunTime:0.004273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11433663 ORDER BY `minOrder` ASC [ RunTime:0.008123s ]
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 '13715%' OR `brand` LIKE '13715%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001670s ]
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 '13715%' OR `brand` LIKE '13715%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54181200 LIMIT 5 [ RunTime:0.000592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54181200 ORDER BY `minOrder` ASC [ RunTime:0.008444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54181200 ORDER BY `unit` DESC [ RunTime:0.008029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54181200 LIMIT 2 [ RunTime:0.007636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54181200 ORDER BY `minOrder` ASC [ RunTime:0.009283s ]
select * from pdf where partno='1371570000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001769s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003804s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1371570000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.010940s ]
SELECT `id` FROM `stock` WHERE `id` <> 54181200 AND `partno` = '1371570000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.013846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12541595 [ RunTime:0.000726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54181171 LIMIT 5 [ RunTime:0.000654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54181171 ORDER BY `minOrder` ASC [ RunTime:0.009130s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54181171 ORDER BY `unit` DESC [ RunTime:0.000666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54181171 LIMIT 2 [ RunTime:0.008712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54181171 ORDER BY `minOrder` ASC [ RunTime:0.013925s ]
select * from pdf where partno='1371540000' and brandshort='Weidmüller' limit 1 [ RunTime:0.009492s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1371540000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.004529s ]
SELECT `id` FROM `stock` WHERE `id` <> 54181171 AND `partno` = '1371540000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.010756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12541577 [ RunTime:0.017383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54180865 LIMIT 5 [ RunTime:0.016458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54180865 ORDER BY `minOrder` ASC [ RunTime:0.028720s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54180865 ORDER BY `unit` DESC [ RunTime:0.027273s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54180865 LIMIT 2 [ RunTime:0.000645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54180865 ORDER BY `minOrder` ASC [ RunTime:0.000610s ]
select * from pdf where partno='1371590000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000974s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1371590000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.003159s ]
SELECT `id` FROM `stock` WHERE `id` <> 54180865 AND `partno` = '1371590000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000781s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11433664 [ RunTime:0.000808s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54180864 LIMIT 5 [ RunTime:0.002585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54180864 ORDER BY `minOrder` ASC [ RunTime:0.000595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54180864 ORDER BY `unit` DESC [ RunTime:0.000609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54180864 LIMIT 2 [ RunTime:0.000540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54180864 ORDER BY `minOrder` ASC [ RunTime:0.000593s ]
select * from pdf where partno='1371500000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000940s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1371500000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.003395s ]
SELECT `id` FROM `stock` WHERE `id` <> 54180864 AND `partno` = '1371500000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12542068 [ RunTime:0.000740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54180863 LIMIT 5 [ RunTime:0.000632s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54180863 ORDER BY `minOrder` ASC [ RunTime:0.000671s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54180863 ORDER BY `unit` DESC [ RunTime:0.000673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54180863 LIMIT 2 [ RunTime:0.000649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54180863 ORDER BY `minOrder` ASC [ RunTime:0.000598s ]
select * from pdf where partno='1371550000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000929s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1371550000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.003260s ]
SELECT `id` FROM `stock` WHERE `id` <> 54180863 AND `partno` = '1371550000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11433663 [ RunTime:0.000667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54180815 LIMIT 5 [ RunTime:0.000648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54180815 ORDER BY `minOrder` ASC [ RunTime:0.000706s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54180815 ORDER BY `unit` DESC [ RunTime:0.000669s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54180815 LIMIT 2 [ RunTime:0.000628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54180815 ORDER BY `minOrder` ASC [ RunTime:0.000663s ]
select * from pdf where partno='1371580000' and brandshort='Weidmüller' limit 1 [ RunTime:0.001023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1371580000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.003209s ]
SELECT `id` FROM `stock` WHERE `id` <> 54180815 AND `partno` = '1371580000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000825s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54180814 LIMIT 5 [ RunTime:0.000653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54180814 ORDER BY `minOrder` ASC [ RunTime:0.000667s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54180814 ORDER BY `unit` DESC [ RunTime:0.000650s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54180814 LIMIT 2 [ RunTime:0.001129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54180814 ORDER BY `minOrder` ASC [ RunTime:0.000657s ]
select * from pdf where partno='1371530000' and brandshort='Weidmüller' limit 1 [ RunTime:0.000952s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1371530000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.003154s ]
SELECT `id` FROM `stock` WHERE `id` <> 54180814 AND `partno` = '1371530000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000822s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53714380 LIMIT 5 [ RunTime:0.000948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53714380 ORDER BY `minOrder` ASC [ RunTime:0.001136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53714380 ORDER BY `unit` DESC [ RunTime:0.000673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53714380 LIMIT 2 [ RunTime:0.000638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53714380 ORDER BY `minOrder` ASC [ RunTime:0.000737s ]
select * from pdf where partno='13715.1' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.001023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '13715.1' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.002580s ]
SELECT `id` FROM `stock` WHERE `id` <> 53714380 AND `partno` = '13715.1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.000875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19637061 [ RunTime:0.000461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51233280 LIMIT 5 [ RunTime:0.000683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51233280 ORDER BY `minOrder` ASC [ RunTime:0.001231s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51233280 ORDER BY `unit` DESC [ RunTime:0.001113s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51233280 LIMIT 2 [ RunTime:0.000744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51233280 ORDER BY `minOrder` ASC [ RunTime:0.000748s ]
select * from pdf where partno='1371533' and brandshort='Dialight' limit 1 [ RunTime:0.000803s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1371533' OR `brand` LIKE 'Dialight%' ) ) LIMIT 1 [ RunTime:0.003203s ]
SELECT `id` FROM `stock` WHERE `id` <> 51233280 AND `partno` = '1371533' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dialight%' ) [ RunTime:0.000860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15251272 [ RunTime:0.000667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49676968 LIMIT 5 [ RunTime:0.007427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49676968 ORDER BY `minOrder` ASC [ RunTime:0.001917s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49676968 ORDER BY `unit` DESC [ RunTime:0.000559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49676968 LIMIT 2 [ RunTime:0.000524s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49676968 ORDER BY `minOrder` ASC [ RunTime:0.000564s ]
select * from pdf where partno='13715' and brandshort='Desco' limit 1 [ RunTime:0.001697s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '13715' OR `brand` LIKE 'Desco%' ) ) LIMIT 1 [ RunTime:0.004061s ]
SELECT `id` FROM `stock` WHERE `id` <> 49676968 AND `partno` = '13715' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%desco%' ) [ RunTime:0.001094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36870253 [ RunTime:0.000678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49419713 LIMIT 5 [ RunTime:0.000732s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49419713 ORDER BY `minOrder` ASC [ RunTime:0.002908s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49419713 ORDER BY `unit` DESC [ RunTime:0.000457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49419713 LIMIT 2 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49419713 ORDER BY `minOrder` ASC [ RunTime:0.000696s ]
select * from pdf where partno='13715' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.000802s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '13715' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.000557s ]
SELECT `id` FROM `stock` WHERE `id` <> 49419713 AND `partno` = '13715' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sparkfun electronics%' ) [ RunTime:0.000848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265625 [ RunTime:0.000442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36870253 LIMIT 5 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36870253 ORDER BY `minOrder` ASC [ RunTime:0.001164s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36870253 ORDER BY `unit` DESC [ RunTime:0.000999s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36870253 LIMIT 2 [ RunTime:0.000586s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36870253 ORDER BY `minOrder` ASC [ RunTime:0.000567s ]
select * from pdf where partno='13715' and brandshort='Desco' limit 1 [ RunTime:0.000403s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '13715' OR `brand` LIKE 'Desco%' ) ) LIMIT 1 [ RunTime:0.000379s ]
SELECT `id` FROM `stock` WHERE `id` <> 36870253 AND `partno` = '13715' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%desco%' ) [ RunTime:0.001508s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49676968 [ RunTime:0.000865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36613763 LIMIT 5 [ RunTime:0.001516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36613763 ORDER BY `minOrder` ASC [ RunTime:0.001043s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36613763 ORDER BY `unit` DESC [ RunTime:0.001042s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36613763 LIMIT 2 [ RunTime:0.000805s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36613763 ORDER BY `minOrder` ASC [ RunTime:0.001212s ]
select * from pdf where partno='13715' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.000832s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '13715' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.000308s ]
SELECT `id` FROM `stock` WHERE `id` <> 36613763 AND `partno` = '13715' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sparkfun electronics%' ) [ RunTime:0.000520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13265625 [ RunTime:0.000212s ]
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 '13715%' OR `brand` LIKE '13715%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000732s ]
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 '13715%' OR `brand` LIKE '13715%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000621s ]
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 '13715%' OR `brand` LIKE '13715%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000575s ]
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 '13715%' OR `brand` LIKE '13715%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000481s ]
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 '13715%' OR `brand` LIKE '13715%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000574s ]
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 '13715%' OR `brand` LIKE '13715%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001062s ]
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 '13715%' OR `brand` LIKE '13715%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000517s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '13715%' OR `brand` LIKE '13715%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000580s ]