SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001339s ]
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 'XBMZBF6%' OR `brand` LIKE 'XBMZBF6%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003353s ]
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 'XBMZBF6%' OR `brand` LIKE 'XBMZBF6%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031035s ]
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 'XBMZBF6%' OR `brand` LIKE 'XBMZBF6%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018327s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.003794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60623001 LIMIT 5 [ RunTime:0.028253s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.025601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60623001 ORDER BY `minOrder` ASC [ RunTime:0.026593s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60623001 ORDER BY `unit` DESC [ RunTime:0.026266s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60623001 LIMIT 2 [ RunTime:0.016748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60623001 ORDER BY `minOrder` ASC [ RunTime:0.016840s ]
select * from pdf where partno='XBMZBF6H/61' and brandshort='Eaton Electrical' limit 1 [ RunTime:0.023516s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001848s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XBMZBF6H/61' OR `brand` LIKE 'Eaton Electrical%' ) ) LIMIT 1 [ RunTime:0.015038s ]
SELECT `id` FROM `stock` WHERE `id` <> 60623001 AND `partno` = 'XBMZBF6H/61' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.027835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60622999 LIMIT 5 [ RunTime:0.024388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622999 ORDER BY `minOrder` ASC [ RunTime:0.027800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60622999 ORDER BY `unit` DESC [ RunTime:0.021204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60622999 LIMIT 2 [ RunTime:0.022434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622999 ORDER BY `minOrder` ASC [ RunTime:0.017932s ]
select * from pdf where partno='XBMZBF6V/21' and brandshort='Eaton Electrical' limit 1 [ RunTime:0.027954s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XBMZBF6V/21' OR `brand` LIKE 'Eaton Electrical%' ) ) LIMIT 1 [ RunTime:0.050516s ]
SELECT `id` FROM `stock` WHERE `id` <> 60622999 AND `partno` = 'XBMZBF6V/21' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.028451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60622994 LIMIT 5 [ RunTime:0.030224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622994 ORDER BY `minOrder` ASC [ RunTime:0.017541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60622994 ORDER BY `unit` DESC [ RunTime:0.012848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60622994 LIMIT 2 [ RunTime:0.022797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622994 ORDER BY `minOrder` ASC [ RunTime:0.015155s ]
select * from pdf where partno='XBMZBF6H/21' and brandshort='Eaton Electrical' limit 1 [ RunTime:0.006267s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XBMZBF6H/21' OR `brand` LIKE 'Eaton Electrical%' ) ) LIMIT 1 [ RunTime:0.008900s ]
SELECT `id` FROM `stock` WHERE `id` <> 60622994 AND `partno` = 'XBMZBF6H/21' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.013490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60622990 LIMIT 5 [ RunTime:0.006890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622990 ORDER BY `minOrder` ASC [ RunTime:0.005295s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60622990 ORDER BY `unit` DESC [ RunTime:0.017181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60622990 LIMIT 2 [ RunTime:0.014628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622990 ORDER BY `minOrder` ASC [ RunTime:0.009332s ]
select * from pdf where partno='XBMZBF6V/41' and brandshort='Eaton Electrical' limit 1 [ RunTime:0.011155s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XBMZBF6V/41' OR `brand` LIKE 'Eaton Electrical%' ) ) LIMIT 1 [ RunTime:0.008294s ]
SELECT `id` FROM `stock` WHERE `id` <> 60622990 AND `partno` = 'XBMZBF6V/41' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.028106s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60622986 LIMIT 5 [ RunTime:0.007109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622986 ORDER BY `minOrder` ASC [ RunTime:0.002807s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60622986 ORDER BY `unit` DESC [ RunTime:0.005775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60622986 LIMIT 2 [ RunTime:0.021896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622986 ORDER BY `minOrder` ASC [ RunTime:0.006227s ]
select * from pdf where partno='XBMZBF6H/1' and brandshort='Eaton Electrical' limit 1 [ RunTime:0.016439s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XBMZBF6H/1' OR `brand` LIKE 'Eaton Electrical%' ) ) LIMIT 1 [ RunTime:0.000759s ]
SELECT `id` FROM `stock` WHERE `id` <> 60622986 AND `partno` = 'XBMZBF6H/1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.005280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60622983 LIMIT 5 [ RunTime:0.004424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622983 ORDER BY `minOrder` ASC [ RunTime:0.005386s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60622983 ORDER BY `unit` DESC [ RunTime:0.015376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60622983 LIMIT 2 [ RunTime:0.009551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622983 ORDER BY `minOrder` ASC [ RunTime:0.018279s ]
select * from pdf where partno='XBMZBF6H/41' and brandshort='Eaton Electrical' limit 1 [ RunTime:0.002910s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XBMZBF6H/41' OR `brand` LIKE 'Eaton Electrical%' ) ) LIMIT 1 [ RunTime:0.003110s ]
SELECT `id` FROM `stock` WHERE `id` <> 60622983 AND `partno` = 'XBMZBF6H/41' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.001542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60622980 LIMIT 5 [ RunTime:0.004269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622980 ORDER BY `minOrder` ASC [ RunTime:0.003071s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60622980 ORDER BY `unit` DESC [ RunTime:0.000434s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60622980 LIMIT 2 [ RunTime:0.000391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622980 ORDER BY `minOrder` ASC [ RunTime:0.000406s ]
select * from pdf where partno='XBMZBF6V/61' and brandshort='Eaton Electrical' limit 1 [ RunTime:0.004762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XBMZBF6V/61' OR `brand` LIKE 'Eaton Electrical%' ) ) LIMIT 1 [ RunTime:0.007010s ]
SELECT `id` FROM `stock` WHERE `id` <> 60622980 AND `partno` = 'XBMZBF6V/61' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.000513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60622977 LIMIT 5 [ RunTime:0.009251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622977 ORDER BY `minOrder` ASC [ RunTime:0.022669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60622977 ORDER BY `unit` DESC [ RunTime:0.019839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60622977 LIMIT 2 [ RunTime:0.004874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622977 ORDER BY `minOrder` ASC [ RunTime:0.005060s ]
select * from pdf where partno='XBMZBF6V/1' and brandshort='Eaton Electrical' limit 1 [ RunTime:0.002705s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XBMZBF6V/1' OR `brand` LIKE 'Eaton Electrical%' ) ) LIMIT 1 [ RunTime:0.004302s ]
SELECT `id` FROM `stock` WHERE `id` <> 60622977 AND `partno` = 'XBMZBF6V/1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.002789s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60622973 LIMIT 5 [ RunTime:0.000437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622973 ORDER BY `minOrder` ASC [ RunTime:0.000432s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60622973 ORDER BY `unit` DESC [ RunTime:0.014423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60622973 LIMIT 2 [ RunTime:0.000824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622973 ORDER BY `minOrder` ASC [ RunTime:0.000286s ]
select * from pdf where partno='XBMZBF6H/51' and brandshort='Eaton Electrical' limit 1 [ RunTime:0.000965s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XBMZBF6H/51' OR `brand` LIKE 'Eaton Electrical%' ) ) LIMIT 1 [ RunTime:0.004939s ]
SELECT `id` FROM `stock` WHERE `id` <> 60622973 AND `partno` = 'XBMZBF6H/51' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.003284s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60622965 LIMIT 5 [ RunTime:0.000477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622965 ORDER BY `minOrder` ASC [ RunTime:0.003558s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60622965 ORDER BY `unit` DESC [ RunTime:0.000883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60622965 LIMIT 2 [ RunTime:0.007807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622965 ORDER BY `minOrder` ASC [ RunTime:0.010629s ]
select * from pdf where partno='XBMZBF6H/71' and brandshort='Eaton Electrical' limit 1 [ RunTime:0.005433s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XBMZBF6H/71' OR `brand` LIKE 'Eaton Electrical%' ) ) LIMIT 1 [ RunTime:0.012031s ]
SELECT `id` FROM `stock` WHERE `id` <> 60622965 AND `partno` = 'XBMZBF6H/71' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.010244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60622962 LIMIT 5 [ RunTime:0.007646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622962 ORDER BY `minOrder` ASC [ RunTime:0.028749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60622962 ORDER BY `unit` DESC [ RunTime:0.010248s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60622962 LIMIT 2 [ RunTime:0.005053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622962 ORDER BY `minOrder` ASC [ RunTime:0.022945s ]
select * from pdf where partno='XBMZBF6H/81' and brandshort='Eaton Electrical' limit 1 [ RunTime:0.044719s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XBMZBF6H/81' OR `brand` LIKE 'Eaton Electrical%' ) ) LIMIT 1 [ RunTime:0.012452s ]
SELECT `id` FROM `stock` WHERE `id` <> 60622962 AND `partno` = 'XBMZBF6H/81' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.031616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60622958 LIMIT 5 [ RunTime:0.026815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622958 ORDER BY `minOrder` ASC [ RunTime:0.010609s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60622958 ORDER BY `unit` DESC [ RunTime:0.020688s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60622958 LIMIT 2 [ RunTime:0.021752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622958 ORDER BY `minOrder` ASC [ RunTime:0.010490s ]
select * from pdf where partno='XBMZBF6H/91' and brandshort='Eaton Electrical' limit 1 [ RunTime:0.006140s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XBMZBF6H/91' OR `brand` LIKE 'Eaton Electrical%' ) ) LIMIT 1 [ RunTime:0.017882s ]
SELECT `id` FROM `stock` WHERE `id` <> 60622958 AND `partno` = 'XBMZBF6H/91' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.009419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60622954 LIMIT 5 [ RunTime:0.006175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622954 ORDER BY `minOrder` ASC [ RunTime:0.011441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60622954 ORDER BY `unit` DESC [ RunTime:0.008445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60622954 LIMIT 2 [ RunTime:0.000371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622954 ORDER BY `minOrder` ASC [ RunTime:0.007402s ]
select * from pdf where partno='XBMZBF6V/31' and brandshort='Eaton Electrical' limit 1 [ RunTime:0.011659s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XBMZBF6V/31' OR `brand` LIKE 'Eaton Electrical%' ) ) LIMIT 1 [ RunTime:0.004997s ]
SELECT `id` FROM `stock` WHERE `id` <> 60622954 AND `partno` = 'XBMZBF6V/31' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.015629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60622953 LIMIT 5 [ RunTime:0.003623s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622953 ORDER BY `minOrder` ASC [ RunTime:0.013316s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60622953 ORDER BY `unit` DESC [ RunTime:0.010162s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60622953 LIMIT 2 [ RunTime:0.019132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622953 ORDER BY `minOrder` ASC [ RunTime:0.009780s ]
select * from pdf where partno='XBMZBF6V/51' and brandshort='Eaton Electrical' limit 1 [ RunTime:0.018645s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XBMZBF6V/51' OR `brand` LIKE 'Eaton Electrical%' ) ) LIMIT 1 [ RunTime:0.014623s ]
SELECT `id` FROM `stock` WHERE `id` <> 60622953 AND `partno` = 'XBMZBF6V/51' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.014063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60622950 LIMIT 5 [ RunTime:0.010505s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622950 ORDER BY `minOrder` ASC [ RunTime:0.000974s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60622950 ORDER BY `unit` DESC [ RunTime:0.026148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60622950 LIMIT 2 [ RunTime:0.013943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622950 ORDER BY `minOrder` ASC [ RunTime:0.000828s ]
select * from pdf where partno='XBMZBF6H/11' and brandshort='Eaton Electrical' limit 1 [ RunTime:0.001426s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XBMZBF6H/11' OR `brand` LIKE 'Eaton Electrical%' ) ) LIMIT 1 [ RunTime:0.007796s ]
SELECT `id` FROM `stock` WHERE `id` <> 60622950 AND `partno` = 'XBMZBF6H/11' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.007460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60622947 LIMIT 5 [ RunTime:0.020242s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622947 ORDER BY `minOrder` ASC [ RunTime:0.004505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60622947 ORDER BY `unit` DESC [ RunTime:0.021881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60622947 LIMIT 2 [ RunTime:0.013594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622947 ORDER BY `minOrder` ASC [ RunTime:0.013082s ]
select * from pdf where partno='XBMZBF6V/11' and brandshort='Eaton Electrical' limit 1 [ RunTime:0.007767s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XBMZBF6V/11' OR `brand` LIKE 'Eaton Electrical%' ) ) LIMIT 1 [ RunTime:0.010542s ]
SELECT `id` FROM `stock` WHERE `id` <> 60622947 AND `partno` = 'XBMZBF6V/11' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.002514s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60622946 LIMIT 5 [ RunTime:0.041842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622946 ORDER BY `minOrder` ASC [ RunTime:0.005539s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60622946 ORDER BY `unit` DESC [ RunTime:0.013155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60622946 LIMIT 2 [ RunTime:0.028310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622946 ORDER BY `minOrder` ASC [ RunTime:0.012532s ]
select * from pdf where partno='XBMZBF6H/31' and brandshort='Eaton Electrical' limit 1 [ RunTime:0.015585s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XBMZBF6H/31' OR `brand` LIKE 'Eaton Electrical%' ) ) LIMIT 1 [ RunTime:0.012494s ]
SELECT `id` FROM `stock` WHERE `id` <> 60622946 AND `partno` = 'XBMZBF6H/31' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.011388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60622945 LIMIT 5 [ RunTime:0.033538s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622945 ORDER BY `minOrder` ASC [ RunTime:0.030365s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60622945 ORDER BY `unit` DESC [ RunTime:0.012632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60622945 LIMIT 2 [ RunTime:0.021331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622945 ORDER BY `minOrder` ASC [ RunTime:0.023699s ]
select * from pdf where partno='XBMZBF6V/71' and brandshort='Eaton Electrical' limit 1 [ RunTime:0.024389s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XBMZBF6V/71' OR `brand` LIKE 'Eaton Electrical%' ) ) LIMIT 1 [ RunTime:0.021417s ]
SELECT `id` FROM `stock` WHERE `id` <> 60622945 AND `partno` = 'XBMZBF6V/71' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.036397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60622875 LIMIT 5 [ RunTime:0.013489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622875 ORDER BY `minOrder` ASC [ RunTime:0.016006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60622875 ORDER BY `unit` DESC [ RunTime:0.014748s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60622875 LIMIT 2 [ RunTime:0.034554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60622875 ORDER BY `minOrder` ASC [ RunTime:0.010129s ]
select * from pdf where partno='XBMZBF6' and brandshort='Eaton Electrical' limit 1 [ RunTime:0.006240s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XBMZBF6' OR `brand` LIKE 'Eaton Electrical%' ) ) LIMIT 1 [ RunTime:0.027632s ]
SELECT `id` FROM `stock` WHERE `id` <> 60622875 AND `partno` = 'XBMZBF6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%eaton electrical%' ) [ RunTime:0.005483s ]
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 'XBMZBF6%' OR `brand` LIKE 'XBMZBF6%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018687s ]
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 'XBMZBF6%' OR `brand` LIKE 'XBMZBF6%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033392s ]
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 'XBMZBF6%' OR `brand` LIKE 'XBMZBF6%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036386s ]
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 'XBMZBF6%' OR `brand` LIKE 'XBMZBF6%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025720s ]
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 'XBMZBF6%' OR `brand` LIKE 'XBMZBF6%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014905s ]
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 'XBMZBF6%' OR `brand` LIKE 'XBMZBF6%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012269s ]
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 'XBMZBF6%' OR `brand` LIKE 'XBMZBF6%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032735s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'XBMZBF6%' OR `brand` LIKE 'XBMZBF6%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.029758s ]