SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002430s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.215' , `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=8209&search=1' [ RunTime:0.003348s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002224s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000578s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002652s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.215' ) [ RunTime:0.000406s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002330s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000360s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002906s ]
SELECT * FROM `stock_search` WHERE `partno` = '8209' LIMIT 1 [ RunTime:0.023429s ]
UPDATE `stock_search` SET `count` = 6 , `updatetime` = '2026-08-13 00:06:53' WHERE `partno` = '8209' [ RunTime:0.009101s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002255s ]
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 '8209%' OR `brand` LIKE '8209%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017947s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11416446 LIMIT 5 [ RunTime:0.015559s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.015580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11416446 ORDER BY `minOrder` ASC [ RunTime:0.009133s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.005223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11416446 ORDER BY `unit` DESC [ RunTime:0.019641s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11416446 LIMIT 2 [ RunTime:0.023609s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11416446 ORDER BY `minOrder` ASC [ RunTime:0.028571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13144496 LIMIT 5 [ RunTime:0.015597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13144496 ORDER BY `minOrder` ASC [ RunTime:0.006778s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13144496 ORDER BY `unit` DESC [ RunTime:0.020342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13144496 LIMIT 2 [ RunTime:0.015867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13144496 ORDER BY `minOrder` ASC [ RunTime:0.019083s ]
select * from pdf where partno='8209-7000' and brandshort='3M' limit 1 [ RunTime:0.017728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13145083 LIMIT 5 [ RunTime:0.029569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13145083 ORDER BY `minOrder` ASC [ RunTime:0.054095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13145083 ORDER BY `unit` DESC [ RunTime:0.021759s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13145083 LIMIT 2 [ RunTime:0.058008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13145083 ORDER BY `minOrder` ASC [ RunTime:0.021681s ]
select * from pdf where partno='8209-8003' and brandshort='3M' limit 1 [ RunTime:0.056094s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13166379 LIMIT 5 [ RunTime:0.011466s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13166379 ORDER BY `minOrder` ASC [ RunTime:0.011509s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13166379 ORDER BY `unit` DESC [ RunTime:0.007117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13166379 LIMIT 2 [ RunTime:0.014422s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13166379 ORDER BY `minOrder` ASC [ RunTime:0.020495s ]
select * from pdf where partno='8209-6003' and brandshort='3M' limit 1 [ RunTime:0.025134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13145594 LIMIT 5 [ RunTime:0.093918s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13145594 ORDER BY `minOrder` ASC [ RunTime:0.076523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13145594 ORDER BY `unit` DESC [ RunTime:0.101569s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13145594 LIMIT 2 [ RunTime:0.067964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13145594 ORDER BY `minOrder` ASC [ RunTime:0.040334s ]
select * from pdf where partno='8209-6009' and brandshort='3M' limit 1 [ RunTime:0.055445s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19021169 LIMIT 5 [ RunTime:0.092898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19021169 ORDER BY `minOrder` ASC [ RunTime:0.064054s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19021169 ORDER BY `unit` DESC [ RunTime:0.045698s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19021169 LIMIT 2 [ RunTime:0.035695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19021169 ORDER BY `minOrder` ASC [ RunTime:0.000525s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18753654 LIMIT 5 [ RunTime:0.048267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753654 ORDER BY `minOrder` ASC [ RunTime:0.011087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18753654 ORDER BY `unit` DESC [ RunTime:0.010470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18753654 LIMIT 2 [ RunTime:0.030583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18753654 ORDER BY `minOrder` ASC [ RunTime:0.011571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18752562 LIMIT 5 [ RunTime:0.073163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18752562 ORDER BY `minOrder` ASC [ RunTime:0.033755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18752562 ORDER BY `unit` DESC [ RunTime:0.060848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18752562 LIMIT 2 [ RunTime:0.033705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18752562 ORDER BY `minOrder` ASC [ RunTime:0.006334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18712309 LIMIT 5 [ RunTime:0.061306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18712309 ORDER BY `minOrder` ASC [ RunTime:0.043932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18712309 ORDER BY `unit` DESC [ RunTime:0.030883s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18712309 LIMIT 2 [ RunTime:0.040853s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18712309 ORDER BY `minOrder` ASC [ RunTime:0.009930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17003087 LIMIT 5 [ RunTime:0.029965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17003087 ORDER BY `minOrder` ASC [ RunTime:0.046872s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17003087 ORDER BY `unit` DESC [ RunTime:0.024730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17003087 LIMIT 2 [ RunTime:0.023475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17003087 ORDER BY `minOrder` ASC [ RunTime:0.004426s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13270912 LIMIT 5 [ RunTime:0.029956s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13270912 ORDER BY `minOrder` ASC [ RunTime:0.016132s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13270912 ORDER BY `unit` DESC [ RunTime:0.009384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13270912 LIMIT 2 [ RunTime:0.032439s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13270912 ORDER BY `minOrder` ASC [ RunTime:0.013293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13145644 LIMIT 5 [ RunTime:0.012213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13145644 ORDER BY `minOrder` ASC [ RunTime:0.010446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13145644 ORDER BY `unit` DESC [ RunTime:0.027342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13145644 LIMIT 2 [ RunTime:0.015045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13145644 ORDER BY `minOrder` ASC [ RunTime:0.026414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13144089 LIMIT 5 [ RunTime:0.026286s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13144089 ORDER BY `minOrder` ASC [ RunTime:0.000485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13144089 ORDER BY `unit` DESC [ RunTime:0.003829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13144089 LIMIT 2 [ RunTime:0.034475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13144089 ORDER BY `minOrder` ASC [ RunTime:0.005533s ]
select * from pdf where partno='8209-7003' and brandshort='3M' limit 1 [ RunTime:0.012114s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13140324 LIMIT 5 [ RunTime:0.023975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13140324 ORDER BY `minOrder` ASC [ RunTime:0.016762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13140324 ORDER BY `unit` DESC [ RunTime:0.022334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13140324 LIMIT 2 [ RunTime:0.018441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13140324 ORDER BY `minOrder` ASC [ RunTime:0.001527s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13135490 LIMIT 5 [ RunTime:0.004858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13135490 ORDER BY `minOrder` ASC [ RunTime:0.005294s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13135490 ORDER BY `unit` DESC [ RunTime:0.015594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13135490 LIMIT 2 [ RunTime:0.019882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13135490 ORDER BY `minOrder` ASC [ RunTime:0.005408s ]
select * from pdf where partno='8209-6004' and brandshort='3M' limit 1 [ RunTime:0.006016s ]
select foldpath,foldpath2,filename from pdf_file where id=592348 limit 1 [ RunTime:0.006577s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13130342 LIMIT 5 [ RunTime:0.019960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13130342 ORDER BY `minOrder` ASC [ RunTime:0.004074s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13130342 ORDER BY `unit` DESC [ RunTime:0.021981s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13130342 LIMIT 2 [ RunTime:0.010234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13130342 ORDER BY `minOrder` ASC [ RunTime:0.013503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13130340 LIMIT 5 [ RunTime:0.000876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13130340 ORDER BY `minOrder` ASC [ RunTime:0.003095s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13130340 ORDER BY `unit` DESC [ RunTime:0.000495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13130340 LIMIT 2 [ RunTime:0.001030s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13130340 ORDER BY `minOrder` ASC [ RunTime:0.008463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13128674 LIMIT 5 [ RunTime:0.016962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13128674 ORDER BY `minOrder` ASC [ RunTime:0.006280s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13128674 ORDER BY `unit` DESC [ RunTime:0.021799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13128674 LIMIT 2 [ RunTime:0.000782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13128674 ORDER BY `minOrder` ASC [ RunTime:0.000563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13120773 LIMIT 5 [ RunTime:0.001095s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13120773 ORDER BY `minOrder` ASC [ RunTime:0.010025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13120773 ORDER BY `unit` DESC [ RunTime:0.014789s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13120773 LIMIT 2 [ RunTime:0.014250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13120773 ORDER BY `minOrder` ASC [ RunTime:0.007689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11883040 LIMIT 5 [ RunTime:0.002888s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11883040 ORDER BY `minOrder` ASC [ RunTime:0.006423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11883040 ORDER BY `unit` DESC [ RunTime:0.002316s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11883040 LIMIT 2 [ RunTime:0.007563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11883040 ORDER BY `minOrder` ASC [ RunTime:0.008374s ]
select * from pdf where partno='8209-6000' and brandshort='3M' limit 1 [ RunTime:0.022350s ]
select foldpath,foldpath2,filename from pdf_file where id=592348 limit 1 [ RunTime:0.007789s ]
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 '8209%' OR `brand` LIKE '8209%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51106047 LIMIT 5 [ RunTime:0.033553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51106047 ORDER BY `minOrder` ASC [ RunTime:0.011842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51106047 ORDER BY `unit` DESC [ RunTime:0.015141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51106047 LIMIT 2 [ RunTime:0.023394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51106047 ORDER BY `minOrder` ASC [ RunTime:0.018728s ]
select * from pdf where partno='820999' and brandshort='wurth elektronik' limit 1 [ RunTime:0.020573s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002631s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '820999' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.031611s ]
SELECT `id` FROM `stock` WHERE `id` <> 51106047 AND `partno` = '820999' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.025593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13270912 [ RunTime:0.048380s ]
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 '8209%' OR `brand` LIKE '8209%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61939218 LIMIT 5 [ RunTime:0.027785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61939218 ORDER BY `minOrder` ASC [ RunTime:0.036550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61939218 ORDER BY `unit` DESC [ RunTime:0.049833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61939218 LIMIT 2 [ RunTime:0.052234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61939218 ORDER BY `minOrder` ASC [ RunTime:0.031902s ]
select * from pdf where partno='8209-8000' and brandshort='3M' limit 1 [ RunTime:0.035634s ]
select foldpath,foldpath2,filename from pdf_file where id=592348 limit 1 [ RunTime:0.029001s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8209-8000' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.038529s ]
SELECT `id` FROM `stock` WHERE `id` <> 61939218 AND `partno` = '8209-8000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.029795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13120773 [ RunTime:0.041882s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60647153 LIMIT 5 [ RunTime:0.059707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60647153 ORDER BY `minOrder` ASC [ RunTime:0.021591s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60647153 ORDER BY `unit` DESC [ RunTime:0.011865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60647153 LIMIT 2 [ RunTime:0.018084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60647153 ORDER BY `minOrder` ASC [ RunTime:0.006447s ]
select * from pdf where partno='8209' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.020965s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8209' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.000721s ]
SELECT `id` FROM `stock` WHERE `id` <> 60647153 AND `partno` = '8209' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.002677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11416446 [ RunTime:0.022145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61938461 LIMIT 5 [ RunTime:0.034186s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61938461 ORDER BY `minOrder` ASC [ RunTime:0.030401s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61938461 ORDER BY `unit` DESC [ RunTime:0.021691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61938461 LIMIT 2 [ RunTime:0.013879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61938461 ORDER BY `minOrder` ASC [ RunTime:0.021037s ]
select * from pdf where partno='8209-6009' and brandshort='3M' limit 1 [ RunTime:0.006153s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8209-6009' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.062893s ]
SELECT `id` FROM `stock` WHERE `id` <> 61938461 AND `partno` = '8209-6009' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.091965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11866026 [ RunTime:0.076625s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61944212 LIMIT 5 [ RunTime:0.017995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61944212 ORDER BY `minOrder` ASC [ RunTime:0.023034s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61944212 ORDER BY `unit` DESC [ RunTime:0.036072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61944212 LIMIT 2 [ RunTime:0.047120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61944212 ORDER BY `minOrder` ASC [ RunTime:0.007934s ]
select * from pdf where partno='8209-6003' and brandshort='3M' limit 1 [ RunTime:0.022813s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8209-6003' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.001972s ]
SELECT `id` FROM `stock` WHERE `id` <> 61944212 AND `partno` = '8209-6003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.014236s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11866028 [ RunTime:0.030768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61978590 LIMIT 5 [ RunTime:0.022591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61978590 ORDER BY `minOrder` ASC [ RunTime:0.055983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61978590 ORDER BY `unit` DESC [ RunTime:0.092848s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61978590 LIMIT 2 [ RunTime:0.036027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61978590 ORDER BY `minOrder` ASC [ RunTime:0.012910s ]
select * from pdf where partno='8209-7000' and brandshort='3M' limit 1 [ RunTime:0.008538s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8209-7000' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.042083s ]
SELECT `id` FROM `stock` WHERE `id` <> 61978590 AND `partno` = '8209-7000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.055206s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13130342 [ RunTime:0.049530s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64131864 LIMIT 5 [ RunTime:0.035965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64131864 ORDER BY `minOrder` ASC [ RunTime:0.026028s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64131864 ORDER BY `unit` DESC [ RunTime:0.049253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64131864 LIMIT 2 [ RunTime:0.020560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64131864 ORDER BY `minOrder` ASC [ RunTime:0.028869s ]
select * from pdf where partno='820961-SF' and brandshort='TE Connectivity' limit 1 [ RunTime:0.025218s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '820961-SF' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.041099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 64421983 LIMIT 5 [ RunTime:0.007558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64421983 ORDER BY `minOrder` ASC [ RunTime:0.023156s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 64421983 ORDER BY `unit` DESC [ RunTime:0.042555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 64421983 LIMIT 2 [ RunTime:0.024072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 64421983 ORDER BY `minOrder` ASC [ RunTime:0.001570s ]
select * from pdf where partno='82090' and brandshort='3M' limit 1 [ RunTime:0.028296s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '82090' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.060662s ]
SELECT `id` FROM `stock` WHERE `id` <> 64421983 AND `partno` = '82090' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.019320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18712309 [ RunTime:0.004013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63532043 LIMIT 5 [ RunTime:0.013449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63532043 ORDER BY `minOrder` ASC [ RunTime:0.039123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63532043 ORDER BY `unit` DESC [ RunTime:0.038661s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63532043 LIMIT 2 [ RunTime:0.009761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63532043 ORDER BY `minOrder` ASC [ RunTime:0.009314s ]
select * from pdf where partno='820999' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.015988s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '820999' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.030422s ]
SELECT `id` FROM `stock` WHERE `id` <> 63532043 AND `partno` = '820999' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.012542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13270912 [ RunTime:0.009315s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61975333 LIMIT 5 [ RunTime:0.010564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61975333 ORDER BY `minOrder` ASC [ RunTime:0.011651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61975333 ORDER BY `unit` DESC [ RunTime:0.014790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61975333 LIMIT 2 [ RunTime:0.010447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61975333 ORDER BY `minOrder` ASC [ RunTime:0.008812s ]
select * from pdf where partno='8209-7003' and brandshort='3M' limit 1 [ RunTime:0.004207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8209-7003' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.016304s ]
SELECT `id` FROM `stock` WHERE `id` <> 61975333 AND `partno` = '8209-7003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.043710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13130340 [ RunTime:0.010004s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61971014 LIMIT 5 [ RunTime:0.011430s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61971014 ORDER BY `minOrder` ASC [ RunTime:0.010477s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61971014 ORDER BY `unit` DESC [ RunTime:0.011428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61971014 LIMIT 2 [ RunTime:0.008451s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61971014 ORDER BY `minOrder` ASC [ RunTime:0.006329s ]
select * from pdf where partno='8209-8009' and brandshort='3M' limit 1 [ RunTime:0.040226s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8209-8009' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.008420s ]
SELECT `id` FROM `stock` WHERE `id` <> 61971014 AND `partno` = '8209-8009' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.006531s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13128674 [ RunTime:0.005312s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61965746 LIMIT 5 [ RunTime:0.032877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61965746 ORDER BY `minOrder` ASC [ RunTime:0.009491s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61965746 ORDER BY `unit` DESC [ RunTime:0.016898s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61965746 LIMIT 2 [ RunTime:0.010931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61965746 ORDER BY `minOrder` ASC [ RunTime:0.009176s ]
select * from pdf where partno='8209-7009' and brandshort='3M' limit 1 [ RunTime:0.043077s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8209-7009' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.025429s ]
SELECT `id` FROM `stock` WHERE `id` <> 61965746 AND `partno` = '8209-7009' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.008624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13140324 [ RunTime:0.021981s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61958699 LIMIT 5 [ RunTime:0.019304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61958699 ORDER BY `minOrder` ASC [ RunTime:0.032746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61958699 ORDER BY `unit` DESC [ RunTime:0.048873s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61958699 LIMIT 2 [ RunTime:0.030739s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61958699 ORDER BY `minOrder` ASC [ RunTime:0.015674s ]
select * from pdf where partno='8209-6004' and brandshort='3M' limit 1 [ RunTime:0.018816s ]
select foldpath,foldpath2,filename from pdf_file where id=592348 limit 1 [ RunTime:0.012053s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8209-6004' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.021497s ]
SELECT `id` FROM `stock` WHERE `id` <> 61958699 AND `partno` = '8209-6004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.047700s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13135490 [ RunTime:0.016131s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61950410 LIMIT 5 [ RunTime:0.042567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61950410 ORDER BY `minOrder` ASC [ RunTime:0.045850s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61950410 ORDER BY `unit` DESC [ RunTime:0.026269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61950410 LIMIT 2 [ RunTime:0.034348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61950410 ORDER BY `minOrder` ASC [ RunTime:0.015457s ]
select * from pdf where partno='8209-8003' and brandshort='3M' limit 1 [ RunTime:0.006555s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8209-8003' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.030310s ]
SELECT `id` FROM `stock` WHERE `id` <> 61950410 AND `partno` = '8209-8003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.051490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11866032 [ RunTime:0.036313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61948665 LIMIT 5 [ RunTime:0.014883s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61948665 ORDER BY `minOrder` ASC [ RunTime:0.058220s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61948665 ORDER BY `unit` DESC [ RunTime:0.030770s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61948665 LIMIT 2 [ RunTime:0.008025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61948665 ORDER BY `minOrder` ASC [ RunTime:0.013898s ]
select * from pdf where partno='8209-6000' and brandshort='3M' limit 1 [ RunTime:0.000608s ]
select foldpath,foldpath2,filename from pdf_file where id=592348 limit 1 [ RunTime:0.006865s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8209-6000' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.035338s ]
SELECT `id` FROM `stock` WHERE `id` <> 61948665 AND `partno` = '8209-6000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.010409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11866024 [ RunTime:0.024017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61002504 LIMIT 5 [ RunTime:0.024542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61002504 ORDER BY `minOrder` ASC [ RunTime:0.041108s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61002504 ORDER BY `unit` DESC [ RunTime:0.033679s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61002504 LIMIT 2 [ RunTime:0.022119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61002504 ORDER BY `minOrder` ASC [ RunTime:0.020205s ]
select * from pdf where partno='8209730000' and brandshort='Weidmüller' limit 1 [ RunTime:0.045002s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8209730000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.008943s ]
SELECT `id` FROM `stock` WHERE `id` <> 61002504 AND `partno` = '8209730000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.019993s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11433560 [ RunTime:0.023378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59392081 LIMIT 5 [ RunTime:0.032412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59392081 ORDER BY `minOrder` ASC [ RunTime:0.019468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59392081 ORDER BY `unit` DESC [ RunTime:0.016106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59392081 LIMIT 2 [ RunTime:0.013413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59392081 ORDER BY `minOrder` ASC [ RunTime:0.025948s ]
select * from pdf where partno='8209340000' and brandshort='Weidmüller' limit 1 [ RunTime:0.008635s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '8209340000' OR `brand` LIKE 'Weidmüller%' ) ) LIMIT 1 [ RunTime:0.024730s ]
SELECT `id` FROM `stock` WHERE `id` <> 59392081 AND `partno` = '8209340000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmüller%' ) [ RunTime:0.010937s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 44032297 LIMIT 5 [ RunTime:0.000734s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44032297 ORDER BY `minOrder` ASC [ RunTime:0.035315s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 44032297 ORDER BY `unit` DESC [ RunTime:0.046643s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 44032297 LIMIT 2 [ RunTime:0.013527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 44032297 ORDER BY `minOrder` ASC [ RunTime:0.002073s ]
select * from pdf where partno='820936-1' and brandshort='TE Application Tooling' limit 1 [ RunTime:0.008066s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '820936-1' OR `brand` LIKE 'TE Application Tooling%' ) ) LIMIT 1 [ RunTime:0.046130s ]
SELECT `id` FROM `stock` WHERE `id` <> 44032297 AND `partno` = '820936-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te application tooling%' ) [ RunTime:0.034662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17003087 [ RunTime:0.046900s ]
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 '8209%' OR `brand` LIKE '8209%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021397s ]
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 '8209%' OR `brand` LIKE '8209%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005222s ]
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 '8209%' OR `brand` LIKE '8209%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.055264s ]
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 '8209%' OR `brand` LIKE '8209%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008824s ]
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 '8209%' OR `brand` LIKE '8209%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003081s ]
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 '8209%' OR `brand` LIKE '8209%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021726s ]
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 '8209%' OR `brand` LIKE '8209%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009583s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '8209%' OR `brand` LIKE '8209%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.008770s ]