SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001757s ]
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 '3047%' OR `brand` LIKE '3047%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.060779s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16401171 LIMIT 5 [ RunTime:0.051603s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16401171 ORDER BY `minOrder` ASC [ RunTime:0.024322s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16401171 ORDER BY `unit` DESC [ RunTime:0.026930s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001447s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16401171 LIMIT 2 [ RunTime:0.029651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16401171 ORDER BY `minOrder` ASC [ RunTime:0.088788s ]
select * from pdf where partno='3047 BL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.087826s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14364324 LIMIT 5 [ RunTime:0.030625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14364324 ORDER BY `minOrder` ASC [ RunTime:0.060433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14364324 ORDER BY `unit` DESC [ RunTime:0.021457s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14364324 LIMIT 2 [ RunTime:0.044745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14364324 ORDER BY `minOrder` ASC [ RunTime:0.006032s ]
select * from pdf where partno='3047 SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.016846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14363874 LIMIT 5 [ RunTime:0.047452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14363874 ORDER BY `minOrder` ASC [ RunTime:0.041098s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14363874 ORDER BY `unit` DESC [ RunTime:0.047061s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14363874 LIMIT 2 [ RunTime:0.045469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14363874 ORDER BY `minOrder` ASC [ RunTime:0.058618s ]
select * from pdf where partno='3047 BK001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.087933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14363875 LIMIT 5 [ RunTime:0.063882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14363875 ORDER BY `minOrder` ASC [ RunTime:0.017042s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14363875 ORDER BY `unit` DESC [ RunTime:0.022453s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14363875 LIMIT 2 [ RunTime:0.083931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14363875 ORDER BY `minOrder` ASC [ RunTime:0.022080s ]
select * from pdf where partno='3047 OR001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.040448s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315489 LIMIT 5 [ RunTime:0.028337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315489 ORDER BY `minOrder` ASC [ RunTime:0.029817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13315489 ORDER BY `unit` DESC [ RunTime:0.027715s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13315489 LIMIT 2 [ RunTime:0.033024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315489 ORDER BY `minOrder` ASC [ RunTime:0.009169s ]
select * from pdf where partno='3047-B-632-B' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.033804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407640 LIMIT 5 [ RunTime:0.030077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16407640 ORDER BY `minOrder` ASC [ RunTime:0.030890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16407640 ORDER BY `unit` DESC [ RunTime:0.057801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16407640 LIMIT 2 [ RunTime:0.039825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16407640 ORDER BY `minOrder` ASC [ RunTime:0.021241s ]
select * from pdf where partno='3047 WH001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407639 LIMIT 5 [ RunTime:0.002371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16407639 ORDER BY `minOrder` ASC [ RunTime:0.016416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16407639 ORDER BY `unit` DESC [ RunTime:0.007430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16407639 LIMIT 2 [ RunTime:0.013310s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16407639 ORDER BY `minOrder` ASC [ RunTime:0.006215s ]
select * from pdf where partno='3047 VI001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.029184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407638 LIMIT 5 [ RunTime:0.021099s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16407638 ORDER BY `minOrder` ASC [ RunTime:0.009430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16407638 ORDER BY `unit` DESC [ RunTime:0.021464s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16407638 LIMIT 2 [ RunTime:0.035273s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16407638 ORDER BY `minOrder` ASC [ RunTime:0.000494s ]
select * from pdf where partno='3047 RD001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.030546s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16401599 LIMIT 5 [ RunTime:0.017755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16401599 ORDER BY `minOrder` ASC [ RunTime:0.043162s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16401599 ORDER BY `unit` DESC [ RunTime:0.074904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16401599 LIMIT 2 [ RunTime:0.053013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16401599 ORDER BY `minOrder` ASC [ RunTime:0.026486s ]
select * from pdf where partno='3047 YL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.011554s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13492609 LIMIT 5 [ RunTime:0.066928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13492609 ORDER BY `minOrder` ASC [ RunTime:0.005887s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13492609 ORDER BY `unit` DESC [ RunTime:0.056076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13492609 LIMIT 2 [ RunTime:0.101873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13492609 ORDER BY `minOrder` ASC [ RunTime:0.032978s ]
select * from pdf where partno='3047 BR001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.024541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13316942 LIMIT 5 [ RunTime:0.099127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13316942 ORDER BY `minOrder` ASC [ RunTime:0.048444s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13316942 ORDER BY `unit` DESC [ RunTime:0.053336s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13316942 LIMIT 2 [ RunTime:0.020881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13316942 ORDER BY `minOrder` ASC [ RunTime:0.011194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12159281 LIMIT 5 [ RunTime:0.060358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12159281 ORDER BY `minOrder` ASC [ RunTime:0.028472s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12159281 ORDER BY `unit` DESC [ RunTime:0.040879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12159281 LIMIT 2 [ RunTime:0.165061s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12159281 ORDER BY `minOrder` ASC [ RunTime:0.032723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14274157 LIMIT 5 [ RunTime:0.032244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14274157 ORDER BY `minOrder` ASC [ RunTime:0.032989s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14274157 ORDER BY `unit` DESC [ RunTime:0.115177s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14274157 LIMIT 2 [ RunTime:0.036823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14274157 ORDER BY `minOrder` ASC [ RunTime:0.017021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12042155 LIMIT 5 [ RunTime:0.010220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12042155 ORDER BY `minOrder` ASC [ RunTime:0.036905s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12042155 ORDER BY `unit` DESC [ RunTime:0.037908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12042155 LIMIT 2 [ RunTime:0.017934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12042155 ORDER BY `minOrder` ASC [ RunTime:0.013577s ]
select * from pdf where partno='3047-B-632-B-12' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.009460s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12040508 LIMIT 5 [ RunTime:0.028728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12040508 ORDER BY `minOrder` ASC [ RunTime:0.013273s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12040508 ORDER BY `unit` DESC [ RunTime:0.020049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12040508 LIMIT 2 [ RunTime:0.012313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12040508 ORDER BY `minOrder` ASC [ RunTime:0.023428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13492630 LIMIT 5 [ RunTime:0.023582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13492630 ORDER BY `minOrder` ASC [ RunTime:0.004265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13492630 ORDER BY `unit` DESC [ RunTime:0.007539s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13492630 LIMIT 2 [ RunTime:0.031178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13492630 ORDER BY `minOrder` ASC [ RunTime:0.005942s ]
select * from pdf where partno='3047 VI005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.007367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13314975 LIMIT 5 [ RunTime:0.014601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13314975 ORDER BY `minOrder` ASC [ RunTime:0.011496s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13314975 ORDER BY `unit` DESC [ RunTime:0.014196s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13314975 LIMIT 2 [ RunTime:0.036409s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13314975 ORDER BY `minOrder` ASC [ RunTime:0.004254s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12561786 LIMIT 5 [ RunTime:0.005747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561786 ORDER BY `minOrder` ASC [ RunTime:0.010620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12561786 ORDER BY `unit` DESC [ RunTime:0.019373s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12561786 LIMIT 2 [ RunTime:0.000824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12561786 ORDER BY `minOrder` ASC [ RunTime:0.004429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13317053 LIMIT 5 [ RunTime:0.008253s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13317053 ORDER BY `minOrder` ASC [ RunTime:0.019634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13317053 ORDER BY `unit` DESC [ RunTime:0.004940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13317053 LIMIT 2 [ RunTime:0.000880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13317053 ORDER BY `minOrder` ASC [ RunTime:0.006870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13468675 LIMIT 5 [ RunTime:0.012427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13468675 ORDER BY `minOrder` ASC [ RunTime:0.000554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13468675 ORDER BY `unit` DESC [ RunTime:0.004948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13468675 LIMIT 2 [ RunTime:0.002665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13468675 ORDER BY `minOrder` ASC [ RunTime:0.000319s ]
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 '3047%' OR `brand` LIKE '3047%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51086742 LIMIT 5 [ RunTime:0.014272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51086742 ORDER BY `minOrder` ASC [ RunTime:0.042301s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51086742 ORDER BY `unit` DESC [ RunTime:0.002905s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51086742 LIMIT 2 [ RunTime:0.000806s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51086742 ORDER BY `minOrder` ASC [ RunTime:0.000339s ]
select * from pdf where partno='3047400' and brandshort='phoenix contact' limit 1 [ RunTime:0.001637s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002152s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3047400' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.016356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275367 LIMIT 5 [ RunTime:0.031225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275367 ORDER BY `minOrder` ASC [ RunTime:0.034322s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275367 ORDER BY `unit` DESC [ RunTime:0.007596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275367 LIMIT 2 [ RunTime:0.022220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275367 ORDER BY `minOrder` ASC [ RunTime:0.002848s ]
select * from pdf where partno='3047400' and brandshort='phoenix contact' limit 1 [ RunTime:0.018238s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3047400' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.014536s ]
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 '3047%' OR `brand` LIKE '3047%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019124s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59384767 LIMIT 5 [ RunTime:0.013228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59384767 ORDER BY `minOrder` ASC [ RunTime:0.014328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59384767 ORDER BY `unit` DESC [ RunTime:0.010024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59384767 LIMIT 2 [ RunTime:0.019487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59384767 ORDER BY `minOrder` ASC [ RunTime:0.007162s ]
select * from pdf where partno='3047028' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.006852s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3047028' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.029976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56227305 LIMIT 5 [ RunTime:0.013960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56227305 ORDER BY `minOrder` ASC [ RunTime:0.022703s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56227305 ORDER BY `unit` DESC [ RunTime:0.017545s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56227305 LIMIT 2 [ RunTime:0.006777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56227305 ORDER BY `minOrder` ASC [ RunTime:0.010242s ]
select * from pdf where partno='3047 BK001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.004689s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3047 BK001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.002255s ]
SELECT `id` FROM `stock` WHERE `id` <> 56227305 AND `partno` = '3047 BK001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.016378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14363874 [ RunTime:0.000550s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59384770 LIMIT 5 [ RunTime:0.014329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59384770 ORDER BY `minOrder` ASC [ RunTime:0.017643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59384770 ORDER BY `unit` DESC [ RunTime:0.002630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59384770 LIMIT 2 [ RunTime:0.007372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59384770 ORDER BY `minOrder` ASC [ RunTime:0.013607s ]
select * from pdf where partno='3047167' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.005319s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3047167' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.013177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56228048 LIMIT 5 [ RunTime:0.009182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56228048 ORDER BY `minOrder` ASC [ RunTime:0.031984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56228048 ORDER BY `unit` DESC [ RunTime:0.012192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56228048 LIMIT 2 [ RunTime:0.022489s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56228048 ORDER BY `minOrder` ASC [ RunTime:0.007512s ]
select * from pdf where partno='3047 YL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.010186s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3047 YL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.013785s ]
SELECT `id` FROM `stock` WHERE `id` <> 56228048 AND `partno` = '3047 YL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.037372s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16401599 [ RunTime:0.006793s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56228049 LIMIT 5 [ RunTime:0.018880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56228049 ORDER BY `minOrder` ASC [ RunTime:0.035350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56228049 ORDER BY `unit` DESC [ RunTime:0.012024s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56228049 LIMIT 2 [ RunTime:0.010019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56228049 ORDER BY `minOrder` ASC [ RunTime:0.010788s ]
select * from pdf where partno='3047 BL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.005507s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3047 BL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.035644s ]
SELECT `id` FROM `stock` WHERE `id` <> 56228049 AND `partno` = '3047 BL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.029559s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16401171 [ RunTime:0.037354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56228475 LIMIT 5 [ RunTime:0.020054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56228475 ORDER BY `minOrder` ASC [ RunTime:0.064838s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56228475 ORDER BY `unit` DESC [ RunTime:0.011037s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56228475 LIMIT 2 [ RunTime:0.014222s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56228475 ORDER BY `minOrder` ASC [ RunTime:0.001831s ]
select * from pdf where partno='3047 SL001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.010079s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3047 SL001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.018310s ]
SELECT `id` FROM `stock` WHERE `id` <> 56228475 AND `partno` = '3047 SL001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.058248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14364324 [ RunTime:0.035592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59384878 LIMIT 5 [ RunTime:0.042789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59384878 ORDER BY `minOrder` ASC [ RunTime:0.018573s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59384878 ORDER BY `unit` DESC [ RunTime:0.017533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59384878 LIMIT 2 [ RunTime:0.031036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59384878 ORDER BY `minOrder` ASC [ RunTime:0.004944s ]
select * from pdf where partno='3047206' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.016063s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3047206' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.023860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59384871 LIMIT 5 [ RunTime:0.043139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59384871 ORDER BY `minOrder` ASC [ RunTime:0.014899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59384871 ORDER BY `unit` DESC [ RunTime:0.010385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59384871 LIMIT 2 [ RunTime:0.025545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59384871 ORDER BY `minOrder` ASC [ RunTime:0.004518s ]
select * from pdf where partno='3047141' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.019969s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3047141' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.013155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59384783 LIMIT 5 [ RunTime:0.004299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59384783 ORDER BY `minOrder` ASC [ RunTime:0.005681s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59384783 ORDER BY `unit` DESC [ RunTime:0.005570s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59384783 LIMIT 2 [ RunTime:0.024914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59384783 ORDER BY `minOrder` ASC [ RunTime:0.005236s ]
select * from pdf where partno='3047293' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003794s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3047293' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.013102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58568295 LIMIT 5 [ RunTime:0.011290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58568295 ORDER BY `minOrder` ASC [ RunTime:0.038995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58568295 ORDER BY `unit` DESC [ RunTime:0.047780s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58568295 LIMIT 2 [ RunTime:0.022487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58568295 ORDER BY `minOrder` ASC [ RunTime:0.025473s ]
select * from pdf where partno='30470' and brandshort='Excel Blades' limit 1 [ RunTime:0.029797s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '30470' OR `brand` LIKE 'Excel Blades%' ) ) LIMIT 1 [ RunTime:0.031062s ]
SELECT `id` FROM `stock` WHERE `id` <> 58568295 AND `partno` = '30470' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%excel blades%' ) [ RunTime:0.027953s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12159281 [ RunTime:0.021050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56233108 LIMIT 5 [ RunTime:0.005549s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56233108 ORDER BY `minOrder` ASC [ RunTime:0.025148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56233108 ORDER BY `unit` DESC [ RunTime:0.009289s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56233108 LIMIT 2 [ RunTime:0.019507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56233108 ORDER BY `minOrder` ASC [ RunTime:0.002479s ]
select * from pdf where partno='3047 RD001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002856s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3047 RD001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.008819s ]
SELECT `id` FROM `stock` WHERE `id` <> 56233108 AND `partno` = '3047 RD001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.007697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407638 [ RunTime:0.045021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56233107 LIMIT 5 [ RunTime:0.008039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56233107 ORDER BY `minOrder` ASC [ RunTime:0.018664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56233107 ORDER BY `unit` DESC [ RunTime:0.001765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56233107 LIMIT 2 [ RunTime:0.006898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56233107 ORDER BY `minOrder` ASC [ RunTime:0.000983s ]
select * from pdf where partno='3047 WH001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.011506s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3047 WH001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.001956s ]
SELECT `id` FROM `stock` WHERE `id` <> 56233107 AND `partno` = '3047 WH001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.010886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407640 [ RunTime:0.010064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56233106 LIMIT 5 [ RunTime:0.005088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56233106 ORDER BY `minOrder` ASC [ RunTime:0.005222s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56233106 ORDER BY `unit` DESC [ RunTime:0.009154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56233106 LIMIT 2 [ RunTime:0.021317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56233106 ORDER BY `minOrder` ASC [ RunTime:0.027333s ]
select * from pdf where partno='3047 BR001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000998s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3047 BR001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.000702s ]
SELECT `id` FROM `stock` WHERE `id` <> 56233106 AND `partno` = '3047 BR001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.006901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13492609 [ RunTime:0.006743s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56233105 LIMIT 5 [ RunTime:0.011359s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56233105 ORDER BY `minOrder` ASC [ RunTime:0.005946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56233105 ORDER BY `unit` DESC [ RunTime:0.002925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56233105 LIMIT 2 [ RunTime:0.030079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56233105 ORDER BY `minOrder` ASC [ RunTime:0.003927s ]
select * from pdf where partno='3047 VI001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.007910s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3047 VI001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.005065s ]
SELECT `id` FROM `stock` WHERE `id` <> 56233105 AND `partno` = '3047 VI001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.014384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407639 [ RunTime:0.018833s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56233101 LIMIT 5 [ RunTime:0.012557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56233101 ORDER BY `minOrder` ASC [ RunTime:0.004543s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56233101 ORDER BY `unit` DESC [ RunTime:0.028340s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56233101 LIMIT 2 [ RunTime:0.017576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56233101 ORDER BY `minOrder` ASC [ RunTime:0.006343s ]
select * from pdf where partno='3047 OR001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.007708s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3047 OR001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.004564s ]
SELECT `id` FROM `stock` WHERE `id` <> 56233101 AND `partno` = '3047 OR001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.001068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14363875 [ RunTime:0.000912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59385557 LIMIT 5 [ RunTime:0.000593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59385557 ORDER BY `minOrder` ASC [ RunTime:0.002834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59385557 ORDER BY `unit` DESC [ RunTime:0.009544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59385557 LIMIT 2 [ RunTime:0.025937s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59385557 ORDER BY `minOrder` ASC [ RunTime:0.016534s ]
select * from pdf where partno='3047196' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.008238s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3047196' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.012857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58105382 LIMIT 5 [ RunTime:0.006618s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58105382 ORDER BY `minOrder` ASC [ RunTime:0.011279s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58105382 ORDER BY `unit` DESC [ RunTime:0.009911s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58105382 LIMIT 2 [ RunTime:0.019569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58105382 ORDER BY `minOrder` ASC [ RunTime:0.000559s ]
select * from pdf where partno='3047' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.023505s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3047' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.020743s ]
SELECT `id` FROM `stock` WHERE `id` <> 58105382 AND `partno` = '3047' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.039352s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14274157 [ RunTime:0.022073s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59384898 LIMIT 5 [ RunTime:0.026545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59384898 ORDER BY `minOrder` ASC [ RunTime:0.006236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59384898 ORDER BY `unit` DESC [ RunTime:0.014578s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59384898 LIMIT 2 [ RunTime:0.007906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59384898 ORDER BY `minOrder` ASC [ RunTime:0.044812s ]
select * from pdf where partno='3047303' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.025029s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3047303' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.005453s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59385548 LIMIT 5 [ RunTime:0.027102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59385548 ORDER BY `minOrder` ASC [ RunTime:0.038760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59385548 ORDER BY `unit` DESC [ RunTime:0.040613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59385548 LIMIT 2 [ RunTime:0.036934s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59385548 ORDER BY `minOrder` ASC [ RunTime:0.029870s ]
select * from pdf where partno='3047235' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.026284s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3047235' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.060080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56582239 LIMIT 5 [ RunTime:0.086389s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56582239 ORDER BY `minOrder` ASC [ RunTime:0.082107s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56582239 ORDER BY `unit` DESC [ RunTime:0.069681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56582239 LIMIT 2 [ RunTime:0.063542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56582239 ORDER BY `minOrder` ASC [ RunTime:0.046339s ]
select * from pdf where partno='3047-B-632-B-5' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.049163s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3047-B-632-B-5' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.051414s ]
SELECT `id` FROM `stock` WHERE `id` <> 56582239 AND `partno` = '3047-B-632-B-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.078253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13314975 [ RunTime:0.035426s ]
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 '3047%' OR `brand` LIKE '3047%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.104889s ]
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 '3047%' OR `brand` LIKE '3047%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.137188s ]
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 '3047%' OR `brand` LIKE '3047%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.114614s ]
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 '3047%' OR `brand` LIKE '3047%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.108115s ]
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 '3047%' OR `brand` LIKE '3047%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.060813s ]
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 '3047%' OR `brand` LIKE '3047%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.069585s ]
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 '3047%' OR `brand` LIKE '3047%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.072999s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '3047%' OR `brand` LIKE '3047%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.040065s ]