SHOW FULL COLUMNS FROM `stock` [ RunTime:0.004446s ]
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 'C1206X103K1GEC%' OR `brand` LIKE 'C1206X103K1GEC%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037276s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10172861 LIMIT 5 [ RunTime:0.061074s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.057672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10172861 ORDER BY `minOrder` ASC [ RunTime:0.029171s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10172861 ORDER BY `unit` DESC [ RunTime:0.063382s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10172861 LIMIT 2 [ RunTime:0.039283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10172861 ORDER BY `minOrder` ASC [ RunTime:0.029935s ]
select * from pdf where partno='C1206X103K1GEC' and brandshort='KEMET' limit 1 [ RunTime:0.039477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10162813 LIMIT 5 [ RunTime:0.026093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10162813 ORDER BY `minOrder` ASC [ RunTime:0.037905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10162813 ORDER BY `unit` DESC [ RunTime:0.051352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10162813 LIMIT 2 [ RunTime:0.056996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10162813 ORDER BY `minOrder` ASC [ RunTime:0.032352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10159665 LIMIT 5 [ RunTime:0.050052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10159665 ORDER BY `minOrder` ASC [ RunTime:0.040685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10159665 ORDER BY `unit` DESC [ RunTime:0.024804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10159665 LIMIT 2 [ RunTime:0.006437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10159665 ORDER BY `minOrder` ASC [ RunTime:0.023408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10155692 LIMIT 5 [ RunTime:0.029445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10155692 ORDER BY `minOrder` ASC [ RunTime:0.022637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10155692 ORDER BY `unit` DESC [ RunTime:0.062829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10155692 LIMIT 2 [ RunTime:0.027131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10155692 ORDER BY `minOrder` ASC [ RunTime:0.005935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10148499 LIMIT 5 [ RunTime:0.037123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10148499 ORDER BY `minOrder` ASC [ RunTime:0.033252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10148499 ORDER BY `unit` DESC [ RunTime:0.036362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10148499 LIMIT 2 [ RunTime:0.035166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10148499 ORDER BY `minOrder` ASC [ RunTime:0.011365s ]
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 'C1206X103K1GEC%' OR `brand` LIKE 'C1206X103K1GEC%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010129s ]
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 'C1206X103K1GEC%' OR `brand` LIKE 'C1206X103K1GEC%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004848s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39814858 LIMIT 5 [ RunTime:0.003254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39814858 ORDER BY `minOrder` ASC [ RunTime:0.008203s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39814858 ORDER BY `unit` DESC [ RunTime:0.020761s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39814858 LIMIT 2 [ RunTime:0.035794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39814858 ORDER BY `minOrder` ASC [ RunTime:0.006959s ]
select * from pdf where partno='C1206X103K1GEC' and brandshort='KEMET' limit 1 [ RunTime:0.002627s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003116s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C1206X103K1GEC' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.028258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39804940 LIMIT 5 [ RunTime:0.024357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39804940 ORDER BY `minOrder` ASC [ RunTime:0.015361s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39804940 ORDER BY `unit` DESC [ RunTime:0.017379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39804940 LIMIT 2 [ RunTime:0.000641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39804940 ORDER BY `minOrder` ASC [ RunTime:0.001690s ]
select * from pdf where partno='C1206X103K1GECAUTO' and brandshort='KEMET' limit 1 [ RunTime:0.006314s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C1206X103K1GECAUTO' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.015158s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39797004 LIMIT 5 [ RunTime:0.000687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39797004 ORDER BY `minOrder` ASC [ RunTime:0.001225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39797004 ORDER BY `unit` DESC [ RunTime:0.014824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39797004 LIMIT 2 [ RunTime:0.001206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39797004 ORDER BY `minOrder` ASC [ RunTime:0.001073s ]
select * from pdf where partno='C1206X103K1GECTU' and brandshort='KEMET' limit 1 [ RunTime:0.008794s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C1206X103K1GECTU' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.007138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39793456 LIMIT 5 [ RunTime:0.002019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39793456 ORDER BY `minOrder` ASC [ RunTime:0.007569s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39793456 ORDER BY `unit` DESC [ RunTime:0.003946s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39793456 LIMIT 2 [ RunTime:0.005305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39793456 ORDER BY `minOrder` ASC [ RunTime:0.000498s ]
select * from pdf where partno='C1206X103K1GECAUTO7210' and brandshort='KEMET' limit 1 [ RunTime:0.006045s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C1206X103K1GECAUTO7210' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.014381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 39789861 LIMIT 5 [ RunTime:0.029943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39789861 ORDER BY `minOrder` ASC [ RunTime:0.023881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 39789861 ORDER BY `unit` DESC [ RunTime:0.005082s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 39789861 LIMIT 2 [ RunTime:0.010560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 39789861 ORDER BY `minOrder` ASC [ RunTime:0.004755s ]
select * from pdf where partno='C1206X103K1GEC7210' and brandshort='KEMET' limit 1 [ RunTime:0.001199s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C1206X103K1GEC7210' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.010893s ]
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 'C1206X103K1GEC%' OR `brand` LIKE 'C1206X103K1GEC%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011592s ]
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 'C1206X103K1GEC%' OR `brand` LIKE 'C1206X103K1GEC%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003179s ]
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 'C1206X103K1GEC%' OR `brand` LIKE 'C1206X103K1GEC%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019155s ]
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 'C1206X103K1GEC%' OR `brand` LIKE 'C1206X103K1GEC%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011033s ]
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 'C1206X103K1GEC%' OR `brand` LIKE 'C1206X103K1GEC%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017515s ]
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 'C1206X103K1GEC%' OR `brand` LIKE 'C1206X103K1GEC%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003914s ]
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 'C1206X103K1GEC%' OR `brand` LIKE 'C1206X103K1GEC%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014635s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'C1206X103K1GEC%' OR `brand` LIKE 'C1206X103K1GEC%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.006466s ]