SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002553s ]
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 '25556%' OR `brand` LIKE '25556%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006023s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15359637 LIMIT 5 [ RunTime:0.001497s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15359637 ORDER BY `minOrder` ASC [ RunTime:0.000601s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002361s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15359637 ORDER BY `unit` DESC [ RunTime:0.000436s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15359637 LIMIT 2 [ RunTime:0.000375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15359637 ORDER BY `minOrder` ASC [ RunTime:0.000417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19006833 LIMIT 5 [ RunTime:0.002497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19006833 ORDER BY `minOrder` ASC [ RunTime:0.001461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19006833 ORDER BY `unit` DESC [ RunTime:0.005612s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19006833 LIMIT 2 [ RunTime:0.000325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19006833 ORDER BY `minOrder` ASC [ RunTime:0.000313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14422204 LIMIT 5 [ RunTime:0.001226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14422204 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14422204 ORDER BY `unit` DESC [ RunTime:0.000305s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14422204 LIMIT 2 [ RunTime:0.000337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14422204 ORDER BY `minOrder` ASC [ RunTime:0.000300s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13659883 LIMIT 5 [ RunTime:0.000555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13659883 ORDER BY `minOrder` ASC [ RunTime:0.000307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13659883 ORDER BY `unit` DESC [ RunTime:0.000278s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13659883 LIMIT 2 [ RunTime:0.000590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13659883 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13658995 LIMIT 5 [ RunTime:0.002460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13658995 ORDER BY `minOrder` ASC [ RunTime:0.000372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13658995 ORDER BY `unit` DESC [ RunTime:0.001161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13658995 LIMIT 2 [ RunTime:0.000388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13658995 ORDER BY `minOrder` ASC [ RunTime:0.001262s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13658960 LIMIT 5 [ RunTime:0.000552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13658960 ORDER BY `minOrder` ASC [ RunTime:0.001040s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13658960 ORDER BY `unit` DESC [ RunTime:0.000241s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13658960 LIMIT 2 [ RunTime:0.000519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13658960 ORDER BY `minOrder` ASC [ RunTime:0.000363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13549087 LIMIT 5 [ RunTime:0.001444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13549087 ORDER BY `minOrder` ASC [ RunTime:0.000394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13549087 ORDER BY `unit` DESC [ RunTime:0.000515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13549087 LIMIT 2 [ RunTime:0.000476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13549087 ORDER BY `minOrder` ASC [ RunTime:0.000358s ]
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 '25556%' OR `brand` LIKE '25556%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001823s ]
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 '25556%' OR `brand` LIKE '25556%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50443196 LIMIT 5 [ RunTime:0.001140s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50443196 ORDER BY `minOrder` ASC [ RunTime:0.000724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50443196 ORDER BY `unit` DESC [ RunTime:0.002893s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50443196 LIMIT 2 [ RunTime:0.000610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50443196 ORDER BY `minOrder` ASC [ RunTime:0.000328s ]
select * from pdf where partno='2555660000' and brandshort='Weidmüller' limit 1 [ RunTime:0.004216s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001449s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2555660000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.002010s ]
SELECT `id` FROM `stock` WHERE `id` <> 50443196 AND `partno` = '2555660000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.003512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15359637 [ RunTime:0.000900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37640561 LIMIT 5 [ RunTime:0.002360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37640561 ORDER BY `minOrder` ASC [ RunTime:0.016669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37640561 ORDER BY `unit` DESC [ RunTime:0.008831s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37640561 LIMIT 2 [ RunTime:0.034531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37640561 ORDER BY `minOrder` ASC [ RunTime:0.016161s ]
select * from pdf where partno='2555660000' and brandshort='Weidmüller' limit 1 [ RunTime:0.008742s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2555660000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.003738s ]
SELECT `id` FROM `stock` WHERE `id` <> 37640561 AND `partno` = '2555660000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.000978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15359637 [ RunTime:0.000343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56261632 LIMIT 5 [ RunTime:0.000503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56261632 ORDER BY `minOrder` ASC [ RunTime:0.001458s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56261632 ORDER BY `unit` DESC [ RunTime:0.000422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56261632 LIMIT 2 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56261632 ORDER BY `minOrder` ASC [ RunTime:0.008250s ]
select * from pdf where partno='25556.9' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.010186s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25556.9' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.000908s ]
SELECT `id` FROM `stock` WHERE `id` <> 56261632 AND `partno` = '25556.9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.024495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13549087 [ RunTime:0.031945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56172419 LIMIT 5 [ RunTime:0.019400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172419 ORDER BY `minOrder` ASC [ RunTime:0.017293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56172419 ORDER BY `unit` DESC [ RunTime:0.044799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56172419 LIMIT 2 [ RunTime:0.061294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172419 ORDER BY `minOrder` ASC [ RunTime:0.037589s ]
select * from pdf where partno='2555640100' and brandshort='Weidmüller' limit 1 [ RunTime:0.108103s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2555640100' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.055967s ]
SELECT `id` FROM `stock` WHERE `id` <> 56172419 AND `partno` = '2555640100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.052888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13658995 [ RunTime:0.085055s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56172366 LIMIT 5 [ RunTime:0.061115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172366 ORDER BY `minOrder` ASC [ RunTime:0.071072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56172366 ORDER BY `unit` DESC [ RunTime:0.115051s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56172366 LIMIT 2 [ RunTime:0.001003s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172366 ORDER BY `minOrder` ASC [ RunTime:0.002567s ]
select * from pdf where partno='2555640080' and brandshort='Weidmüller' limit 1 [ RunTime:0.005939s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2555640080' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.015646s ]
SELECT `id` FROM `stock` WHERE `id` <> 56172366 AND `partno` = '2555640080' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.005481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13658960 [ RunTime:0.000931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56172185 LIMIT 5 [ RunTime:0.000624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172185 ORDER BY `minOrder` ASC [ RunTime:0.005852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56172185 ORDER BY `unit` DESC [ RunTime:0.001890s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56172185 LIMIT 2 [ RunTime:0.003349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56172185 ORDER BY `minOrder` ASC [ RunTime:0.001174s ]
select * from pdf where partno='2555640010' and brandshort='Weidmüller' limit 1 [ RunTime:0.003301s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2555640010' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.000596s ]
SELECT `id` FROM `stock` WHERE `id` <> 56172185 AND `partno` = '2555640010' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.018662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13659883 [ RunTime:0.000943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50705907 LIMIT 5 [ RunTime:0.000696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50705907 ORDER BY `minOrder` ASC [ RunTime:0.000947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50705907 ORDER BY `unit` DESC [ RunTime:0.003264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50705907 LIMIT 2 [ RunTime:0.000526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50705907 ORDER BY `minOrder` ASC [ RunTime:0.000516s ]
select * from pdf where partno='25556' and brandshort='Brady Corporation' limit 1 [ RunTime:0.002118s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25556' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.001690s ]
SELECT `id` FROM `stock` WHERE `id` <> 50705907 AND `partno` = '25556' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.001014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14422204 [ RunTime:0.001512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38090956 LIMIT 5 [ RunTime:0.004440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38090956 ORDER BY `minOrder` ASC [ RunTime:0.000948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38090956 ORDER BY `unit` DESC [ RunTime:0.000487s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38090956 LIMIT 2 [ RunTime:0.000490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38090956 ORDER BY `minOrder` ASC [ RunTime:0.000951s ]
select * from pdf where partno='25556' and brandshort='Brady Corporation' limit 1 [ RunTime:0.000468s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25556' OR `brand` LIKE 'Brady Corporation%' ) ) LIMIT 1 [ RunTime:0.000366s ]
SELECT `id` FROM `stock` WHERE `id` <> 38090956 AND `partno` = '25556' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%brady corporation%' ) [ RunTime:0.000682s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14422204 [ RunTime:0.000371s ]
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 '25556%' OR `brand` LIKE '25556%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000882s ]
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 '25556%' OR `brand` LIKE '25556%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000787s ]
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 '25556%' OR `brand` LIKE '25556%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000788s ]
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 '25556%' OR `brand` LIKE '25556%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000788s ]
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 '25556%' OR `brand` LIKE '25556%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000796s ]
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 '25556%' OR `brand` LIKE '25556%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001174s ]
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 '25556%' OR `brand` LIKE '25556%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000931s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '25556%' OR `brand` LIKE '25556%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.000844s ]