SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002784s ]
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 '19274%' OR `brand` LIKE '19274%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036079s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19659610 LIMIT 5 [ RunTime:0.015680s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.081171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19659610 ORDER BY `minOrder` ASC [ RunTime:0.031349s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007504s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19659610 ORDER BY `unit` DESC [ RunTime:0.037800s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004307s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19659610 LIMIT 2 [ RunTime:0.054491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19659610 ORDER BY `minOrder` ASC [ RunTime:0.015639s ]
select * from pdf where partno='1927496' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.070706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19626274 LIMIT 5 [ RunTime:0.035906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19626274 ORDER BY `minOrder` ASC [ RunTime:0.043315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19626274 ORDER BY `unit` DESC [ RunTime:0.035600s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19626274 LIMIT 2 [ RunTime:0.079082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19626274 ORDER BY `minOrder` ASC [ RunTime:0.075927s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417247 LIMIT 5 [ RunTime:0.021790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417247 ORDER BY `minOrder` ASC [ RunTime:0.112684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14417247 ORDER BY `unit` DESC [ RunTime:0.149211s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14417247 LIMIT 2 [ RunTime:0.083592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14417247 ORDER BY `minOrder` ASC [ RunTime:0.016615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13546268 LIMIT 5 [ RunTime:0.033121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13546268 ORDER BY `minOrder` ASC [ RunTime:0.048818s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13546268 ORDER BY `unit` DESC [ RunTime:0.095555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13546268 LIMIT 2 [ RunTime:0.031189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13546268 ORDER BY `minOrder` ASC [ RunTime:0.053904s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13546224 LIMIT 5 [ RunTime:0.127197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13546224 ORDER BY `minOrder` ASC [ RunTime:0.081079s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13546224 ORDER BY `unit` DESC [ RunTime:0.073459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13546224 LIMIT 2 [ RunTime:0.027061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13546224 ORDER BY `minOrder` ASC [ RunTime:0.043523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13544037 LIMIT 5 [ RunTime:0.039687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13544037 ORDER BY `minOrder` ASC [ RunTime:0.068552s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13544037 ORDER BY `unit` DESC [ RunTime:0.072911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13544037 LIMIT 2 [ RunTime:0.085952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13544037 ORDER BY `minOrder` ASC [ RunTime:0.031581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13259733 LIMIT 5 [ RunTime:0.015304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13259733 ORDER BY `minOrder` ASC [ RunTime:0.056365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13259733 ORDER BY `unit` DESC [ RunTime:0.045846s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13259733 LIMIT 2 [ RunTime:0.037949s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13259733 ORDER BY `minOrder` ASC [ RunTime:0.015262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13110490 LIMIT 5 [ RunTime:0.044008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13110490 ORDER BY `minOrder` ASC [ RunTime:0.101592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13110490 ORDER BY `unit` DESC [ RunTime:0.054171s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13110490 LIMIT 2 [ RunTime:0.051839s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13110490 ORDER BY `minOrder` ASC [ RunTime:0.013051s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12557665 LIMIT 5 [ RunTime:0.031736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12557665 ORDER BY `minOrder` ASC [ RunTime:0.072794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12557665 ORDER BY `unit` DESC [ RunTime:0.041872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12557665 LIMIT 2 [ RunTime:0.032980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12557665 ORDER BY `minOrder` ASC [ RunTime:0.023249s ]
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 '19274%' OR `brand` LIKE '19274%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012902s ]
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 '19274%' OR `brand` LIKE '19274%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57422914 LIMIT 5 [ RunTime:0.023837s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57422914 ORDER BY `minOrder` ASC [ RunTime:0.059968s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57422914 ORDER BY `unit` DESC [ RunTime:0.016464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57422914 LIMIT 2 [ RunTime:0.038062s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57422914 ORDER BY `minOrder` ASC [ RunTime:0.034888s ]
select * from pdf where partno='19274' and brandshort='SparkFun Electronics' limit 1 [ RunTime:0.026558s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002375s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19274' OR `brand` LIKE 'SparkFun Electronics%' ) ) LIMIT 1 [ RunTime:0.018021s ]
SELECT `id` FROM `stock` WHERE `id` <> 57422914 AND `partno` = '19274' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sparkfun electronics%' ) [ RunTime:0.029762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13259733 [ RunTime:0.019402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56337163 LIMIT 5 [ RunTime:0.098462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56337163 ORDER BY `minOrder` ASC [ RunTime:0.017679s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56337163 ORDER BY `unit` DESC [ RunTime:0.036462s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56337163 LIMIT 2 [ RunTime:0.017325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56337163 ORDER BY `minOrder` ASC [ RunTime:0.047243s ]
select * from pdf where partno='19274.7' and brandshort='Pflitsch' limit 1 [ RunTime:0.070055s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19274.7' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.061792s ]
SELECT `id` FROM `stock` WHERE `id` <> 56337163 AND `partno` = '19274.7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.042252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13544037 [ RunTime:0.133785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56331269 LIMIT 5 [ RunTime:0.076205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56331269 ORDER BY `minOrder` ASC [ RunTime:0.070641s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56331269 ORDER BY `unit` DESC [ RunTime:0.084781s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56331269 LIMIT 2 [ RunTime:0.052656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56331269 ORDER BY `minOrder` ASC [ RunTime:0.075519s ]
select * from pdf where partno='19274.6' and brandshort='Pflitsch' limit 1 [ RunTime:0.036573s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19274.6' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.026260s ]
SELECT `id` FROM `stock` WHERE `id` <> 56331269 AND `partno` = '19274.6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.077031s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14417247 [ RunTime:0.191906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56329236 LIMIT 5 [ RunTime:0.087834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56329236 ORDER BY `minOrder` ASC [ RunTime:0.110156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56329236 ORDER BY `unit` DESC [ RunTime:0.137690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56329236 LIMIT 2 [ RunTime:0.049788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56329236 ORDER BY `minOrder` ASC [ RunTime:0.094714s ]
select * from pdf where partno='19274.4' and brandshort='Pflitsch' limit 1 [ RunTime:0.033813s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19274.4' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.160952s ]
SELECT `id` FROM `stock` WHERE `id` <> 56329236 AND `partno` = '19274.4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.092829s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13546224 [ RunTime:0.050489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56329094 LIMIT 5 [ RunTime:0.117080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56329094 ORDER BY `minOrder` ASC [ RunTime:0.055693s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56329094 ORDER BY `unit` DESC [ RunTime:0.061346s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56329094 LIMIT 2 [ RunTime:0.023322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56329094 ORDER BY `minOrder` ASC [ RunTime:0.039628s ]
select * from pdf where partno='19274.5' and brandshort='Pflitsch' limit 1 [ RunTime:0.052280s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19274.5' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.027779s ]
SELECT `id` FROM `stock` WHERE `id` <> 56329094 AND `partno` = '19274.5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.029224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13546268 [ RunTime:0.034170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53700327 LIMIT 5 [ RunTime:0.037103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53700327 ORDER BY `minOrder` ASC [ RunTime:0.029982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53700327 ORDER BY `unit` DESC [ RunTime:0.020389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53700327 LIMIT 2 [ RunTime:0.013369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53700327 ORDER BY `minOrder` ASC [ RunTime:0.017209s ]
select * from pdf where partno='1927483' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.026966s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1927483' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.037648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53584468 LIMIT 5 [ RunTime:0.021993s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53584468 ORDER BY `minOrder` ASC [ RunTime:0.121379s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53584468 ORDER BY `unit` DESC [ RunTime:0.035072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53584468 LIMIT 2 [ RunTime:0.051702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53584468 ORDER BY `minOrder` ASC [ RunTime:0.016217s ]
select * from pdf where partno='1927480000' and brandshort='Weidmüller' limit 1 [ RunTime:0.018188s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1927480000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.053561s ]
SELECT `id` FROM `stock` WHERE `id` <> 53584468 AND `partno` = '1927480000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.031046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13110490 [ RunTime:0.066728s ]
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 '19274%' OR `brand` LIKE '19274%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024160s ]
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 '19274%' OR `brand` LIKE '19274%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.117245s ]
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 '19274%' OR `brand` LIKE '19274%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.099904s ]
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 '19274%' OR `brand` LIKE '19274%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.086709s ]
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 '19274%' OR `brand` LIKE '19274%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.130531s ]
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 '19274%' OR `brand` LIKE '19274%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.076225s ]
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 '19274%' OR `brand` LIKE '19274%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.101622s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '19274%' OR `brand` LIKE '19274%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.033215s ]