SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002292s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.251' , `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=3043&search=1' [ RunTime:0.027691s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003245s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.030864s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002521s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.251' ) [ RunTime:0.010325s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002232s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.015209s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002388s ]
SELECT * FROM `stock_search` WHERE `partno` = '3043' LIMIT 1 [ RunTime:0.024048s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-31 03:02:57' WHERE `partno` = '3043' [ RunTime:0.025482s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001303s ]
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 '3043%' OR `brand` LIKE '3043%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031133s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007965s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15447423 LIMIT 5 [ RunTime:0.028177s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15447423 ORDER BY `minOrder` ASC [ RunTime:0.024236s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004849s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15447423 ORDER BY `unit` DESC [ RunTime:0.005076s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15447423 LIMIT 2 [ RunTime:0.006290s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15447423 ORDER BY `minOrder` ASC [ RunTime:0.015338s ]
select * from pdf where partno='3043200' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.029606s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13468667 LIMIT 5 [ RunTime:0.024325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13468667 ORDER BY `minOrder` ASC [ RunTime:0.021649s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13468667 ORDER BY `unit` DESC [ RunTime:0.010869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13468667 LIMIT 2 [ RunTime:0.000513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13468667 ORDER BY `minOrder` ASC [ RunTime:0.002028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19615229 LIMIT 5 [ RunTime:0.015509s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19615229 ORDER BY `minOrder` ASC [ RunTime:0.034166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19615229 ORDER BY `unit` DESC [ RunTime:0.027459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19615229 LIMIT 2 [ RunTime:0.037519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19615229 ORDER BY `minOrder` ASC [ RunTime:0.035181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18700818 LIMIT 5 [ RunTime:0.036135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700818 ORDER BY `minOrder` ASC [ RunTime:0.038425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18700818 ORDER BY `unit` DESC [ RunTime:0.037525s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18700818 LIMIT 2 [ RunTime:0.045498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700818 ORDER BY `minOrder` ASC [ RunTime:0.006111s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13177957 LIMIT 5 [ RunTime:0.029086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13177957 ORDER BY `minOrder` ASC [ RunTime:0.021613s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13177957 ORDER BY `unit` DESC [ RunTime:0.025538s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13177957 LIMIT 2 [ RunTime:0.025036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13177957 ORDER BY `minOrder` ASC [ RunTime:0.019564s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19650250 LIMIT 5 [ RunTime:0.009128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650250 ORDER BY `minOrder` ASC [ RunTime:0.019049s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19650250 ORDER BY `unit` DESC [ RunTime:0.030472s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19650250 LIMIT 2 [ RunTime:0.018308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650250 ORDER BY `minOrder` ASC [ RunTime:0.009621s ]
select * from pdf where partno='3043161' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.013629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19661796 LIMIT 5 [ RunTime:0.019445s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19661796 ORDER BY `minOrder` ASC [ RunTime:0.005421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19661796 ORDER BY `unit` DESC [ RunTime:0.051718s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19661796 LIMIT 2 [ RunTime:0.026457s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19661796 ORDER BY `minOrder` ASC [ RunTime:0.030388s ]
select * from pdf where partno='3043239' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.041187s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19605981 LIMIT 5 [ RunTime:0.033893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605981 ORDER BY `minOrder` ASC [ RunTime:0.017194s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19605981 ORDER BY `unit` DESC [ RunTime:0.050620s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19605981 LIMIT 2 [ RunTime:0.073637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19605981 ORDER BY `minOrder` ASC [ RunTime:0.000513s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19661637 LIMIT 5 [ RunTime:0.038735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19661637 ORDER BY `minOrder` ASC [ RunTime:0.042841s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19661637 ORDER BY `unit` DESC [ RunTime:0.026337s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19661637 LIMIT 2 [ RunTime:0.030560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19661637 ORDER BY `minOrder` ASC [ RunTime:0.016509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19661827 LIMIT 5 [ RunTime:0.023179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19661827 ORDER BY `minOrder` ASC [ RunTime:0.033602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19661827 ORDER BY `unit` DESC [ RunTime:0.020500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19661827 LIMIT 2 [ RunTime:0.011941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19661827 ORDER BY `minOrder` ASC [ RunTime:0.002749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19650236 LIMIT 5 [ RunTime:0.036793s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650236 ORDER BY `minOrder` ASC [ RunTime:0.047536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19650236 ORDER BY `unit` DESC [ RunTime:0.049185s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19650236 LIMIT 2 [ RunTime:0.033293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650236 ORDER BY `minOrder` ASC [ RunTime:0.090950s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17310638 LIMIT 5 [ RunTime:0.053132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17310638 ORDER BY `minOrder` ASC [ RunTime:0.076207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17310638 ORDER BY `unit` DESC [ RunTime:0.081039s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17310638 LIMIT 2 [ RunTime:0.074141s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17310638 ORDER BY `minOrder` ASC [ RunTime:0.016238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346950 LIMIT 5 [ RunTime:0.084171s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346950 ORDER BY `minOrder` ASC [ RunTime:0.072235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13346950 ORDER BY `unit` DESC [ RunTime:0.092067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13346950 LIMIT 2 [ RunTime:0.080577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13346950 ORDER BY `minOrder` ASC [ RunTime:0.005125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17304894 LIMIT 5 [ RunTime:0.048209s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17304894 ORDER BY `minOrder` ASC [ RunTime:0.099341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17304894 ORDER BY `unit` DESC [ RunTime:0.066121s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17304894 LIMIT 2 [ RunTime:0.097213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17304894 ORDER BY `minOrder` ASC [ RunTime:0.039887s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19650237 LIMIT 5 [ RunTime:0.030655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650237 ORDER BY `minOrder` ASC [ RunTime:0.064493s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19650237 ORDER BY `unit` DESC [ RunTime:0.061519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19650237 LIMIT 2 [ RunTime:0.035508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19650237 ORDER BY `minOrder` ASC [ RunTime:0.027419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18700817 LIMIT 5 [ RunTime:0.056965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700817 ORDER BY `minOrder` ASC [ RunTime:0.051617s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18700817 ORDER BY `unit` DESC [ RunTime:0.044665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18700817 LIMIT 2 [ RunTime:0.015676s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700817 ORDER BY `minOrder` ASC [ RunTime:0.034463s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11444779 LIMIT 5 [ RunTime:0.045372s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11444779 ORDER BY `minOrder` ASC [ RunTime:0.013892s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11444779 ORDER BY `unit` DESC [ RunTime:0.038726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11444779 LIMIT 2 [ RunTime:0.023575s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11444779 ORDER BY `minOrder` ASC [ RunTime:0.015931s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18700827 LIMIT 5 [ RunTime:0.060545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700827 ORDER BY `minOrder` ASC [ RunTime:0.039522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18700827 ORDER BY `unit` DESC [ RunTime:0.029891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18700827 LIMIT 2 [ RunTime:0.070160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700827 ORDER BY `minOrder` ASC [ RunTime:0.018792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18700828 LIMIT 5 [ RunTime:0.031776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700828 ORDER BY `minOrder` ASC [ RunTime:0.016896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18700828 ORDER BY `unit` DESC [ RunTime:0.022868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18700828 LIMIT 2 [ RunTime:0.036617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18700828 ORDER BY `minOrder` ASC [ RunTime:0.021261s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15206303 LIMIT 5 [ RunTime:0.037593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15206303 ORDER BY `minOrder` ASC [ RunTime:0.031377s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15206303 ORDER BY `unit` DESC [ RunTime:0.038877s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15206303 LIMIT 2 [ RunTime:0.012973s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15206303 ORDER BY `minOrder` ASC [ RunTime:0.016527s ]
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 '3043%' OR `brand` LIKE '3043%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.025257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276187 LIMIT 5 [ RunTime:0.035605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276187 ORDER BY `minOrder` ASC [ RunTime:0.020859s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276187 ORDER BY `unit` DESC [ RunTime:0.022225s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276187 LIMIT 2 [ RunTime:0.019352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276187 ORDER BY `minOrder` ASC [ RunTime:0.018679s ]
select * from pdf where partno='3043187' and brandshort='phoenix contact' limit 1 [ RunTime:0.056682s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001652s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3043187' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.024117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276400 LIMIT 5 [ RunTime:0.021904s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276400 ORDER BY `minOrder` ASC [ RunTime:0.031348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276400 ORDER BY `unit` DESC [ RunTime:0.010295s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276400 LIMIT 2 [ RunTime:0.019615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276400 ORDER BY `minOrder` ASC [ RunTime:0.003701s ]
select * from pdf where partno='3043103' and brandshort='phoenix contact' limit 1 [ RunTime:0.019252s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3043103' OR `brand` LIKE 'phoenix contact%' ) ) LIMIT 1 [ RunTime:0.014521s ]
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 '3043%' OR `brand` LIKE '3043%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029541s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57745078 LIMIT 5 [ RunTime:0.010199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57745078 ORDER BY `minOrder` ASC [ RunTime:0.013252s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57745078 ORDER BY `unit` DESC [ RunTime:0.011029s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57745078 LIMIT 2 [ RunTime:0.021304s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57745078 ORDER BY `minOrder` ASC [ RunTime:0.007959s ]
select * from pdf where partno='3043CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.007990s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3043CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.017690s ]
SELECT `id` FROM `stock` WHERE `id` <> 57745078 AND `partno` = '3043CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.021127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346950 [ RunTime:0.024705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53658240 LIMIT 5 [ RunTime:0.008056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53658240 ORDER BY `minOrder` ASC [ RunTime:0.024190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53658240 ORDER BY `unit` DESC [ RunTime:0.011891s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53658240 LIMIT 2 [ RunTime:0.019821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53658240 ORDER BY `minOrder` ASC [ RunTime:0.011163s ]
select * from pdf where partno='3043043' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.028991s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3043043' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.012451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53659797 LIMIT 5 [ RunTime:0.016185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53659797 ORDER BY `minOrder` ASC [ RunTime:0.008692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53659797 ORDER BY `unit` DESC [ RunTime:0.040550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53659797 LIMIT 2 [ RunTime:0.022808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53659797 ORDER BY `minOrder` ASC [ RunTime:0.013627s ]
select * from pdf where partno='3043200' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.022659s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3043200' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.020161s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51413321 LIMIT 5 [ RunTime:0.013043s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51413321 ORDER BY `minOrder` ASC [ RunTime:0.028413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51413321 ORDER BY `unit` DESC [ RunTime:0.018943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51413321 LIMIT 2 [ RunTime:0.026367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51413321 ORDER BY `minOrder` ASC [ RunTime:0.020736s ]
select * from pdf where partno='3043' and brandshort='Pololu' limit 1 [ RunTime:0.035353s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3043' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.015923s ]
SELECT `id` FROM `stock` WHERE `id` <> 51413321 AND `partno` = '3043' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.052665s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13468667 [ RunTime:0.016694s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53659514 LIMIT 5 [ RunTime:0.045435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53659514 ORDER BY `minOrder` ASC [ RunTime:0.025755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53659514 ORDER BY `unit` DESC [ RunTime:0.051351s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53659514 LIMIT 2 [ RunTime:0.033642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53659514 ORDER BY `minOrder` ASC [ RunTime:0.007054s ]
select * from pdf where partno='3043035' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.038823s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3043035' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.024962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52525359 LIMIT 5 [ RunTime:0.019183s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52525359 ORDER BY `minOrder` ASC [ RunTime:0.026100s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52525359 ORDER BY `unit` DESC [ RunTime:0.028563s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52525359 LIMIT 2 [ RunTime:0.021103s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52525359 ORDER BY `minOrder` ASC [ RunTime:0.009163s ]
select * from pdf where partno='3043307' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.011215s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3043307' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.054716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53663156 LIMIT 5 [ RunTime:0.025784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53663156 ORDER BY `minOrder` ASC [ RunTime:0.035487s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53663156 ORDER BY `unit` DESC [ RunTime:0.030594s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53663156 LIMIT 2 [ RunTime:0.001692s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53663156 ORDER BY `minOrder` ASC [ RunTime:0.006558s ]
select * from pdf where partno='3043019' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.035472s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3043019' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.026075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53667439 LIMIT 5 [ RunTime:0.035570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53667439 ORDER BY `minOrder` ASC [ RunTime:0.041684s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53667439 ORDER BY `unit` DESC [ RunTime:0.022723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53667439 LIMIT 2 [ RunTime:0.042663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53667439 ORDER BY `minOrder` ASC [ RunTime:0.024758s ]
select * from pdf where partno='3043064' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.053840s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3043064' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.028697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53664837 LIMIT 5 [ RunTime:0.039596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53664837 ORDER BY `minOrder` ASC [ RunTime:0.027821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53664837 ORDER BY `unit` DESC [ RunTime:0.029894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53664837 LIMIT 2 [ RunTime:0.015345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53664837 ORDER BY `minOrder` ASC [ RunTime:0.015616s ]
select * from pdf where partno='3043404' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.024058s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3043404' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.032074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53663157 LIMIT 5 [ RunTime:0.021906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53663157 ORDER BY `minOrder` ASC [ RunTime:0.031013s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53663157 ORDER BY `unit` DESC [ RunTime:0.048249s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53663157 LIMIT 2 [ RunTime:0.011638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53663157 ORDER BY `minOrder` ASC [ RunTime:0.003564s ]
select * from pdf where partno='3043077' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.010200s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3043077' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.009979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53664882 LIMIT 5 [ RunTime:0.032010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53664882 ORDER BY `minOrder` ASC [ RunTime:0.013228s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53664882 ORDER BY `unit` DESC [ RunTime:0.006901s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53664882 LIMIT 2 [ RunTime:0.021272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53664882 ORDER BY `minOrder` ASC [ RunTime:0.006895s ]
select * from pdf where partno='3043161' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.011742s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3043161' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.026355s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53666480 LIMIT 5 [ RunTime:0.024198s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53666480 ORDER BY `minOrder` ASC [ RunTime:0.021973s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53666480 ORDER BY `unit` DESC [ RunTime:0.027786s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53666480 LIMIT 2 [ RunTime:0.002868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53666480 ORDER BY `minOrder` ASC [ RunTime:0.008393s ]
select * from pdf where partno='3043051' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.043528s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3043051' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.071084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53665008 LIMIT 5 [ RunTime:0.015869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53665008 ORDER BY `minOrder` ASC [ RunTime:0.041251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53665008 ORDER BY `unit` DESC [ RunTime:0.023148s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53665008 LIMIT 2 [ RunTime:0.004204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53665008 ORDER BY `minOrder` ASC [ RunTime:0.009156s ]
select * from pdf where partno='3043271' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.023986s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3043271' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.021389s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53670536 LIMIT 5 [ RunTime:0.004334s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53670536 ORDER BY `minOrder` ASC [ RunTime:0.068953s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53670536 ORDER BY `unit` DESC [ RunTime:0.039651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53670536 LIMIT 2 [ RunTime:0.032170s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53670536 ORDER BY `minOrder` ASC [ RunTime:0.021496s ]
select * from pdf where partno='3043255' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.052809s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3043255' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.039940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51718994 LIMIT 5 [ RunTime:0.047810s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51718994 ORDER BY `minOrder` ASC [ RunTime:0.011038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51718994 ORDER BY `unit` DESC [ RunTime:0.013089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51718994 LIMIT 2 [ RunTime:0.029155s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51718994 ORDER BY `minOrder` ASC [ RunTime:0.017434s ]
select * from pdf where partno='30433' and brandshort='Wiha' limit 1 [ RunTime:0.034698s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '30433' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.084401s ]
SELECT `id` FROM `stock` WHERE `id` <> 51718994 AND `partno` = '30433' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.034615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18700817 [ RunTime:0.052088s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53670222 LIMIT 5 [ RunTime:0.028962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53670222 ORDER BY `minOrder` ASC [ RunTime:0.033346s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53670222 ORDER BY `unit` DESC [ RunTime:0.015257s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53670222 LIMIT 2 [ RunTime:0.021019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53670222 ORDER BY `minOrder` ASC [ RunTime:0.012365s ]
select * from pdf where partno='3043080' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.014035s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3043080' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.030395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53668755 LIMIT 5 [ RunTime:0.008629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53668755 ORDER BY `minOrder` ASC [ RunTime:0.027017s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53668755 ORDER BY `unit` DESC [ RunTime:0.039203s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53668755 LIMIT 2 [ RunTime:0.010544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53668755 ORDER BY `minOrder` ASC [ RunTime:0.005640s ]
select * from pdf where partno='3043093' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.033442s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3043093' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.036452s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51719008 LIMIT 5 [ RunTime:0.030912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51719008 ORDER BY `minOrder` ASC [ RunTime:0.035983s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51719008 ORDER BY `unit` DESC [ RunTime:0.032918s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51719008 LIMIT 2 [ RunTime:0.008700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51719008 ORDER BY `minOrder` ASC [ RunTime:0.011781s ]
select * from pdf where partno='30436' and brandshort='Wiha' limit 1 [ RunTime:0.008493s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '30436' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.026010s ]
SELECT `id` FROM `stock` WHERE `id` <> 51719008 AND `partno` = '30436' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.024677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15206303 [ RunTime:0.011373s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51719009 LIMIT 5 [ RunTime:0.012656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51719009 ORDER BY `minOrder` ASC [ RunTime:0.007935s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51719009 ORDER BY `unit` DESC [ RunTime:0.017745s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51719009 LIMIT 2 [ RunTime:0.016850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51719009 ORDER BY `minOrder` ASC [ RunTime:0.005419s ]
select * from pdf where partno='30437' and brandshort='Wiha' limit 1 [ RunTime:0.026863s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '30437' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.021898s ]
SELECT `id` FROM `stock` WHERE `id` <> 51719009 AND `partno` = '30437' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.004505s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18700828 [ RunTime:0.007354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51719007 LIMIT 5 [ RunTime:0.004093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51719007 ORDER BY `minOrder` ASC [ RunTime:0.006835s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51719007 ORDER BY `unit` DESC [ RunTime:0.056000s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51719007 LIMIT 2 [ RunTime:0.016555s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51719007 ORDER BY `minOrder` ASC [ RunTime:0.026953s ]
select * from pdf where partno='30435' and brandshort='Wiha' limit 1 [ RunTime:0.026321s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '30435' OR `brand` LIKE 'Wiha%' ) ) LIMIT 1 [ RunTime:0.049437s ]
SELECT `id` FROM `stock` WHERE `id` <> 51719007 AND `partno` = '30435' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.027136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18700827 [ RunTime:0.046635s ]
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 '3043%' OR `brand` LIKE '3043%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.063031s ]
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 '3043%' OR `brand` LIKE '3043%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034082s ]
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 '3043%' OR `brand` LIKE '3043%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027692s ]
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 '3043%' OR `brand` LIKE '3043%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022262s ]
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 '3043%' OR `brand` LIKE '3043%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.035674s ]
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 '3043%' OR `brand` LIKE '3043%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036672s ]
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 '3043%' OR `brand` LIKE '3043%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028048s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '3043%' OR `brand` LIKE '3043%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.018338s ]