SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002042s ]
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 '12201%' OR `brand` LIKE '12201%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021407s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001349s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19280366 LIMIT 5 [ RunTime:0.008510s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19280366 ORDER BY `minOrder` ASC [ RunTime:0.006616s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19280366 ORDER BY `unit` DESC [ RunTime:0.006586s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19280366 LIMIT 2 [ RunTime:0.034835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19280366 ORDER BY `minOrder` ASC [ RunTime:0.013305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17147477 LIMIT 5 [ RunTime:0.014178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17147477 ORDER BY `minOrder` ASC [ RunTime:0.003744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17147477 ORDER BY `unit` DESC [ RunTime:0.005158s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17147477 LIMIT 2 [ RunTime:0.016696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17147477 ORDER BY `minOrder` ASC [ RunTime:0.005035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15367552 LIMIT 5 [ RunTime:0.016127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15367552 ORDER BY `minOrder` ASC [ RunTime:0.004865s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15367552 ORDER BY `unit` DESC [ RunTime:0.018161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15367552 LIMIT 2 [ RunTime:0.027128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15367552 ORDER BY `minOrder` ASC [ RunTime:0.012011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11195641 LIMIT 5 [ RunTime:0.010543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11195641 ORDER BY `minOrder` ASC [ RunTime:0.024418s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11195641 ORDER BY `unit` DESC [ RunTime:0.038788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11195641 LIMIT 2 [ RunTime:0.035432s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11195641 ORDER BY `minOrder` ASC [ RunTime:0.002935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15235929 LIMIT 5 [ RunTime:0.015046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15235929 ORDER BY `minOrder` ASC [ RunTime:0.026101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15235929 ORDER BY `unit` DESC [ RunTime:0.013079s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15235929 LIMIT 2 [ RunTime:0.046932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15235929 ORDER BY `minOrder` ASC [ RunTime:0.009151s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835820 LIMIT 5 [ RunTime:0.029762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835820 ORDER BY `minOrder` ASC [ RunTime:0.035662s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18835820 ORDER BY `unit` DESC [ RunTime:0.030213s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18835820 LIMIT 2 [ RunTime:0.037986s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835820 ORDER BY `minOrder` ASC [ RunTime:0.007186s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837648 LIMIT 5 [ RunTime:0.028403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837648 ORDER BY `minOrder` ASC [ RunTime:0.018682s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18837648 ORDER BY `unit` DESC [ RunTime:0.029457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18837648 LIMIT 2 [ RunTime:0.027267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837648 ORDER BY `minOrder` ASC [ RunTime:0.005973s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837390 LIMIT 5 [ RunTime:0.030153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837390 ORDER BY `minOrder` ASC [ RunTime:0.031672s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18837390 ORDER BY `unit` DESC [ RunTime:0.019687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18837390 LIMIT 2 [ RunTime:0.021081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837390 ORDER BY `minOrder` ASC [ RunTime:0.007222s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18837372 LIMIT 5 [ RunTime:0.012348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837372 ORDER BY `minOrder` ASC [ RunTime:0.016291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18837372 ORDER BY `unit` DESC [ RunTime:0.014071s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18837372 LIMIT 2 [ RunTime:0.007923s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18837372 ORDER BY `minOrder` ASC [ RunTime:0.000479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835822 LIMIT 5 [ RunTime:0.002153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835822 ORDER BY `minOrder` ASC [ RunTime:0.004870s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18835822 ORDER BY `unit` DESC [ RunTime:0.007751s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18835822 LIMIT 2 [ RunTime:0.008536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835822 ORDER BY `minOrder` ASC [ RunTime:0.005496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835816 LIMIT 5 [ RunTime:0.008917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835816 ORDER BY `minOrder` ASC [ RunTime:0.013056s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18835816 ORDER BY `unit` DESC [ RunTime:0.006844s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18835816 LIMIT 2 [ RunTime:0.007177s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835816 ORDER BY `minOrder` ASC [ RunTime:0.000966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835813 LIMIT 5 [ RunTime:0.009363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835813 ORDER BY `minOrder` ASC [ RunTime:0.008806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18835813 ORDER BY `unit` DESC [ RunTime:0.020868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18835813 LIMIT 2 [ RunTime:0.000393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835813 ORDER BY `minOrder` ASC [ RunTime:0.000205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835338 LIMIT 5 [ RunTime:0.002226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835338 ORDER BY `minOrder` ASC [ RunTime:0.001173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18835338 ORDER BY `unit` DESC [ RunTime:0.000896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18835338 LIMIT 2 [ RunTime:0.017247s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18835338 ORDER BY `minOrder` ASC [ RunTime:0.001496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18834806 LIMIT 5 [ RunTime:0.005634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18834806 ORDER BY `minOrder` ASC [ RunTime:0.009103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18834806 ORDER BY `unit` DESC [ RunTime:0.006964s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18834806 LIMIT 2 [ RunTime:0.010859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18834806 ORDER BY `minOrder` ASC [ RunTime:0.004877s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17021600 LIMIT 5 [ RunTime:0.013896s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17021600 ORDER BY `minOrder` ASC [ RunTime:0.000354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17021600 ORDER BY `unit` DESC [ RunTime:0.000297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17021600 LIMIT 2 [ RunTime:0.003520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17021600 ORDER BY `minOrder` ASC [ RunTime:0.006278s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17021542 LIMIT 5 [ RunTime:0.000878s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17021542 ORDER BY `minOrder` ASC [ RunTime:0.001388s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17021542 ORDER BY `unit` DESC [ RunTime:0.002336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17021542 LIMIT 2 [ RunTime:0.000526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17021542 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17021541 LIMIT 5 [ RunTime:0.008904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17021541 ORDER BY `minOrder` ASC [ RunTime:0.007464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17021541 ORDER BY `unit` DESC [ RunTime:0.015347s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17021541 LIMIT 2 [ RunTime:0.014850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17021541 ORDER BY `minOrder` ASC [ RunTime:0.000654s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17021531 LIMIT 5 [ RunTime:0.002828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17021531 ORDER BY `minOrder` ASC [ RunTime:0.023696s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17021531 ORDER BY `unit` DESC [ RunTime:0.004447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17021531 LIMIT 2 [ RunTime:0.013401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17021531 ORDER BY `minOrder` ASC [ RunTime:0.007745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17021073 LIMIT 5 [ RunTime:0.033557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17021073 ORDER BY `minOrder` ASC [ RunTime:0.011020s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17021073 ORDER BY `unit` DESC [ RunTime:0.016923s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17021073 LIMIT 2 [ RunTime:0.012599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17021073 ORDER BY `minOrder` ASC [ RunTime:0.005901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17021069 LIMIT 5 [ RunTime:0.003816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17021069 ORDER BY `minOrder` ASC [ RunTime:0.000571s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17021069 ORDER BY `unit` DESC [ RunTime:0.015421s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17021069 LIMIT 2 [ RunTime:0.004877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17021069 ORDER BY `minOrder` ASC [ RunTime:0.006772s ]
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 '12201%' OR `brand` LIKE '12201%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032125s ]
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 '12201%' OR `brand` LIKE '12201%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015862s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60409638 LIMIT 5 [ RunTime:0.005467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409638 ORDER BY `minOrder` ASC [ RunTime:0.002881s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60409638 ORDER BY `unit` DESC [ RunTime:0.005722s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60409638 LIMIT 2 [ RunTime:0.005756s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409638 ORDER BY `minOrder` ASC [ RunTime:0.003461s ]
select * from pdf where partno='122010400' and brandshort='American Electrical Inc.' limit 1 [ RunTime:0.000937s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002516s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '122010400' OR `brand` LIKE 'American Electrical Inc.%' ) ) LIMIT 1 [ RunTime:0.004891s ]
SELECT `id` FROM `stock` WHERE `id` <> 60409638 AND `partno` = '122010400' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%american electrical inc.%' ) [ RunTime:0.005234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60409802 LIMIT 5 [ RunTime:0.001174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409802 ORDER BY `minOrder` ASC [ RunTime:0.013503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60409802 ORDER BY `unit` DESC [ RunTime:0.008706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60409802 LIMIT 2 [ RunTime:0.009703s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409802 ORDER BY `minOrder` ASC [ RunTime:0.013310s ]
select * from pdf where partno='122010150' and brandshort='American Electrical Inc.' limit 1 [ RunTime:0.006250s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '122010150' OR `brand` LIKE 'American Electrical Inc.%' ) ) LIMIT 1 [ RunTime:0.016761s ]
SELECT `id` FROM `stock` WHERE `id` <> 60409802 AND `partno` = '122010150' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%american electrical inc.%' ) [ RunTime:0.016750s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60409816 LIMIT 5 [ RunTime:0.019269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409816 ORDER BY `minOrder` ASC [ RunTime:0.011436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60409816 ORDER BY `unit` DESC [ RunTime:0.007710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60409816 LIMIT 2 [ RunTime:0.017126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409816 ORDER BY `minOrder` ASC [ RunTime:0.003817s ]
select * from pdf where partno='122010250' and brandshort='American Electrical Inc.' limit 1 [ RunTime:0.002179s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '122010250' OR `brand` LIKE 'American Electrical Inc.%' ) ) LIMIT 1 [ RunTime:0.008247s ]
SELECT `id` FROM `stock` WHERE `id` <> 60409816 AND `partno` = '122010250' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%american electrical inc.%' ) [ RunTime:0.006684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60409870 LIMIT 5 [ RunTime:0.020454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409870 ORDER BY `minOrder` ASC [ RunTime:0.030253s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60409870 ORDER BY `unit` DESC [ RunTime:0.007367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60409870 LIMIT 2 [ RunTime:0.021526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409870 ORDER BY `minOrder` ASC [ RunTime:0.007676s ]
select * from pdf where partno='1220110' and brandshort='American Electrical Inc.' limit 1 [ RunTime:0.050483s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220110' OR `brand` LIKE 'American Electrical Inc.%' ) ) LIMIT 1 [ RunTime:0.005415s ]
SELECT `id` FROM `stock` WHERE `id` <> 60409870 AND `partno` = '1220110' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%american electrical inc.%' ) [ RunTime:0.061231s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60488224 LIMIT 5 [ RunTime:0.052476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60488224 ORDER BY `minOrder` ASC [ RunTime:0.045594s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60488224 ORDER BY `unit` DESC [ RunTime:0.022170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60488224 LIMIT 2 [ RunTime:0.019886s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60488224 ORDER BY `minOrder` ASC [ RunTime:0.032627s ]
select * from pdf where partno='1220119' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.043065s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220119' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.042934s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60409877 LIMIT 5 [ RunTime:0.017916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409877 ORDER BY `minOrder` ASC [ RunTime:0.061387s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60409877 ORDER BY `unit` DESC [ RunTime:0.008752s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60409877 LIMIT 2 [ RunTime:0.027414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409877 ORDER BY `minOrder` ASC [ RunTime:0.014211s ]
select * from pdf where partno='1220116' and brandshort='American Electrical Inc.' limit 1 [ RunTime:0.016432s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220116' OR `brand` LIKE 'American Electrical Inc.%' ) ) LIMIT 1 [ RunTime:0.032074s ]
SELECT `id` FROM `stock` WHERE `id` <> 60409877 AND `partno` = '1220116' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%american electrical inc.%' ) [ RunTime:0.008439s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60409940 LIMIT 5 [ RunTime:0.032916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409940 ORDER BY `minOrder` ASC [ RunTime:0.039356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60409940 ORDER BY `unit` DESC [ RunTime:0.019149s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60409940 LIMIT 2 [ RunTime:0.011884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60409940 ORDER BY `minOrder` ASC [ RunTime:0.021023s ]
select * from pdf where partno='1220135' and brandshort='American Electrical Inc.' limit 1 [ RunTime:0.006246s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220135' OR `brand` LIKE 'American Electrical Inc.%' ) ) LIMIT 1 [ RunTime:0.016295s ]
SELECT `id` FROM `stock` WHERE `id` <> 60409940 AND `partno` = '1220135' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%american electrical inc.%' ) [ RunTime:0.036482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58546216 LIMIT 5 [ RunTime:0.009526s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58546216 ORDER BY `minOrder` ASC [ RunTime:0.016884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58546216 ORDER BY `unit` DESC [ RunTime:0.014664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58546216 LIMIT 2 [ RunTime:0.033784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58546216 ORDER BY `minOrder` ASC [ RunTime:0.014516s ]
select * from pdf where partno='12201' and brandshort='Aven Tools' limit 1 [ RunTime:0.015332s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '12201' OR `brand` LIKE 'Aven Tools%' ) ) LIMIT 1 [ RunTime:0.021157s ]
SELECT `id` FROM `stock` WHERE `id` <> 58546216 AND `partno` = '12201' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aven tools%' ) [ RunTime:0.036718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11195641 [ RunTime:0.052195s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43761399 LIMIT 5 [ RunTime:0.034939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43761399 ORDER BY `minOrder` ASC [ RunTime:0.040834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43761399 ORDER BY `unit` DESC [ RunTime:0.047705s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43761399 LIMIT 2 [ RunTime:0.070071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43761399 ORDER BY `minOrder` ASC [ RunTime:0.031371s ]
select * from pdf where partno='1220180000' and brandshort='Weidmüller' limit 1 [ RunTime:0.014731s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220180000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.040605s ]
SELECT `id` FROM `stock` WHERE `id` <> 43761399 AND `partno` = '1220180000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.047900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19280366 [ RunTime:0.024501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43762066 LIMIT 5 [ RunTime:0.023117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43762066 ORDER BY `minOrder` ASC [ RunTime:0.036741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43762066 ORDER BY `unit` DESC [ RunTime:0.030009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43762066 LIMIT 2 [ RunTime:0.029595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43762066 ORDER BY `minOrder` ASC [ RunTime:0.006992s ]
select * from pdf where partno='1220170000' and brandshort='Weidmüller' limit 1 [ RunTime:0.030357s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220170000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.037090s ]
SELECT `id` FROM `stock` WHERE `id` <> 43762066 AND `partno` = '1220170000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.013326s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15367552 [ RunTime:0.048614s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 43761411 LIMIT 5 [ RunTime:0.006602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43761411 ORDER BY `minOrder` ASC [ RunTime:0.027585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 43761411 ORDER BY `unit` DESC [ RunTime:0.021686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 43761411 LIMIT 2 [ RunTime:0.006430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 43761411 ORDER BY `minOrder` ASC [ RunTime:0.019651s ]
select * from pdf where partno='1220190000' and brandshort='Weidmüller' limit 1 [ RunTime:0.027690s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220190000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.035657s ]
SELECT `id` FROM `stock` WHERE `id` <> 43761411 AND `partno` = '1220190000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.010203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17147477 [ RunTime:0.042105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64453186 LIMIT 5 [ RunTime:0.015580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453186 ORDER BY `minOrder` ASC [ RunTime:0.013421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64453186 ORDER BY `unit` DESC [ RunTime:0.010433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64453186 LIMIT 2 [ RunTime:0.024616s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453186 ORDER BY `minOrder` ASC [ RunTime:0.002261s ]
select * from pdf where partno='1220130' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.003318s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220130' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008960s ]
SELECT `id` FROM `stock` WHERE `id` <> 64453186 AND `partno` = '1220130' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.005518s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15235929 [ RunTime:0.007735s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64453342 LIMIT 5 [ RunTime:0.014426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453342 ORDER BY `minOrder` ASC [ RunTime:0.003551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64453342 ORDER BY `unit` DESC [ RunTime:0.000745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64453342 LIMIT 2 [ RunTime:0.000624s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453342 ORDER BY `minOrder` ASC [ RunTime:0.001438s ]
select * from pdf where partno='1220121' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.013592s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220121' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008494s ]
SELECT `id` FROM `stock` WHERE `id` <> 64453342 AND `partno` = '1220121' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.021910s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16013901 [ RunTime:0.027794s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64453335 LIMIT 5 [ RunTime:0.003758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453335 ORDER BY `minOrder` ASC [ RunTime:0.001070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64453335 ORDER BY `unit` DESC [ RunTime:0.005463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64453335 LIMIT 2 [ RunTime:0.010199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453335 ORDER BY `minOrder` ASC [ RunTime:0.007487s ]
select * from pdf where partno='1220106' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.002447s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220106' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003912s ]
SELECT `id` FROM `stock` WHERE `id` <> 64453335 AND `partno` = '1220106' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000896s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17021073 [ RunTime:0.004588s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64453334 LIMIT 5 [ RunTime:0.003584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453334 ORDER BY `minOrder` ASC [ RunTime:0.002267s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64453334 ORDER BY `unit` DESC [ RunTime:0.000733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64453334 LIMIT 2 [ RunTime:0.000659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453334 ORDER BY `minOrder` ASC [ RunTime:0.002787s ]
select * from pdf where partno='1220104' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.005980s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220104' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000490s ]
SELECT `id` FROM `stock` WHERE `id` <> 64453334 AND `partno` = '1220104' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17021600 [ RunTime:0.000446s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64453333 LIMIT 5 [ RunTime:0.001961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453333 ORDER BY `minOrder` ASC [ RunTime:0.007946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64453333 ORDER BY `unit` DESC [ RunTime:0.017459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64453333 LIMIT 2 [ RunTime:0.002180s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453333 ORDER BY `minOrder` ASC [ RunTime:0.002598s ]
select * from pdf where partno='1220147' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001052s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220147' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000909s ]
SELECT `id` FROM `stock` WHERE `id` <> 64453333 AND `partno` = '1220147' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.005762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17021069 [ RunTime:0.000710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64453329 LIMIT 5 [ RunTime:0.011326s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453329 ORDER BY `minOrder` ASC [ RunTime:0.002587s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64453329 ORDER BY `unit` DESC [ RunTime:0.000731s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64453329 LIMIT 2 [ RunTime:0.000840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453329 ORDER BY `minOrder` ASC [ RunTime:0.004209s ]
select * from pdf where partno='1220103' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.022523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220103' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.006488s ]
SELECT `id` FROM `stock` WHERE `id` <> 64453329 AND `partno` = '1220103' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.010327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18835822 [ RunTime:0.011897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64453327 LIMIT 5 [ RunTime:0.010663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453327 ORDER BY `minOrder` ASC [ RunTime:0.007288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64453327 ORDER BY `unit` DESC [ RunTime:0.015525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64453327 LIMIT 2 [ RunTime:0.005144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453327 ORDER BY `minOrder` ASC [ RunTime:0.013801s ]
select * from pdf where partno='1220159' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.011271s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220159' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.023641s ]
SELECT `id` FROM `stock` WHERE `id` <> 64453327 AND `partno` = '1220159' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18836987 [ RunTime:0.005394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64453325 LIMIT 5 [ RunTime:0.066959s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453325 ORDER BY `minOrder` ASC [ RunTime:0.013948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64453325 ORDER BY `unit` DESC [ RunTime:0.007139s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64453325 LIMIT 2 [ RunTime:0.013867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453325 ORDER BY `minOrder` ASC [ RunTime:0.014568s ]
select * from pdf where partno='1220132' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009212s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220132' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001393s ]
SELECT `id` FROM `stock` WHERE `id` <> 64453325 AND `partno` = '1220132' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15236406 [ RunTime:0.003560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64453323 LIMIT 5 [ RunTime:0.002225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453323 ORDER BY `minOrder` ASC [ RunTime:0.015569s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64453323 ORDER BY `unit` DESC [ RunTime:0.000479s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64453323 LIMIT 2 [ RunTime:0.006854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64453323 ORDER BY `minOrder` ASC [ RunTime:0.015189s ]
select * from pdf where partno='1220102' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004581s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1220102' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.002810s ]
SELECT `id` FROM `stock` WHERE `id` <> 64453323 AND `partno` = '1220102' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.019572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16013779 [ RunTime:0.006981s ]
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 '12201%' OR `brand` LIKE '12201%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030525s ]
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 '12201%' OR `brand` LIKE '12201%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010583s ]
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 '12201%' OR `brand` LIKE '12201%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028899s ]
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 '12201%' OR `brand` LIKE '12201%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002718s ]
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 '12201%' OR `brand` LIKE '12201%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006037s ]
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 '12201%' OR `brand` LIKE '12201%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002859s ]
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 '12201%' OR `brand` LIKE '12201%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003105s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '12201%' OR `brand` LIKE '12201%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.012872s ]