SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001787s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.85' , `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=2566&search=1' [ RunTime:0.002769s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001592s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000515s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001320s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.85' ) [ RunTime:0.000250s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001480s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000269s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002639s ]
SELECT * FROM `stock_search` WHERE `partno` = '2566' LIMIT 1 [ RunTime:0.002365s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-29 11:15:57' WHERE `partno` = '2566' [ RunTime:0.011132s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001508s ]
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 '2566%' OR `brand` LIKE '2566%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.031394s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13347570 LIMIT 5 [ RunTime:0.008083s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001375s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13347570 ORDER BY `minOrder` ASC [ RunTime:0.005400s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003430s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13347570 ORDER BY `unit` DESC [ RunTime:0.010812s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13347570 LIMIT 2 [ RunTime:0.021055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13347570 ORDER BY `minOrder` ASC [ RunTime:0.014869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13866221 LIMIT 5 [ RunTime:0.012355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13866221 ORDER BY `minOrder` ASC [ RunTime:0.017997s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13866221 ORDER BY `unit` DESC [ RunTime:0.012206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13866221 LIMIT 2 [ RunTime:0.009308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13866221 ORDER BY `minOrder` ASC [ RunTime:0.000341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13230203 LIMIT 5 [ RunTime:0.011571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13230203 ORDER BY `minOrder` ASC [ RunTime:0.014053s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13230203 ORDER BY `unit` DESC [ RunTime:0.049318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13230203 LIMIT 2 [ RunTime:0.086240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13230203 ORDER BY `minOrder` ASC [ RunTime:0.012092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13230202 LIMIT 5 [ RunTime:0.010678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13230202 ORDER BY `minOrder` ASC [ RunTime:0.034410s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13230202 ORDER BY `unit` DESC [ RunTime:0.014939s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13230202 LIMIT 2 [ RunTime:0.061932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13230202 ORDER BY `minOrder` ASC [ RunTime:0.022946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13230201 LIMIT 5 [ RunTime:0.026932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13230201 ORDER BY `minOrder` ASC [ RunTime:0.014623s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13230201 ORDER BY `unit` DESC [ RunTime:0.047036s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13230201 LIMIT 2 [ RunTime:0.057771s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13230201 ORDER BY `minOrder` ASC [ RunTime:0.019216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11961004 LIMIT 5 [ RunTime:0.029960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11961004 ORDER BY `minOrder` ASC [ RunTime:0.039669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11961004 ORDER BY `unit` DESC [ RunTime:0.027665s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11961004 LIMIT 2 [ RunTime:0.029998s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11961004 ORDER BY `minOrder` ASC [ RunTime:0.018081s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11961002 LIMIT 5 [ RunTime:0.021235s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11961002 ORDER BY `minOrder` ASC [ RunTime:0.012768s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11961002 ORDER BY `unit` DESC [ RunTime:0.018065s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11961002 LIMIT 2 [ RunTime:0.012093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11961002 ORDER BY `minOrder` ASC [ RunTime:0.011689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13230205 LIMIT 5 [ RunTime:0.022914s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13230205 ORDER BY `minOrder` ASC [ RunTime:0.032840s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13230205 ORDER BY `unit` DESC [ RunTime:0.016243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13230205 LIMIT 2 [ RunTime:0.022274s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13230205 ORDER BY `minOrder` ASC [ RunTime:0.026528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12045901 LIMIT 5 [ RunTime:0.009218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12045901 ORDER BY `minOrder` ASC [ RunTime:0.016513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12045901 ORDER BY `unit` DESC [ RunTime:0.021229s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12045901 LIMIT 2 [ RunTime:0.034580s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12045901 ORDER BY `minOrder` ASC [ RunTime:0.008017s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828667 LIMIT 5 [ RunTime:0.008969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828667 ORDER BY `minOrder` ASC [ RunTime:0.008939s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18828667 ORDER BY `unit` DESC [ RunTime:0.020343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18828667 LIMIT 2 [ RunTime:0.009452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18828667 ORDER BY `minOrder` ASC [ RunTime:0.018014s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18851162 LIMIT 5 [ RunTime:0.005666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18851162 ORDER BY `minOrder` ASC [ RunTime:0.007247s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18851162 ORDER BY `unit` DESC [ RunTime:0.000544s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18851162 LIMIT 2 [ RunTime:0.014444s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18851162 ORDER BY `minOrder` ASC [ RunTime:0.003470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15239633 LIMIT 5 [ RunTime:0.017259s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15239633 ORDER BY `minOrder` ASC [ RunTime:0.013711s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15239633 ORDER BY `unit` DESC [ RunTime:0.030567s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15239633 LIMIT 2 [ RunTime:0.014016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15239633 ORDER BY `minOrder` ASC [ RunTime:0.025819s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14258121 LIMIT 5 [ RunTime:0.004571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14258121 ORDER BY `minOrder` ASC [ RunTime:0.012914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14258121 ORDER BY `unit` DESC [ RunTime:0.038326s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14258121 LIMIT 2 [ RunTime:0.039090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14258121 ORDER BY `minOrder` ASC [ RunTime:0.007085s ]
select * from pdf where partno='2566' and brandshort='Adafruit Industries LLC' limit 1 [ RunTime:0.010803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19601387 LIMIT 5 [ RunTime:0.028748s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19601387 ORDER BY `minOrder` ASC [ RunTime:0.029884s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19601387 ORDER BY `unit` DESC [ RunTime:0.007936s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19601387 LIMIT 2 [ RunTime:0.014424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19601387 ORDER BY `minOrder` ASC [ RunTime:0.015780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18832741 LIMIT 5 [ RunTime:0.024877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18832741 ORDER BY `minOrder` ASC [ RunTime:0.012201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18832741 ORDER BY `unit` DESC [ RunTime:0.024609s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18832741 LIMIT 2 [ RunTime:0.016148s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18832741 ORDER BY `minOrder` ASC [ RunTime:0.025504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18703135 LIMIT 5 [ RunTime:0.010279s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18703135 ORDER BY `minOrder` ASC [ RunTime:0.006863s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18703135 ORDER BY `unit` DESC [ RunTime:0.022046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18703135 LIMIT 2 [ RunTime:0.055227s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18703135 ORDER BY `minOrder` ASC [ RunTime:0.040708s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17506938 LIMIT 5 [ RunTime:0.032709s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17506938 ORDER BY `minOrder` ASC [ RunTime:0.007656s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17506938 ORDER BY `unit` DESC [ RunTime:0.024511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17506938 LIMIT 2 [ RunTime:0.080858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17506938 ORDER BY `minOrder` ASC [ RunTime:0.036597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17506119 LIMIT 5 [ RunTime:0.020144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17506119 ORDER BY `minOrder` ASC [ RunTime:0.019328s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17506119 ORDER BY `unit` DESC [ RunTime:0.040378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17506119 LIMIT 2 [ RunTime:0.016740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17506119 ORDER BY `minOrder` ASC [ RunTime:0.017710s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17505032 LIMIT 5 [ RunTime:0.039770s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17505032 ORDER BY `minOrder` ASC [ RunTime:0.016024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17505032 ORDER BY `unit` DESC [ RunTime:0.016708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17505032 LIMIT 2 [ RunTime:0.032237s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17505032 ORDER BY `minOrder` ASC [ RunTime:0.022689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17488006 LIMIT 5 [ RunTime:0.016579s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17488006 ORDER BY `minOrder` ASC [ RunTime:0.030246s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17488006 ORDER BY `unit` DESC [ RunTime:0.030032s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17488006 LIMIT 2 [ RunTime:0.038901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17488006 ORDER BY `minOrder` ASC [ RunTime:0.014635s ]
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 '2566%' OR `brand` LIKE '2566%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51081580 LIMIT 5 [ RunTime:0.050270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51081580 ORDER BY `minOrder` ASC [ RunTime:0.056506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51081580 ORDER BY `unit` DESC [ RunTime:0.018114s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51081580 LIMIT 2 [ RunTime:0.023343s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51081580 ORDER BY `minOrder` ASC [ RunTime:0.007486s ]
select * from pdf where partno='2566380000' and brandshort='weidmuller' limit 1 [ RunTime:0.019369s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003386s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2566380000' OR `brand` LIKE 'weidmuller%' ) ) LIMIT 1 [ RunTime:0.044206s ]
SELECT `id` FROM `stock` WHERE `id` <> 51081580 AND `partno` = '2566380000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.032695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18828667 [ RunTime:0.022796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51082002 LIMIT 5 [ RunTime:0.017225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51082002 ORDER BY `minOrder` ASC [ RunTime:0.041183s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51082002 ORDER BY `unit` DESC [ RunTime:0.009693s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51082002 LIMIT 2 [ RunTime:0.045257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51082002 ORDER BY `minOrder` ASC [ RunTime:0.020848s ]
select * from pdf where partno='2566970000' and brandshort='weidmuller' limit 1 [ RunTime:0.032660s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2566970000' OR `brand` LIKE 'weidmuller%' ) ) LIMIT 1 [ RunTime:0.030405s ]
SELECT `id` FROM `stock` WHERE `id` <> 51082002 AND `partno` = '2566970000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.034675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15239633 [ RunTime:0.014391s ]
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 '2566%' OR `brand` LIKE '2566%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57737434 LIMIT 5 [ RunTime:0.042146s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57737434 ORDER BY `minOrder` ASC [ RunTime:0.077860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57737434 ORDER BY `unit` DESC [ RunTime:0.032312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57737434 LIMIT 2 [ RunTime:0.029129s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57737434 ORDER BY `minOrder` ASC [ RunTime:0.017014s ]
select * from pdf where partno='2566CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.017776s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2566CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.012907s ]
SELECT `id` FROM `stock` WHERE `id` <> 57737434 AND `partno` = '2566CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.034939s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13347570 [ RunTime:0.040975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53836336 LIMIT 5 [ RunTime:0.063941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53836336 ORDER BY `minOrder` ASC [ RunTime:0.056982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53836336 ORDER BY `unit` DESC [ RunTime:0.014164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53836336 LIMIT 2 [ RunTime:0.026783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53836336 ORDER BY `minOrder` ASC [ RunTime:0.000660s ]
select * from pdf where partno='2566-F71G00DT' and brandshort='Oupiin' limit 1 [ RunTime:0.038837s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2566-F71G00DT' OR `brand` LIKE 'Oupiin%' ) ) LIMIT 1 [ RunTime:0.049343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53836332 LIMIT 5 [ RunTime:0.025802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53836332 ORDER BY `minOrder` ASC [ RunTime:0.026794s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53836332 ORDER BY `unit` DESC [ RunTime:0.022160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53836332 LIMIT 2 [ RunTime:0.040487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53836332 ORDER BY `minOrder` ASC [ RunTime:0.032398s ]
select * from pdf where partno='2566-F61G00DT' and brandshort='Oupiin' limit 1 [ RunTime:0.060288s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2566-F61G00DT' OR `brand` LIKE 'Oupiin%' ) ) LIMIT 1 [ RunTime:0.032813s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53836313 LIMIT 5 [ RunTime:0.041307s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53836313 ORDER BY `minOrder` ASC [ RunTime:0.035305s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53836313 ORDER BY `unit` DESC [ RunTime:0.071548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53836313 LIMIT 2 [ RunTime:0.034245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53836313 ORDER BY `minOrder` ASC [ RunTime:0.021179s ]
select * from pdf where partno='2566-F51G00DT' and brandshort='Oupiin' limit 1 [ RunTime:0.066802s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2566-F51G00DT' OR `brand` LIKE 'Oupiin%' ) ) LIMIT 1 [ RunTime:0.073582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53836288 LIMIT 5 [ RunTime:0.070230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53836288 ORDER BY `minOrder` ASC [ RunTime:0.048924s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53836288 ORDER BY `unit` DESC [ RunTime:0.010251s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53836288 LIMIT 2 [ RunTime:0.052938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53836288 ORDER BY `minOrder` ASC [ RunTime:0.006625s ]
select * from pdf where partno='2566-F35G00DT' and brandshort='Oupiin' limit 1 [ RunTime:0.026767s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2566-F35G00DT' OR `brand` LIKE 'Oupiin%' ) ) LIMIT 1 [ RunTime:0.063797s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53836281 LIMIT 5 [ RunTime:0.058625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53836281 ORDER BY `minOrder` ASC [ RunTime:0.067559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53836281 ORDER BY `unit` DESC [ RunTime:0.049206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53836281 LIMIT 2 [ RunTime:0.034695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53836281 ORDER BY `minOrder` ASC [ RunTime:0.027757s ]
select * from pdf where partno='2566-F33G00DT' and brandshort='Oupiin' limit 1 [ RunTime:0.019819s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2566-F33G00DT' OR `brand` LIKE 'Oupiin%' ) ) LIMIT 1 [ RunTime:0.025255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53836273 LIMIT 5 [ RunTime:0.042535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53836273 ORDER BY `minOrder` ASC [ RunTime:0.030018s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53836273 ORDER BY `unit` DESC [ RunTime:0.038085s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53836273 LIMIT 2 [ RunTime:0.031229s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53836273 ORDER BY `minOrder` ASC [ RunTime:0.011573s ]
select * from pdf where partno='2566-F31G00DT' and brandshort='Oupiin' limit 1 [ RunTime:0.034426s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2566-F31G00DT' OR `brand` LIKE 'Oupiin%' ) ) LIMIT 1 [ RunTime:0.039367s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53836289 LIMIT 5 [ RunTime:0.005401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53836289 ORDER BY `minOrder` ASC [ RunTime:0.033211s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53836289 ORDER BY `unit` DESC [ RunTime:0.032099s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53836289 LIMIT 2 [ RunTime:0.047922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53836289 ORDER BY `minOrder` ASC [ RunTime:0.031834s ]
select * from pdf where partno='2566-F39G00DT' and brandshort='Oupiin' limit 1 [ RunTime:0.030860s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2566-F39G00DT' OR `brand` LIKE 'Oupiin%' ) ) LIMIT 1 [ RunTime:0.019170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53836260 LIMIT 5 [ RunTime:0.018799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53836260 ORDER BY `minOrder` ASC [ RunTime:0.033174s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53836260 ORDER BY `unit` DESC [ RunTime:0.031901s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53836260 LIMIT 2 [ RunTime:0.039115s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53836260 ORDER BY `minOrder` ASC [ RunTime:0.016145s ]
select * from pdf where partno='2566-F23G00DT' and brandshort='Oupiin' limit 1 [ RunTime:0.039762s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2566-F23G00DT' OR `brand` LIKE 'Oupiin%' ) ) LIMIT 1 [ RunTime:0.027327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53836293 LIMIT 5 [ RunTime:0.026716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53836293 ORDER BY `minOrder` ASC [ RunTime:0.014664s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53836293 ORDER BY `unit` DESC [ RunTime:0.021709s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53836293 LIMIT 2 [ RunTime:0.025898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53836293 ORDER BY `minOrder` ASC [ RunTime:0.003097s ]
select * from pdf where partno='2566-F41G00DT' and brandshort='Oupiin' limit 1 [ RunTime:0.040029s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2566-F41G00DT' OR `brand` LIKE 'Oupiin%' ) ) LIMIT 1 [ RunTime:0.014924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53836334 LIMIT 5 [ RunTime:0.026443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53836334 ORDER BY `minOrder` ASC [ RunTime:0.028964s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53836334 ORDER BY `unit` DESC [ RunTime:0.037088s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53836334 LIMIT 2 [ RunTime:0.024722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53836334 ORDER BY `minOrder` ASC [ RunTime:0.013535s ]
select * from pdf where partno='2566-F67G00DT' and brandshort='Oupiin' limit 1 [ RunTime:0.034236s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2566-F67G00DT' OR `brand` LIKE 'Oupiin%' ) ) LIMIT 1 [ RunTime:0.030881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53836247 LIMIT 5 [ RunTime:0.027606s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53836247 ORDER BY `minOrder` ASC [ RunTime:0.058769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53836247 ORDER BY `unit` DESC [ RunTime:0.034084s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53836247 LIMIT 2 [ RunTime:0.018429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53836247 ORDER BY `minOrder` ASC [ RunTime:0.013374s ]
select * from pdf where partno='2566-F15G00DT' and brandshort='Oupiin' limit 1 [ RunTime:0.069669s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2566-F15G00DT' OR `brand` LIKE 'Oupiin%' ) ) LIMIT 1 [ RunTime:0.026792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53836257 LIMIT 5 [ RunTime:0.028058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53836257 ORDER BY `minOrder` ASC [ RunTime:0.027259s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53836257 ORDER BY `unit` DESC [ RunTime:0.021383s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53836257 LIMIT 2 [ RunTime:0.020564s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53836257 ORDER BY `minOrder` ASC [ RunTime:0.069659s ]
select * from pdf where partno='2566-F21G00DT' and brandshort='Oupiin' limit 1 [ RunTime:0.010186s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2566-F21G00DT' OR `brand` LIKE 'Oupiin%' ) ) LIMIT 1 [ RunTime:0.015875s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53836263 LIMIT 5 [ RunTime:0.034073s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53836263 ORDER BY `minOrder` ASC [ RunTime:0.031795s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53836263 ORDER BY `unit` DESC [ RunTime:0.052742s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53836263 LIMIT 2 [ RunTime:0.037781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53836263 ORDER BY `minOrder` ASC [ RunTime:0.019580s ]
select * from pdf where partno='2566-F25G00DT' and brandshort='Oupiin' limit 1 [ RunTime:0.017489s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2566-F25G00DT' OR `brand` LIKE 'Oupiin%' ) ) LIMIT 1 [ RunTime:0.022069s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53836243 LIMIT 5 [ RunTime:0.034091s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53836243 ORDER BY `minOrder` ASC [ RunTime:0.011557s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53836243 ORDER BY `unit` DESC [ RunTime:0.037014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53836243 LIMIT 2 [ RunTime:0.051120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53836243 ORDER BY `minOrder` ASC [ RunTime:0.014185s ]
select * from pdf where partno='2566-F13G00DT' and brandshort='Oupiin' limit 1 [ RunTime:0.048965s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2566-F13G00DT' OR `brand` LIKE 'Oupiin%' ) ) LIMIT 1 [ RunTime:0.017571s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57499674 LIMIT 5 [ RunTime:0.035028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57499674 ORDER BY `minOrder` ASC [ RunTime:0.023414s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57499674 ORDER BY `unit` DESC [ RunTime:0.015973s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57499674 LIMIT 2 [ RunTime:0.014248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57499674 ORDER BY `minOrder` ASC [ RunTime:0.010997s ]
select * from pdf where partno='2566' and brandshort='Pololu' limit 1 [ RunTime:0.031282s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2566' OR `brand` LIKE 'Pololu%' ) ) LIMIT 1 [ RunTime:0.027847s ]
SELECT `id` FROM `stock` WHERE `id` <> 57499674 AND `partno` = '2566' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pololu%' ) [ RunTime:0.029251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13866221 [ RunTime:0.022773s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56456953 LIMIT 5 [ RunTime:0.032811s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56456953 ORDER BY `minOrder` ASC [ RunTime:0.024906s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56456953 ORDER BY `unit` DESC [ RunTime:0.016334s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56456953 LIMIT 2 [ RunTime:0.015016s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56456953 ORDER BY `minOrder` ASC [ RunTime:0.018140s ]
select * from pdf where partno='25669' and brandshort='Phoenix America' limit 1 [ RunTime:0.037657s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25669' OR `brand` LIKE 'Phoenix America%' ) ) LIMIT 1 [ RunTime:0.028309s ]
SELECT `id` FROM `stock` WHERE `id` <> 56456953 AND `partno` = '25669' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%phoenix america%' ) [ RunTime:0.026436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56456952 LIMIT 5 [ RunTime:0.036351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56456952 ORDER BY `minOrder` ASC [ RunTime:0.011151s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56456952 ORDER BY `unit` DESC [ RunTime:0.009473s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56456952 LIMIT 2 [ RunTime:0.000388s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56456952 ORDER BY `minOrder` ASC [ RunTime:0.001496s ]
select * from pdf where partno='25660' and brandshort='Phoenix America' limit 1 [ RunTime:0.033377s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25660' OR `brand` LIKE 'Phoenix America%' ) ) LIMIT 1 [ RunTime:0.003285s ]
SELECT `id` FROM `stock` WHERE `id` <> 56456952 AND `partno` = '25660' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%phoenix america%' ) [ RunTime:0.009834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56456951 LIMIT 5 [ RunTime:0.014510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56456951 ORDER BY `minOrder` ASC [ RunTime:0.030980s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56456951 ORDER BY `unit` DESC [ RunTime:0.003558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56456951 LIMIT 2 [ RunTime:0.031469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56456951 ORDER BY `minOrder` ASC [ RunTime:0.007574s ]
select * from pdf where partno='25666' and brandshort='Phoenix America' limit 1 [ RunTime:0.038416s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25666' OR `brand` LIKE 'Phoenix America%' ) ) LIMIT 1 [ RunTime:0.017526s ]
SELECT `id` FROM `stock` WHERE `id` <> 56456951 AND `partno` = '25666' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%phoenix america%' ) [ RunTime:0.011681s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56456955 LIMIT 5 [ RunTime:0.046647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56456955 ORDER BY `minOrder` ASC [ RunTime:0.018403s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56456955 ORDER BY `unit` DESC [ RunTime:0.023680s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56456955 LIMIT 2 [ RunTime:0.105488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56456955 ORDER BY `minOrder` ASC [ RunTime:0.012973s ]
select * from pdf where partno='25667' and brandshort='Phoenix America' limit 1 [ RunTime:0.059565s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '25667' OR `brand` LIKE 'Phoenix America%' ) ) LIMIT 1 [ RunTime:0.031473s ]
SELECT `id` FROM `stock` WHERE `id` <> 56456955 AND `partno` = '25667' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%phoenix america%' ) [ RunTime:0.079882s ]
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 '2566%' OR `brand` LIKE '2566%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.062678s ]
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 '2566%' OR `brand` LIKE '2566%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043273s ]
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 '2566%' OR `brand` LIKE '2566%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050595s ]
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 '2566%' OR `brand` LIKE '2566%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050464s ]
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 '2566%' OR `brand` LIKE '2566%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.073759s ]
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 '2566%' OR `brand` LIKE '2566%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.061159s ]
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 '2566%' OR `brand` LIKE '2566%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024148s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '2566%' OR `brand` LIKE '2566%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.046767s ]