SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002133s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.72' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock?keyword=3050&search=1' [ RunTime:0.002418s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001620s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000478s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001741s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.72' ) [ RunTime:0.003207s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001405s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000295s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001338s ]
SELECT * FROM `stock_search` WHERE `partno` = '3050' LIMIT 1 [ RunTime:0.006471s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-08 13:46:17' WHERE `partno` = '3050' [ RunTime:0.015009s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001312s ]
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 '3050%' OR `brand` LIKE '3050%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029078s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001922s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13388678 LIMIT 5 [ RunTime:0.001439s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13388678 ORDER BY `minOrder` ASC [ RunTime:0.001195s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13388678 ORDER BY `unit` DESC [ RunTime:0.002438s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.009759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13388678 LIMIT 2 [ RunTime:0.020520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13388678 ORDER BY `minOrder` ASC [ RunTime:0.010044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16401164 LIMIT 5 [ RunTime:0.035763s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16401164 ORDER BY `minOrder` ASC [ RunTime:0.005812s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16401164 ORDER BY `unit` DESC [ RunTime:0.003403s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16401164 LIMIT 2 [ RunTime:0.000566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16401164 ORDER BY `minOrder` ASC [ RunTime:0.000383s ]
select * from pdf where partno='3050 YL013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.007261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13489879 LIMIT 5 [ RunTime:0.009453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13489879 ORDER BY `minOrder` ASC [ RunTime:0.011972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13489879 ORDER BY `unit` DESC [ RunTime:0.002747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13489879 LIMIT 2 [ RunTime:0.001244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13489879 ORDER BY `minOrder` ASC [ RunTime:0.000351s ]
select * from pdf where partno='3050 BR013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.003948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13489878 LIMIT 5 [ RunTime:0.003883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13489878 ORDER BY `minOrder` ASC [ RunTime:0.010871s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13489878 ORDER BY `unit` DESC [ RunTime:0.000562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13489878 LIMIT 2 [ RunTime:0.000429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13489878 ORDER BY `minOrder` ASC [ RunTime:0.000288s ]
select * from pdf where partno='3050 BL013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14371610 LIMIT 5 [ RunTime:0.010858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14371610 ORDER BY `minOrder` ASC [ RunTime:0.002282s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14371610 ORDER BY `unit` DESC [ RunTime:0.007804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14371610 LIMIT 2 [ RunTime:0.007224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14371610 ORDER BY `minOrder` ASC [ RunTime:0.001469s ]
select * from pdf where partno='3050 WG005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002113s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19593743 LIMIT 5 [ RunTime:0.006370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593743 ORDER BY `minOrder` ASC [ RunTime:0.000883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19593743 ORDER BY `unit` DESC [ RunTime:0.007555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19593743 LIMIT 2 [ RunTime:0.022012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593743 ORDER BY `minOrder` ASC [ RunTime:0.017018s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348841 LIMIT 5 [ RunTime:0.004513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348841 ORDER BY `minOrder` ASC [ RunTime:0.012032s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13348841 ORDER BY `unit` DESC [ RunTime:0.009170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13348841 LIMIT 2 [ RunTime:0.000777s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13348841 ORDER BY `minOrder` ASC [ RunTime:0.009830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19593780 LIMIT 5 [ RunTime:0.011066s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593780 ORDER BY `minOrder` ASC [ RunTime:0.018517s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19593780 ORDER BY `unit` DESC [ RunTime:0.052985s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19593780 LIMIT 2 [ RunTime:0.014686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19593780 ORDER BY `minOrder` ASC [ RunTime:0.000360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13316917 LIMIT 5 [ RunTime:0.002573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13316917 ORDER BY `minOrder` ASC [ RunTime:0.000465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13316917 ORDER BY `unit` DESC [ RunTime:0.000413s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13316917 LIMIT 2 [ RunTime:0.000733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13316917 ORDER BY `minOrder` ASC [ RunTime:0.003931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14368556 LIMIT 5 [ RunTime:0.009034s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14368556 ORDER BY `minOrder` ASC [ RunTime:0.022817s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14368556 ORDER BY `unit` DESC [ RunTime:0.007205s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14368556 LIMIT 2 [ RunTime:0.020830s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14368556 ORDER BY `minOrder` ASC [ RunTime:0.001544s ]
select * from pdf where partno='3050 WH005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.039757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12042662 LIMIT 5 [ RunTime:0.030022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12042662 ORDER BY `minOrder` ASC [ RunTime:0.086814s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12042662 ORDER BY `unit` DESC [ RunTime:0.059577s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12042662 LIMIT 2 [ RunTime:0.109655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12042662 ORDER BY `minOrder` ASC [ RunTime:0.018244s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14368557 LIMIT 5 [ RunTime:0.000861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14368557 ORDER BY `minOrder` ASC [ RunTime:0.043287s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14368557 ORDER BY `unit` DESC [ RunTime:0.012716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14368557 LIMIT 2 [ RunTime:0.132614s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14368557 ORDER BY `minOrder` ASC [ RunTime:0.013019s ]
select * from pdf where partno='3050 BK005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.034162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13315991 LIMIT 5 [ RunTime:0.070814s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315991 ORDER BY `minOrder` ASC [ RunTime:0.060920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13315991 ORDER BY `unit` DESC [ RunTime:0.055877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13315991 LIMIT 2 [ RunTime:0.048079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13315991 ORDER BY `minOrder` ASC [ RunTime:0.044503s ]
select * from pdf where partno='3050-B-440-AL-7' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.115444s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16404952 LIMIT 5 [ RunTime:0.131152s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16404952 ORDER BY `minOrder` ASC [ RunTime:0.037933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16404952 ORDER BY `unit` DESC [ RunTime:0.051687s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16404952 LIMIT 2 [ RunTime:0.027702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16404952 ORDER BY `minOrder` ASC [ RunTime:0.040068s ]
select * from pdf where partno='3050 RD005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.032666s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11989701 LIMIT 5 [ RunTime:0.151091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11989701 ORDER BY `minOrder` ASC [ RunTime:0.041338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11989701 ORDER BY `unit` DESC [ RunTime:0.024799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11989701 LIMIT 2 [ RunTime:0.032488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11989701 ORDER BY `minOrder` ASC [ RunTime:0.026664s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14348839 LIMIT 5 [ RunTime:0.046628s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14348839 ORDER BY `minOrder` ASC [ RunTime:0.024493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14348839 ORDER BY `unit` DESC [ RunTime:0.035365s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14348839 LIMIT 2 [ RunTime:0.026769s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14348839 ORDER BY `minOrder` ASC [ RunTime:0.005596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13322793 LIMIT 5 [ RunTime:0.022804s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13322793 ORDER BY `minOrder` ASC [ RunTime:0.031827s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13322793 ORDER BY `unit` DESC [ RunTime:0.007214s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13322793 LIMIT 2 [ RunTime:0.044494s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13322793 ORDER BY `minOrder` ASC [ RunTime:0.000784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14372562 LIMIT 5 [ RunTime:0.011924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14372562 ORDER BY `minOrder` ASC [ RunTime:0.007920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14372562 ORDER BY `unit` DESC [ RunTime:0.040660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14372562 LIMIT 2 [ RunTime:0.007478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14372562 ORDER BY `minOrder` ASC [ RunTime:0.000519s ]
select * from pdf where partno='3050 WO005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.002818s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407463 LIMIT 5 [ RunTime:0.001507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16407463 ORDER BY `minOrder` ASC [ RunTime:0.002160s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16407463 ORDER BY `unit` DESC [ RunTime:0.016762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16407463 LIMIT 2 [ RunTime:0.020338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16407463 ORDER BY `minOrder` ASC [ RunTime:0.000562s ]
select * from pdf where partno='3050 WH001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.003125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19508062 LIMIT 5 [ RunTime:0.003198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19508062 ORDER BY `minOrder` ASC [ RunTime:0.010380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19508062 ORDER BY `unit` DESC [ RunTime:0.008240s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19508062 LIMIT 2 [ RunTime:0.007296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19508062 ORDER BY `minOrder` ASC [ RunTime:0.000438s ]
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 '3050%' OR `brand` LIKE '3050%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009821s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32212885 LIMIT 5 [ RunTime:0.006085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32212885 ORDER BY `minOrder` ASC [ RunTime:0.011811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32212885 ORDER BY `unit` DESC [ RunTime:0.006975s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32212885 LIMIT 2 [ RunTime:0.006690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32212885 ORDER BY `minOrder` ASC [ RunTime:0.005454s ]
select * from pdf where partno='3050-b' and brandshort='davies molding' limit 1 [ RunTime:0.001020s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002676s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050-b' OR `brand` LIKE 'davies molding%' ) ) LIMIT 1 [ RunTime:0.005020s ]
SELECT `id` FROM `stock` WHERE `id` <> 32212885 AND `partno` = '3050-b' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%davies molding%' ) [ RunTime:0.011634s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13340778 [ RunTime:0.010025s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51113809 LIMIT 5 [ RunTime:0.022831s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51113809 ORDER BY `minOrder` ASC [ RunTime:0.011279s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51113809 ORDER BY `unit` DESC [ RunTime:0.002717s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51113809 LIMIT 2 [ RunTime:0.002822s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51113809 ORDER BY `minOrder` ASC [ RunTime:0.003405s ]
select * from pdf where partno='30504' and brandshort='wurth elektronik' limit 1 [ RunTime:0.001001s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '30504' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.020730s ]
SELECT `id` FROM `stock` WHERE `id` <> 51113809 AND `partno` = '30504' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.027454s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13263117 [ RunTime:0.019945s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138971 LIMIT 5 [ RunTime:0.010309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138971 ORDER BY `minOrder` ASC [ RunTime:0.011505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138971 ORDER BY `unit` DESC [ RunTime:0.003150s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138971 LIMIT 2 [ RunTime:0.025241s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138971 ORDER BY `minOrder` ASC [ RunTime:0.028727s ]
select * from pdf where partno='3050 bk005' and brandshort='alpha wire' limit 1 [ RunTime:0.025406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050 bk005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.011853s ]
SELECT `id` FROM `stock` WHERE `id` <> 51138971 AND `partno` = '3050 bk005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.025717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14368557 [ RunTime:0.000780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32291754 LIMIT 5 [ RunTime:0.003052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32291754 ORDER BY `minOrder` ASC [ RunTime:0.001225s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32291754 ORDER BY `unit` DESC [ RunTime:0.007681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32291754 LIMIT 2 [ RunTime:0.003491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32291754 ORDER BY `minOrder` ASC [ RunTime:0.003937s ]
select * from pdf where partno='30500109' and brandshort='yageo nexensos' limit 1 [ RunTime:0.012634s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '30500109' OR `brand` LIKE 'yageo nexensos%' ) ) LIMIT 1 [ RunTime:0.002774s ]
SELECT `id` FROM `stock` WHERE `id` <> 32291754 AND `partno` = '30500109' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%yageo nexensos%' ) [ RunTime:0.033378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13322793 [ RunTime:0.000756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138395 LIMIT 5 [ RunTime:0.002320s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138395 ORDER BY `minOrder` ASC [ RunTime:0.003523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138395 ORDER BY `unit` DESC [ RunTime:0.004426s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138395 LIMIT 2 [ RunTime:0.008761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138395 ORDER BY `minOrder` ASC [ RunTime:0.011485s ]
select * from pdf where partno='3050 ws005' and brandshort='alpha wire' limit 1 [ RunTime:0.037340s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050 ws005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.009903s ]
SELECT `id` FROM `stock` WHERE `id` <> 51138395 AND `partno` = '3050 ws005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.011483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13493959 [ RunTime:0.019775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138973 LIMIT 5 [ RunTime:0.004928s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138973 ORDER BY `minOrder` ASC [ RunTime:0.003946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138973 ORDER BY `unit` DESC [ RunTime:0.011469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138973 LIMIT 2 [ RunTime:0.051532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138973 ORDER BY `minOrder` ASC [ RunTime:0.026475s ]
select * from pdf where partno='3050 rd001' and brandshort='alpha wire' limit 1 [ RunTime:0.008272s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050 rd001' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.000664s ]
SELECT `id` FROM `stock` WHERE `id` <> 51138973 AND `partno` = '3050 rd001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.005912s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14371220 [ RunTime:0.009722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51095141 LIMIT 5 [ RunTime:0.017261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51095141 ORDER BY `minOrder` ASC [ RunTime:0.011060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51095141 ORDER BY `unit` DESC [ RunTime:0.010712s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51095141 LIMIT 2 [ RunTime:0.023774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51095141 ORDER BY `minOrder` ASC [ RunTime:0.008812s ]
select * from pdf where partno='3050' and brandshort='scs' limit 1 [ RunTime:0.003258s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050' OR `brand` LIKE 'scs%' ) ) LIMIT 1 [ RunTime:0.002851s ]
SELECT `id` FROM `stock` WHERE `id` <> 51095141 AND `partno` = '3050' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%scs%' ) [ RunTime:0.017441s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19508062 [ RunTime:0.014613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51131298 LIMIT 5 [ RunTime:0.013292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51131298 ORDER BY `minOrder` ASC [ RunTime:0.028632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51131298 ORDER BY `unit` DESC [ RunTime:0.009065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51131298 LIMIT 2 [ RunTime:0.026943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51131298 ORDER BY `minOrder` ASC [ RunTime:0.008781s ]
select * from pdf where partno='3050525-std' and brandshort='laird technologies' limit 1 [ RunTime:0.012739s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050525-std' OR `brand` LIKE 'laird technologies%' ) ) LIMIT 1 [ RunTime:0.006739s ]
SELECT `id` FROM `stock` WHERE `id` <> 51131298 AND `partno` = '3050525-std' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%laird technologies%' ) [ RunTime:0.001081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11993143 [ RunTime:0.005985s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51133139 LIMIT 5 [ RunTime:0.005179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51133139 ORDER BY `minOrder` ASC [ RunTime:0.016067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51133139 ORDER BY `unit` DESC [ RunTime:0.026190s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51133139 LIMIT 2 [ RunTime:0.022610s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51133139 ORDER BY `minOrder` ASC [ RunTime:0.014432s ]
select * from pdf where partno='3050.12pz' and brandshort='igus' limit 1 [ RunTime:0.024676s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050.12pz' OR `brand` LIKE 'igus%' ) ) LIMIT 1 [ RunTime:0.021635s ]
SELECT `id` FROM `stock` WHERE `id` <> 51133139 AND `partno` = '3050.12pz' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%igus%' ) [ RunTime:0.029239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51139192 LIMIT 5 [ RunTime:0.007648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51139192 ORDER BY `minOrder` ASC [ RunTime:0.023494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51139192 ORDER BY `unit` DESC [ RunTime:0.015393s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51139192 LIMIT 2 [ RunTime:0.015150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51139192 ORDER BY `minOrder` ASC [ RunTime:0.000917s ]
select * from pdf where partno='3050 br005' and brandshort='alpha wire' limit 1 [ RunTime:0.001543s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050 br005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.059501s ]
SELECT `id` FROM `stock` WHERE `id` <> 51139192 AND `partno` = '3050 br005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.055563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407272 [ RunTime:0.024436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138972 LIMIT 5 [ RunTime:0.011283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138972 ORDER BY `minOrder` ASC [ RunTime:0.009641s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138972 ORDER BY `unit` DESC [ RunTime:0.006089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138972 LIMIT 2 [ RunTime:0.018615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138972 ORDER BY `minOrder` ASC [ RunTime:0.007084s ]
select * from pdf where partno='3050 wh001' and brandshort='alpha wire' limit 1 [ RunTime:0.014366s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050 wh001' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.006179s ]
SELECT `id` FROM `stock` WHERE `id` <> 51138972 AND `partno` = '3050 wh001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.025012s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407463 [ RunTime:0.042003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138974 LIMIT 5 [ RunTime:0.022473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138974 ORDER BY `minOrder` ASC [ RunTime:0.012307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138974 ORDER BY `unit` DESC [ RunTime:0.023873s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138974 LIMIT 2 [ RunTime:0.024116s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138974 ORDER BY `minOrder` ASC [ RunTime:0.014166s ]
select * from pdf where partno='3050 br001' and brandshort='alpha wire' limit 1 [ RunTime:0.027451s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050 br001' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.047861s ]
SELECT `id` FROM `stock` WHERE `id` <> 51138974 AND `partno` = '3050 br001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.042077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407504 [ RunTime:0.011271s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32246264 LIMIT 5 [ RunTime:0.002070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32246264 ORDER BY `minOrder` ASC [ RunTime:0.041850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32246264 ORDER BY `unit` DESC [ RunTime:0.039259s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32246264 LIMIT 2 [ RunTime:0.015344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32246264 ORDER BY `minOrder` ASC [ RunTime:0.002771s ]
select * from pdf where partno='3050s10' and brandshort='honeywell' limit 1 [ RunTime:0.019668s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050s10' OR `brand` LIKE 'honeywell%' ) ) LIMIT 1 [ RunTime:0.022128s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51139193 LIMIT 5 [ RunTime:0.014333s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51139193 ORDER BY `minOrder` ASC [ RunTime:0.081508s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51139193 ORDER BY `unit` DESC [ RunTime:0.014942s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51139193 LIMIT 2 [ RunTime:0.007788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51139193 ORDER BY `minOrder` ASC [ RunTime:0.009823s ]
select * from pdf where partno='3050 gy005' and brandshort='alpha wire' limit 1 [ RunTime:0.038272s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050 gy005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.012690s ]
SELECT `id` FROM `stock` WHERE `id` <> 51139193 AND `partno` = '3050 gy005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.029816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13492292 [ RunTime:0.015796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32246263 LIMIT 5 [ RunTime:0.010447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32246263 ORDER BY `minOrder` ASC [ RunTime:0.014593s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32246263 ORDER BY `unit` DESC [ RunTime:0.003733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32246263 LIMIT 2 [ RunTime:0.002329s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32246263 ORDER BY `minOrder` ASC [ RunTime:0.003196s ]
select * from pdf where partno='3050a20' and brandshort='honeywell' limit 1 [ RunTime:0.022122s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050a20' OR `brand` LIKE 'honeywell%' ) ) LIMIT 1 [ RunTime:0.014859s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138975 LIMIT 5 [ RunTime:0.010179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138975 ORDER BY `minOrder` ASC [ RunTime:0.011419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138975 ORDER BY `unit` DESC [ RunTime:0.009597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138975 LIMIT 2 [ RunTime:0.013311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138975 ORDER BY `minOrder` ASC [ RunTime:0.009737s ]
select * from pdf where partno='3050 rd013' and brandshort='alpha wire' limit 1 [ RunTime:0.011504s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050 rd013' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.015422s ]
SELECT `id` FROM `stock` WHERE `id` <> 51138975 AND `partno` = '3050 rd013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.019248s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13492563 [ RunTime:0.012983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51139194 LIMIT 5 [ RunTime:0.002431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51139194 ORDER BY `minOrder` ASC [ RunTime:0.002832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51139194 ORDER BY `unit` DESC [ RunTime:0.033834s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51139194 LIMIT 2 [ RunTime:0.019564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51139194 ORDER BY `minOrder` ASC [ RunTime:0.003242s ]
select * from pdf where partno='3050 bk001' and brandshort='alpha wire' limit 1 [ RunTime:0.002675s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050 bk001' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.005840s ]
SELECT `id` FROM `stock` WHERE `id` <> 51139194 AND `partno` = '3050 bk001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.020214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407821 [ RunTime:0.023225s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51139196 LIMIT 5 [ RunTime:0.009343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51139196 ORDER BY `minOrder` ASC [ RunTime:0.003047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51139196 ORDER BY `unit` DESC [ RunTime:0.001173s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51139196 LIMIT 2 [ RunTime:0.001573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51139196 ORDER BY `minOrder` ASC [ RunTime:0.001096s ]
select * from pdf where partno='3050 sl013' and brandshort='alpha wire' limit 1 [ RunTime:0.004182s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050 sl013' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.021847s ]
SELECT `id` FROM `stock` WHERE `id` <> 51139196 AND `partno` = '3050 sl013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.062235s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16408033 [ RunTime:0.014431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51138387 LIMIT 5 [ RunTime:0.006926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138387 ORDER BY `minOrder` ASC [ RunTime:0.015800s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51138387 ORDER BY `unit` DESC [ RunTime:0.011287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51138387 LIMIT 2 [ RunTime:0.016577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51138387 ORDER BY `minOrder` ASC [ RunTime:0.008171s ]
select * from pdf where partno='3050 br013' and brandshort='alpha wire' limit 1 [ RunTime:0.008356s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050 br013' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.026462s ]
SELECT `id` FROM `stock` WHERE `id` <> 51138387 AND `partno` = '3050 br013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.043979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13489879 [ RunTime:0.038908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51139197 LIMIT 5 [ RunTime:0.054883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51139197 ORDER BY `minOrder` ASC [ RunTime:0.015834s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51139197 ORDER BY `unit` DESC [ RunTime:0.006945s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51139197 LIMIT 2 [ RunTime:0.029442s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51139197 ORDER BY `minOrder` ASC [ RunTime:0.015667s ]
select * from pdf where partno='3050 pk005' and brandshort='alpha wire' limit 1 [ RunTime:0.021802s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050 pk005' OR `brand` LIKE 'alpha wire%' ) ) LIMIT 1 [ RunTime:0.008845s ]
SELECT `id` FROM `stock` WHERE `id` <> 51139197 AND `partno` = '3050 pk005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.012394s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407273 [ RunTime:0.035260s ]
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 '3050%' OR `brand` LIKE '3050%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040418s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63042268 LIMIT 5 [ RunTime:0.028687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042268 ORDER BY `minOrder` ASC [ RunTime:0.012675s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63042268 ORDER BY `unit` DESC [ RunTime:0.025815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63042268 LIMIT 2 [ RunTime:0.010289s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042268 ORDER BY `minOrder` ASC [ RunTime:0.011922s ]
select * from pdf where partno='3050 BR013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.001094s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050 BR013' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.001036s ]
SELECT `id` FROM `stock` WHERE `id` <> 63042268 AND `partno` = '3050 BR013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.002996s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13489879 [ RunTime:0.000517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63042269 LIMIT 5 [ RunTime:0.003571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042269 ORDER BY `minOrder` ASC [ RunTime:0.010564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63042269 ORDER BY `unit` DESC [ RunTime:0.001819s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63042269 LIMIT 2 [ RunTime:0.009020s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042269 ORDER BY `minOrder` ASC [ RunTime:0.003665s ]
select * from pdf where partno='3050 BL013' and brandshort='Alpha Wire' limit 1 [ RunTime:0.004084s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050 BL013' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.020737s ]
SELECT `id` FROM `stock` WHERE `id` <> 63042269 AND `partno` = '3050 BL013' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.017164s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13489878 [ RunTime:0.020172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58104612 LIMIT 5 [ RunTime:0.009218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104612 ORDER BY `minOrder` ASC [ RunTime:0.031592s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58104612 ORDER BY `unit` DESC [ RunTime:0.007503s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58104612 LIMIT 2 [ RunTime:0.010161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58104612 ORDER BY `minOrder` ASC [ RunTime:0.003763s ]
select * from pdf where partno='3050' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.024988s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.001851s ]
SELECT `id` FROM `stock` WHERE `id` <> 58104612 AND `partno` = '3050' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.023620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13388678 [ RunTime:0.010804s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64559026 LIMIT 5 [ RunTime:0.030312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64559026 ORDER BY `minOrder` ASC [ RunTime:0.014375s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64559026 ORDER BY `unit` DESC [ RunTime:0.016072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64559026 LIMIT 2 [ RunTime:0.031729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64559026 ORDER BY `minOrder` ASC [ RunTime:0.004918s ]
select * from pdf where partno='3050CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.015981s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.003901s ]
SELECT `id` FROM `stock` WHERE `id` <> 64559026 AND `partno` = '3050CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.003837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13348841 [ RunTime:0.015574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60310672 LIMIT 5 [ RunTime:0.025460s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60310672 ORDER BY `minOrder` ASC [ RunTime:0.029003s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60310672 ORDER BY `unit` DESC [ RunTime:0.015801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60310672 LIMIT 2 [ RunTime:0.010748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60310672 ORDER BY `minOrder` ASC [ RunTime:0.012321s ]
select * from pdf where partno='3050-0-01-15-00-00-03-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.001738s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050-0-01-15-00-00-03-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.005506s ]
SELECT `id` FROM `stock` WHERE `id` <> 60310672 AND `partno` = '3050-0-01-15-00-00-03-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.006655s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19593743 [ RunTime:0.014636s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63042336 LIMIT 5 [ RunTime:0.016523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042336 ORDER BY `minOrder` ASC [ RunTime:0.015338s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63042336 ORDER BY `unit` DESC [ RunTime:0.006644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63042336 LIMIT 2 [ RunTime:0.015379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042336 ORDER BY `minOrder` ASC [ RunTime:0.010753s ]
select * from pdf where partno='3050 WG005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.006723s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050 WG005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.006387s ]
SELECT `id` FROM `stock` WHERE `id` <> 63042336 AND `partno` = '3050 WG005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.001463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14371610 [ RunTime:0.001126s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63041704 LIMIT 5 [ RunTime:0.000491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63041704 ORDER BY `minOrder` ASC [ RunTime:0.009759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63041704 ORDER BY `unit` DESC [ RunTime:0.011443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63041704 LIMIT 2 [ RunTime:0.005780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63041704 ORDER BY `minOrder` ASC [ RunTime:0.001026s ]
select * from pdf where partno='3050 BK005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.000798s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050 BK005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.001629s ]
SELECT `id` FROM `stock` WHERE `id` <> 63041704 AND `partno` = '3050 BK005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.000724s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14368557 [ RunTime:0.000432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63041705 LIMIT 5 [ RunTime:0.000599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63041705 ORDER BY `minOrder` ASC [ RunTime:0.000588s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63041705 ORDER BY `unit` DESC [ RunTime:0.002379s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63041705 LIMIT 2 [ RunTime:0.019575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63041705 ORDER BY `minOrder` ASC [ RunTime:0.002919s ]
select * from pdf where partno='3050 RD005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.014456s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050 RD005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.006863s ]
SELECT `id` FROM `stock` WHERE `id` <> 63041705 AND `partno` = '3050 RD005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.012712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16404952 [ RunTime:0.001980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63042062 LIMIT 5 [ RunTime:0.008609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042062 ORDER BY `minOrder` ASC [ RunTime:0.022646s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63042062 ORDER BY `unit` DESC [ RunTime:0.009649s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63042062 LIMIT 2 [ RunTime:0.028821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042062 ORDER BY `minOrder` ASC [ RunTime:0.005137s ]
select * from pdf where partno='3050 WH001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.007663s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050 WH001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.027065s ]
SELECT `id` FROM `stock` WHERE `id` <> 63042062 AND `partno` = '3050 WH001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.030999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407463 [ RunTime:0.006355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60311320 LIMIT 5 [ RunTime:0.006688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60311320 ORDER BY `minOrder` ASC [ RunTime:0.007845s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60311320 ORDER BY `unit` DESC [ RunTime:0.008507s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60311320 LIMIT 2 [ RunTime:0.008502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60311320 ORDER BY `minOrder` ASC [ RunTime:0.019703s ]
select * from pdf where partno='3050-3-01-15-00-00-03-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.006432s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050-3-01-15-00-00-03-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.010391s ]
SELECT `id` FROM `stock` WHERE `id` <> 60311320 AND `partno` = '3050-3-01-15-00-00-03-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.013549s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19593780 [ RunTime:0.027272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63396206 LIMIT 5 [ RunTime:0.005028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63396206 ORDER BY `minOrder` ASC [ RunTime:0.030391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63396206 ORDER BY `unit` DESC [ RunTime:0.009220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63396206 LIMIT 2 [ RunTime:0.001079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63396206 ORDER BY `minOrder` ASC [ RunTime:0.002681s ]
select * from pdf where partno='3050-B-440-AL' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.006604s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050-B-440-AL' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.004451s ]
SELECT `id` FROM `stock` WHERE `id` <> 63396206 AND `partno` = '3050-B-440-AL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.012495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13316917 [ RunTime:0.012281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63041706 LIMIT 5 [ RunTime:0.009281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63041706 ORDER BY `minOrder` ASC [ RunTime:0.004434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63041706 ORDER BY `unit` DESC [ RunTime:0.012129s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63041706 LIMIT 2 [ RunTime:0.013885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63041706 ORDER BY `minOrder` ASC [ RunTime:0.002530s ]
select * from pdf where partno='3050 WH005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.014257s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050 WH005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.005014s ]
SELECT `id` FROM `stock` WHERE `id` <> 63041706 AND `partno` = '3050 WH005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.019617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14368556 [ RunTime:0.007263s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63041707 LIMIT 5 [ RunTime:0.004277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63041707 ORDER BY `minOrder` ASC [ RunTime:0.006429s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63041707 ORDER BY `unit` DESC [ RunTime:0.005679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63041707 LIMIT 2 [ RunTime:0.005157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63041707 ORDER BY `minOrder` ASC [ RunTime:0.004700s ]
select * from pdf where partno='3050 BL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.021082s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050 BL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.011080s ]
SELECT `id` FROM `stock` WHERE `id` <> 63041707 AND `partno` = '3050 BL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.027520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16406994 [ RunTime:0.042324s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63049058 LIMIT 5 [ RunTime:0.020844s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63049058 ORDER BY `minOrder` ASC [ RunTime:0.056918s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63049058 ORDER BY `unit` DESC [ RunTime:0.014013s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63049058 LIMIT 2 [ RunTime:0.017876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63049058 ORDER BY `minOrder` ASC [ RunTime:0.005352s ]
select * from pdf where partno='3050 WO005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.011154s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050 WO005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.059092s ]
SELECT `id` FROM `stock` WHERE `id` <> 63049058 AND `partno` = '3050 WO005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.047696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14372562 [ RunTime:0.035498s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63041708 LIMIT 5 [ RunTime:0.051498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63041708 ORDER BY `minOrder` ASC [ RunTime:0.175529s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63041708 ORDER BY `unit` DESC [ RunTime:0.034631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63041708 LIMIT 2 [ RunTime:0.092615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63041708 ORDER BY `minOrder` ASC [ RunTime:0.072856s ]
select * from pdf where partno='3050 GR005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.029378s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050 GR005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.043105s ]
SELECT `id` FROM `stock` WHERE `id` <> 63041708 AND `partno` = '3050 GR005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.076834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16406996 [ RunTime:0.121207s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64416223 LIMIT 5 [ RunTime:0.039492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64416223 ORDER BY `minOrder` ASC [ RunTime:0.096060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64416223 ORDER BY `unit` DESC [ RunTime:0.017458s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64416223 LIMIT 2 [ RunTime:0.038272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64416223 ORDER BY `minOrder` ASC [ RunTime:0.001410s ]
select * from pdf where partno='30506' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.009865s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '30506' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.010029s ]
SELECT `id` FROM `stock` WHERE `id` <> 64416223 AND `partno` = '30506' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.018623s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11989052 [ RunTime:0.010172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63489133 LIMIT 5 [ RunTime:0.000558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63489133 ORDER BY `minOrder` ASC [ RunTime:0.005721s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63489133 ORDER BY `unit` DESC [ RunTime:0.004536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63489133 LIMIT 2 [ RunTime:0.009207s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63489133 ORDER BY `minOrder` ASC [ RunTime:0.008522s ]
select * from pdf where partno='3050' and brandshort='SCS' limit 1 [ RunTime:0.019901s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050' OR `brand` LIKE 'SCS%' ) ) LIMIT 1 [ RunTime:0.019065s ]
SELECT `id` FROM `stock` WHERE `id` <> 63489133 AND `partno` = '3050' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%scs%' ) [ RunTime:0.022247s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19508062 [ RunTime:0.008955s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63042063 LIMIT 5 [ RunTime:0.023021s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042063 ORDER BY `minOrder` ASC [ RunTime:0.013382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63042063 ORDER BY `unit` DESC [ RunTime:0.001584s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63042063 LIMIT 2 [ RunTime:0.009401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63042063 ORDER BY `minOrder` ASC [ RunTime:0.008957s ]
select * from pdf where partno='3050 BK001' and brandshort='Alpha Wire' limit 1 [ RunTime:0.011504s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050 BK001' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.007927s ]
SELECT `id` FROM `stock` WHERE `id` <> 63042063 AND `partno` = '3050 BK001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.020809s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16407821 [ RunTime:0.003728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63393971 LIMIT 5 [ RunTime:0.006890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63393971 ORDER BY `minOrder` ASC [ RunTime:0.003927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63393971 ORDER BY `unit` DESC [ RunTime:0.000613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63393971 LIMIT 2 [ RunTime:0.001670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63393971 ORDER BY `minOrder` ASC [ RunTime:0.018142s ]
select * from pdf where partno='3050T-B-632-SS' and brandshort='RAF Electronic Hardware' limit 1 [ RunTime:0.013953s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050T-B-632-SS' OR `brand` LIKE 'RAF Electronic Hardware%' ) ) LIMIT 1 [ RunTime:0.013167s ]
SELECT `id` FROM `stock` WHERE `id` <> 63393971 AND `partno` = '3050T-B-632-SS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%raf electronic hardware%' ) [ RunTime:0.003711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12042662 [ RunTime:0.013119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63041709 LIMIT 5 [ RunTime:0.004498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63041709 ORDER BY `minOrder` ASC [ RunTime:0.023265s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63041709 ORDER BY `unit` DESC [ RunTime:0.057250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63041709 LIMIT 2 [ RunTime:0.022429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63041709 ORDER BY `minOrder` ASC [ RunTime:0.005187s ]
select * from pdf where partno='3050 YL005' and brandshort='Alpha Wire' limit 1 [ RunTime:0.010664s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3050 YL005' OR `brand` LIKE 'Alpha Wire%' ) ) LIMIT 1 [ RunTime:0.009236s ]
SELECT `id` FROM `stock` WHERE `id` <> 63041709 AND `partno` = '3050 YL005' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%alpha wire%' ) [ RunTime:0.005950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16406995 [ RunTime:0.003647s ]
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 '3050%' OR `brand` LIKE '3050%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008515s ]
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 '3050%' OR `brand` LIKE '3050%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023527s ]
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 '3050%' OR `brand` LIKE '3050%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045773s ]
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 '3050%' OR `brand` LIKE '3050%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008382s ]
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 '3050%' OR `brand` LIKE '3050%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001536s ]
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 '3050%' OR `brand` LIKE '3050%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004943s ]
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 '3050%' OR `brand` LIKE '3050%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020768s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '3050%' OR `brand` LIKE '3050%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.007982s ]