SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002204s ]
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 'EJB34070%' OR `brand` LIKE 'EJB34070%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015283s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14748489 LIMIT 5 [ RunTime:0.014386s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.016225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14748489 ORDER BY `minOrder` ASC [ RunTime:0.029665s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14748489 ORDER BY `unit` DESC [ RunTime:0.044111s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14748489 LIMIT 2 [ RunTime:0.013952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14748489 ORDER BY `minOrder` ASC [ RunTime:0.013762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14748252 LIMIT 5 [ RunTime:0.028520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14748252 ORDER BY `minOrder` ASC [ RunTime:0.005240s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14748252 ORDER BY `unit` DESC [ RunTime:0.036170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14748252 LIMIT 2 [ RunTime:0.078077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14748252 ORDER BY `minOrder` ASC [ RunTime:0.019473s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14747897 LIMIT 5 [ RunTime:0.037751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14747897 ORDER BY `minOrder` ASC [ RunTime:0.077174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14747897 ORDER BY `unit` DESC [ RunTime:0.046766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14747897 LIMIT 2 [ RunTime:0.040634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14747897 ORDER BY `minOrder` ASC [ RunTime:0.019583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14747532 LIMIT 5 [ RunTime:0.023292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14747532 ORDER BY `minOrder` ASC [ RunTime:0.020900s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14747532 ORDER BY `unit` DESC [ RunTime:0.010410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14747532 LIMIT 2 [ RunTime:0.014317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14747532 ORDER BY `minOrder` ASC [ RunTime:0.004192s ]
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 'EJB34070%' OR `brand` LIKE 'EJB34070%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014958s ]
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 'EJB34070%' OR `brand` LIKE 'EJB34070%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019449s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42068284 LIMIT 5 [ RunTime:0.012500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42068284 ORDER BY `minOrder` ASC [ RunTime:0.013598s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42068284 ORDER BY `unit` DESC [ RunTime:0.006338s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42068284 LIMIT 2 [ RunTime:0.004080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42068284 ORDER BY `minOrder` ASC [ RunTime:0.004199s ]
select * from pdf where partno='EJB34070AABASA' and brandshort='Schneider Electric' limit 1 [ RunTime:0.010510s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003526s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EJB34070AABASA' OR `brand` LIKE 'Schneider Electric%' ) ) LIMIT 1 [ RunTime:0.023154s ]
SELECT `id` FROM `stock` WHERE `id` <> 42068284 AND `partno` = 'EJB34070AABASA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schneider electric%' ) [ RunTime:0.019595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14748489 [ RunTime:0.014776s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42066795 LIMIT 5 [ RunTime:0.008150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42066795 ORDER BY `minOrder` ASC [ RunTime:0.020719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42066795 ORDER BY `unit` DESC [ RunTime:0.017109s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42066795 LIMIT 2 [ RunTime:0.004718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42066795 ORDER BY `minOrder` ASC [ RunTime:0.006248s ]
select * from pdf where partno='EJB34070SA' and brandshort='Schneider Electric' limit 1 [ RunTime:0.023881s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EJB34070SA' OR `brand` LIKE 'Schneider Electric%' ) ) LIMIT 1 [ RunTime:0.011415s ]
SELECT `id` FROM `stock` WHERE `id` <> 42066795 AND `partno` = 'EJB34070SA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schneider electric%' ) [ RunTime:0.034568s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14748252 [ RunTime:0.019223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42065345 LIMIT 5 [ RunTime:0.021068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42065345 ORDER BY `minOrder` ASC [ RunTime:0.031716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42065345 ORDER BY `unit` DESC [ RunTime:0.004736s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42065345 LIMIT 2 [ RunTime:0.021070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42065345 ORDER BY `minOrder` ASC [ RunTime:0.008480s ]
select * from pdf where partno='EJB34070AABA' and brandshort='Schneider Electric' limit 1 [ RunTime:0.015296s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EJB34070AABA' OR `brand` LIKE 'Schneider Electric%' ) ) LIMIT 1 [ RunTime:0.010593s ]
SELECT `id` FROM `stock` WHERE `id` <> 42065345 AND `partno` = 'EJB34070AABA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schneider electric%' ) [ RunTime:0.028877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14747897 [ RunTime:0.016529s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42064302 LIMIT 5 [ RunTime:0.017525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42064302 ORDER BY `minOrder` ASC [ RunTime:0.015872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42064302 ORDER BY `unit` DESC [ RunTime:0.004820s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42064302 LIMIT 2 [ RunTime:0.023458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42064302 ORDER BY `minOrder` ASC [ RunTime:0.012330s ]
select * from pdf where partno='EJB34070' and brandshort='Schneider Electric' limit 1 [ RunTime:0.036180s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EJB34070' OR `brand` LIKE 'Schneider Electric%' ) ) LIMIT 1 [ RunTime:0.013016s ]
SELECT `id` FROM `stock` WHERE `id` <> 42064302 AND `partno` = 'EJB34070' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schneider electric%' ) [ RunTime:0.004578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14747532 [ RunTime:0.005504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42061925 LIMIT 5 [ RunTime:0.016955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42061925 ORDER BY `minOrder` ASC [ RunTime:0.012152s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42061925 ORDER BY `unit` DESC [ RunTime:0.017636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42061925 LIMIT 2 [ RunTime:0.015782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42061925 ORDER BY `minOrder` ASC [ RunTime:0.020438s ]
select * from pdf where partno='EJB34070RP' and brandshort='Schneider Electric' limit 1 [ RunTime:0.006025s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'EJB34070RP' OR `brand` LIKE 'Schneider Electric%' ) ) LIMIT 1 [ RunTime:0.025778s ]
SELECT `id` FROM `stock` WHERE `id` <> 42061925 AND `partno` = 'EJB34070RP' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schneider electric%' ) [ RunTime:0.025295s ]
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 'EJB34070%' OR `brand` LIKE 'EJB34070%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015575s ]
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 'EJB34070%' OR `brand` LIKE 'EJB34070%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001115s ]
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 'EJB34070%' OR `brand` LIKE 'EJB34070%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008325s ]
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 'EJB34070%' OR `brand` LIKE 'EJB34070%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029528s ]
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 'EJB34070%' OR `brand` LIKE 'EJB34070%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020627s ]
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 'EJB34070%' OR `brand` LIKE 'EJB34070%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006727s ]
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 'EJB34070%' OR `brand` LIKE 'EJB34070%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000765s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'EJB34070%' OR `brand` LIKE 'EJB34070%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.009952s ]