SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001819s ]
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 'A011%' OR `brand` LIKE 'A011%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022751s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15012805 LIMIT 5 [ RunTime:0.005487s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15012805 ORDER BY `minOrder` ASC [ RunTime:0.005132s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15012805 ORDER BY `unit` DESC [ RunTime:0.005656s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15012805 LIMIT 2 [ RunTime:0.017339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15012805 ORDER BY `minOrder` ASC [ RunTime:0.006840s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17872888 LIMIT 5 [ RunTime:0.010296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17872888 ORDER BY `minOrder` ASC [ RunTime:0.012962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17872888 ORDER BY `unit` DESC [ RunTime:0.007956s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17872888 LIMIT 2 [ RunTime:0.004332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17872888 ORDER BY `minOrder` ASC [ RunTime:0.009001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12461000 LIMIT 5 [ RunTime:0.013857s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12461000 ORDER BY `minOrder` ASC [ RunTime:0.016943s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12461000 ORDER BY `unit` DESC [ RunTime:0.016175s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12461000 LIMIT 2 [ RunTime:0.008206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12461000 ORDER BY `minOrder` ASC [ RunTime:0.011888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17872927 LIMIT 5 [ RunTime:0.011011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17872927 ORDER BY `minOrder` ASC [ RunTime:0.005374s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17872927 ORDER BY `unit` DESC [ RunTime:0.002301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17872927 LIMIT 2 [ RunTime:0.007622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17872927 ORDER BY `minOrder` ASC [ RunTime:0.001378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11371045 LIMIT 5 [ RunTime:0.008772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11371045 ORDER BY `minOrder` ASC [ RunTime:0.039331s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11371045 ORDER BY `unit` DESC [ RunTime:0.026352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11371045 LIMIT 2 [ RunTime:0.025604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11371045 ORDER BY `minOrder` ASC [ RunTime:0.004338s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12391138 LIMIT 5 [ RunTime:0.010578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12391138 ORDER BY `minOrder` ASC [ RunTime:0.004824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12391138 ORDER BY `unit` DESC [ RunTime:0.015242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12391138 LIMIT 2 [ RunTime:0.003879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12391138 ORDER BY `minOrder` ASC [ RunTime:0.006513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 20126265 LIMIT 5 [ RunTime:0.006155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20126265 ORDER BY `minOrder` ASC [ RunTime:0.016616s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 20126265 ORDER BY `unit` DESC [ RunTime:0.004963s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 20126265 LIMIT 2 [ RunTime:0.006079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 20126265 ORDER BY `minOrder` ASC [ RunTime:0.001614s ]
select * from pdf where partno='A011-D-V-700' and brandshort='LEDdynamics' limit 1 [ RunTime:0.014327s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001653s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A011-D-V-700' OR `brand` LIKE 'LEDdynamics%' ) ) LIMIT 1 [ RunTime:0.023308s ]
SELECT `id` FROM `stock` WHERE `id` <> 20126265 AND `partno` = 'A011-D-V-700' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%leddynamics%' ) [ RunTime:0.010446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17872888 [ RunTime:0.011157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18900610 LIMIT 5 [ RunTime:0.014061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18900610 ORDER BY `minOrder` ASC [ RunTime:0.013136s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18900610 ORDER BY `unit` DESC [ RunTime:0.013122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18900610 LIMIT 2 [ RunTime:0.006567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18900610 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12461774 LIMIT 5 [ RunTime:0.013148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12461774 ORDER BY `minOrder` ASC [ RunTime:0.010756s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12461774 ORDER BY `unit` DESC [ RunTime:0.002425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12461774 LIMIT 2 [ RunTime:0.005700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12461774 ORDER BY `minOrder` ASC [ RunTime:0.002379s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12390865 LIMIT 5 [ RunTime:0.003821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12390865 ORDER BY `minOrder` ASC [ RunTime:0.000701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12390865 ORDER BY `unit` DESC [ RunTime:0.002871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12390865 LIMIT 2 [ RunTime:0.000597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12390865 ORDER BY `minOrder` ASC [ RunTime:0.000407s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11374419 LIMIT 5 [ RunTime:0.001920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11374419 ORDER BY `minOrder` ASC [ RunTime:0.008570s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11374419 ORDER BY `unit` DESC [ RunTime:0.004635s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11374419 LIMIT 2 [ RunTime:0.002330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11374419 ORDER BY `minOrder` ASC [ RunTime:0.006977s ]
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 'A011%' OR `brand` LIKE 'A011%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51109670 LIMIT 5 [ RunTime:0.021543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51109670 ORDER BY `minOrder` ASC [ RunTime:0.014036s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51109670 ORDER BY `unit` DESC [ RunTime:0.001234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51109670 LIMIT 2 [ RunTime:0.002110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51109670 ORDER BY `minOrder` ASC [ RunTime:0.002238s ]
select * from pdf where partno='a011-b' and brandshort='m5stack' limit 1 [ RunTime:0.006131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'a011-b' OR `brand` LIKE 'm5stack%' ) ) LIMIT 1 [ RunTime:0.013385s ]
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 'A011%' OR `brand` LIKE 'A011%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51297204 LIMIT 5 [ RunTime:0.000634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51297204 ORDER BY `minOrder` ASC [ RunTime:0.001190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51297204 ORDER BY `unit` DESC [ RunTime:0.003541s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51297204 LIMIT 2 [ RunTime:0.004129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51297204 ORDER BY `minOrder` ASC [ RunTime:0.003640s ]
select * from pdf where partno='A011-D-V-350' and brandshort='LEDdynamics Inc.' limit 1 [ RunTime:0.000859s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A011-D-V-350' OR `brand` LIKE 'LEDdynamics Inc.%' ) ) LIMIT 1 [ RunTime:0.004583s ]
SELECT `id` FROM `stock` WHERE `id` <> 51297204 AND `partno` = 'A011-D-V-350' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%leddynamics inc.%' ) [ RunTime:0.003072s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15012805 [ RunTime:0.003500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51297205 LIMIT 5 [ RunTime:0.006175s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51297205 ORDER BY `minOrder` ASC [ RunTime:0.000559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51297205 ORDER BY `unit` DESC [ RunTime:0.001327s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51297205 LIMIT 2 [ RunTime:0.002516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51297205 ORDER BY `minOrder` ASC [ RunTime:0.002199s ]
select * from pdf where partno='A011-D-V-700' and brandshort='LEDdynamics Inc.' limit 1 [ RunTime:0.015224s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A011-D-V-700' OR `brand` LIKE 'LEDdynamics Inc.%' ) ) LIMIT 1 [ RunTime:0.002173s ]
SELECT `id` FROM `stock` WHERE `id` <> 51297205 AND `partno` = 'A011-D-V-700' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%leddynamics inc.%' ) [ RunTime:0.005014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17872888 [ RunTime:0.006130s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51565122 LIMIT 5 [ RunTime:0.002606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51565122 ORDER BY `minOrder` ASC [ RunTime:0.002882s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51565122 ORDER BY `unit` DESC [ RunTime:0.003632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51565122 LIMIT 2 [ RunTime:0.001892s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51565122 ORDER BY `minOrder` ASC [ RunTime:0.000236s ]
select * from pdf where partno='A0110Y' and brandshort='APEM Inc.' limit 1 [ RunTime:0.000985s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A0110Y' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.001397s ]
SELECT `id` FROM `stock` WHERE `id` <> 51565122 AND `partno` = 'A0110Y' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.002092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12461000 [ RunTime:0.005019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51297913 LIMIT 5 [ RunTime:0.001721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51297913 ORDER BY `minOrder` ASC [ RunTime:0.001762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51297913 ORDER BY `unit` DESC [ RunTime:0.000825s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51297913 LIMIT 2 [ RunTime:0.000981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51297913 ORDER BY `minOrder` ASC [ RunTime:0.004087s ]
select * from pdf where partno='A011-D-V-500' and brandshort='LEDdynamics Inc.' limit 1 [ RunTime:0.004209s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A011-D-V-500' OR `brand` LIKE 'LEDdynamics Inc.%' ) ) LIMIT 1 [ RunTime:0.003363s ]
SELECT `id` FROM `stock` WHERE `id` <> 51297913 AND `partno` = 'A011-D-V-500' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%leddynamics inc.%' ) [ RunTime:0.004566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17872927 [ RunTime:0.003138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51565795 LIMIT 5 [ RunTime:0.001676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51565795 ORDER BY `minOrder` ASC [ RunTime:0.007980s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51565795 ORDER BY `unit` DESC [ RunTime:0.000505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51565795 LIMIT 2 [ RunTime:0.003984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51565795 ORDER BY `minOrder` ASC [ RunTime:0.001196s ]
select * from pdf where partno='A0111Y' and brandshort='APEM Inc.' limit 1 [ RunTime:0.001594s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A0111Y' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.003645s ]
SELECT `id` FROM `stock` WHERE `id` <> 51565795 AND `partno` = 'A0111Y' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.010385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11371045 [ RunTime:0.002879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37397842 LIMIT 5 [ RunTime:0.001511s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37397842 ORDER BY `minOrder` ASC [ RunTime:0.003977s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37397842 ORDER BY `unit` DESC [ RunTime:0.000690s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37397842 LIMIT 2 [ RunTime:0.000621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37397842 ORDER BY `minOrder` ASC [ RunTime:0.000863s ]
select * from pdf where partno='A011-B' and brandshort='M5Stack Technology Co., Ltd.' limit 1 [ RunTime:0.001531s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A011-B' OR `brand` LIKE 'M5Stack Technology Co., Ltd.%' ) ) LIMIT 1 [ RunTime:0.008117s ]
SELECT `id` FROM `stock` WHERE `id` <> 37397842 AND `partno` = 'A011-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%m5stack technology co., ltd.%' ) [ RunTime:0.001028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12391138 [ RunTime:0.001399s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 50200883 LIMIT 5 [ RunTime:0.005345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50200883 ORDER BY `minOrder` ASC [ RunTime:0.002396s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 50200883 ORDER BY `unit` DESC [ RunTime:0.002404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 50200883 LIMIT 2 [ RunTime:0.005950s ]
SELECT * FROM `stock_price` WHERE `stockid` = 50200883 ORDER BY `minOrder` ASC [ RunTime:0.000473s ]
select * from pdf where partno='A011-B' and brandshort='M5Stack Technology Co., Ltd.' limit 1 [ RunTime:0.000639s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A011-B' OR `brand` LIKE 'M5Stack Technology Co., Ltd.%' ) ) LIMIT 1 [ RunTime:0.000448s ]
SELECT `id` FROM `stock` WHERE `id` <> 50200883 AND `partno` = 'A011-B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%m5stack technology co., ltd.%' ) [ RunTime:0.001214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12391138 [ RunTime:0.000411s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51568733 LIMIT 5 [ RunTime:0.000608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51568733 ORDER BY `minOrder` ASC [ RunTime:0.008232s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51568733 ORDER BY `unit` DESC [ RunTime:0.003801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51568733 LIMIT 2 [ RunTime:0.000626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51568733 ORDER BY `minOrder` ASC [ RunTime:0.002491s ]
select * from pdf where partno='A0111X' and brandshort='APEM Inc.' limit 1 [ RunTime:0.003824s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A0111X' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.004792s ]
SELECT `id` FROM `stock` WHERE `id` <> 51568733 AND `partno` = 'A0111X' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.008027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11374419 [ RunTime:0.001812s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51568506 LIMIT 5 [ RunTime:0.004512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51568506 ORDER BY `minOrder` ASC [ RunTime:0.002905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51568506 ORDER BY `unit` DESC [ RunTime:0.009318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51568506 LIMIT 2 [ RunTime:0.000784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51568506 ORDER BY `minOrder` ASC [ RunTime:0.000460s ]
select * from pdf where partno='A0110X' and brandshort='APEM Inc.' limit 1 [ RunTime:0.001238s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A0110X' OR `brand` LIKE 'APEM Inc.%' ) ) LIMIT 1 [ RunTime:0.008290s ]
SELECT `id` FROM `stock` WHERE `id` <> 51568506 AND `partno` = 'A0110X' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apem inc.%' ) [ RunTime:0.003169s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12461774 [ RunTime:0.000720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 49683941 LIMIT 5 [ RunTime:0.000636s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49683941 ORDER BY `minOrder` ASC [ RunTime:0.001409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 49683941 ORDER BY `unit` DESC [ RunTime:0.002410s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 49683941 LIMIT 2 [ RunTime:0.009852s ]
SELECT * FROM `stock_price` WHERE `stockid` = 49683941 ORDER BY `minOrder` ASC [ RunTime:0.003449s ]
select * from pdf where partno='A011' and brandshort='TPI Test Products Int' limit 1 [ RunTime:0.001423s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A011' OR `brand` LIKE 'TPI (Test Products Int)%' ) ) LIMIT 1 [ RunTime:0.001302s ]
SELECT `id` FROM `stock` WHERE `id` <> 49683941 AND `partno` = 'A011' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tpi%' ) [ RunTime:0.021422s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18900610 [ RunTime:0.006248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36877160 LIMIT 5 [ RunTime:0.007807s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36877160 ORDER BY `minOrder` ASC [ RunTime:0.009215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36877160 ORDER BY `unit` DESC [ RunTime:0.000848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36877160 LIMIT 2 [ RunTime:0.012619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36877160 ORDER BY `minOrder` ASC [ RunTime:0.001453s ]
select * from pdf where partno='A011' and brandshort='TPI Test Products Int' limit 1 [ RunTime:0.000501s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A011' OR `brand` LIKE 'TPI (Test Products Int)%' ) ) LIMIT 1 [ RunTime:0.000605s ]
SELECT `id` FROM `stock` WHERE `id` <> 36877160 AND `partno` = 'A011' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%tpi%' ) [ RunTime:0.000915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18900610 [ RunTime:0.000408s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32490884 LIMIT 5 [ RunTime:0.003199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32490884 ORDER BY `minOrder` ASC [ RunTime:0.006349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32490884 ORDER BY `unit` DESC [ RunTime:0.000619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32490884 LIMIT 2 [ RunTime:0.002476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32490884 ORDER BY `minOrder` ASC [ RunTime:0.000315s ]
select * from pdf where partno='A011824-ASSY' and brandshort='Omega' limit 1 [ RunTime:0.003478s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A011824-ASSY' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.001595s ]
SELECT `id` FROM `stock` WHERE `id` <> 32490884 AND `partno` = 'A011824-ASSY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.001327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32490883 LIMIT 5 [ RunTime:0.002160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32490883 ORDER BY `minOrder` ASC [ RunTime:0.002529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32490883 ORDER BY `unit` DESC [ RunTime:0.008297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32490883 LIMIT 2 [ RunTime:0.001894s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32490883 ORDER BY `minOrder` ASC [ RunTime:0.000321s ]
select * from pdf where partno='A011823-ASSY' and brandshort='Omega' limit 1 [ RunTime:0.001388s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'A011823-ASSY' OR `brand` LIKE 'Omega%' ) ) LIMIT 1 [ RunTime:0.008185s ]
SELECT `id` FROM `stock` WHERE `id` <> 32490883 AND `partno` = 'A011823-ASSY' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%omega%' ) [ RunTime:0.004969s ]
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 'A011%' OR `brand` LIKE 'A011%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006474s ]
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 'A011%' OR `brand` LIKE 'A011%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008646s ]
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 'A011%' OR `brand` LIKE 'A011%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001602s ]
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 'A011%' OR `brand` LIKE 'A011%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001391s ]
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 'A011%' OR `brand` LIKE 'A011%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011607s ]
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 'A011%' OR `brand` LIKE 'A011%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002111s ]
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 'A011%' OR `brand` LIKE 'A011%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001598s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'A011%' OR `brand` LIKE 'A011%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001264s ]