SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002219s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=B8000&search=1' [ RunTime:0.020828s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003871s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002124s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001366s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.005783s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001535s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000685s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001040s ]
SELECT * FROM `stock_search` WHERE `partno` = 'B8000' LIMIT 1 [ RunTime:0.023182s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-25 17:16:23' WHERE `partno` = 'B8000' [ RunTime:0.004920s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001682s ]
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 'B8000%' OR `brand` LIKE 'B8000%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.033158s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001405s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12185469 LIMIT 5 [ RunTime:0.007548s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12185469 ORDER BY `minOrder` ASC [ RunTime:0.022914s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.031303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12185469 ORDER BY `unit` DESC [ RunTime:0.017728s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12185469 LIMIT 2 [ RunTime:0.020517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12185469 ORDER BY `minOrder` ASC [ RunTime:0.015253s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12185158 LIMIT 5 [ RunTime:0.014615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12185158 ORDER BY `minOrder` ASC [ RunTime:0.048503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12185158 ORDER BY `unit` DESC [ RunTime:0.007700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12185158 LIMIT 2 [ RunTime:0.075373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12185158 ORDER BY `minOrder` ASC [ RunTime:0.047319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12183507 LIMIT 5 [ RunTime:0.010276s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12183507 ORDER BY `minOrder` ASC [ RunTime:0.029752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12183507 ORDER BY `unit` DESC [ RunTime:0.034445s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12183507 LIMIT 2 [ RunTime:0.036139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12183507 ORDER BY `minOrder` ASC [ RunTime:0.011594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182933 LIMIT 5 [ RunTime:0.014722s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182933 ORDER BY `minOrder` ASC [ RunTime:0.059897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182933 ORDER BY `unit` DESC [ RunTime:0.038572s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182933 LIMIT 2 [ RunTime:0.010654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182933 ORDER BY `minOrder` ASC [ RunTime:0.007756s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182762 LIMIT 5 [ RunTime:0.040602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182762 ORDER BY `minOrder` ASC [ RunTime:0.083603s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182762 ORDER BY `unit` DESC [ RunTime:0.038579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182762 LIMIT 2 [ RunTime:0.050520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182762 ORDER BY `minOrder` ASC [ RunTime:0.022890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182666 LIMIT 5 [ RunTime:0.018450s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182666 ORDER BY `minOrder` ASC [ RunTime:0.012723s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182666 ORDER BY `unit` DESC [ RunTime:0.012224s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182666 LIMIT 2 [ RunTime:0.023547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182666 ORDER BY `minOrder` ASC [ RunTime:0.019135s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182568 LIMIT 5 [ RunTime:0.015305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182568 ORDER BY `minOrder` ASC [ RunTime:0.007869s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182568 ORDER BY `unit` DESC [ RunTime:0.016281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182568 LIMIT 2 [ RunTime:0.025208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182568 ORDER BY `minOrder` ASC [ RunTime:0.010085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182547 LIMIT 5 [ RunTime:0.013153s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182547 ORDER BY `minOrder` ASC [ RunTime:0.014739s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12182547 ORDER BY `unit` DESC [ RunTime:0.011548s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12182547 LIMIT 2 [ RunTime:0.002910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12182547 ORDER BY `minOrder` ASC [ RunTime:0.002586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11194972 LIMIT 5 [ RunTime:0.004604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11194972 ORDER BY `minOrder` ASC [ RunTime:0.008087s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11194972 ORDER BY `unit` DESC [ RunTime:0.011048s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11194972 LIMIT 2 [ RunTime:0.002200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11194972 ORDER BY `minOrder` ASC [ RunTime:0.001430s ]
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 'B8000%' OR `brand` LIKE 'B8000%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002021s ]
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 'B8000%' OR `brand` LIKE 'B8000%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63490574 LIMIT 5 [ RunTime:0.000652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63490574 ORDER BY `minOrder` ASC [ RunTime:0.003116s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63490574 ORDER BY `unit` DESC [ RunTime:0.002104s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63490574 LIMIT 2 [ RunTime:0.001651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63490574 ORDER BY `minOrder` ASC [ RunTime:0.002317s ]
select * from pdf where partno='B8000' and brandshort='Botron Company Inc.' limit 1 [ RunTime:0.001647s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001825s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B8000' OR `brand` LIKE 'Botron Company Inc.%' ) ) LIMIT 1 [ RunTime:0.003446s ]
SELECT `id` FROM `stock` WHERE `id` <> 63490574 AND `partno` = 'B8000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%botron company inc.%' ) [ RunTime:0.007099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58552963 LIMIT 5 [ RunTime:0.006716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58552963 ORDER BY `minOrder` ASC [ RunTime:0.009847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58552963 ORDER BY `unit` DESC [ RunTime:0.006215s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58552963 LIMIT 2 [ RunTime:0.009566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58552963 ORDER BY `minOrder` ASC [ RunTime:0.005051s ]
select * from pdf where partno='B80001B25' and brandshort='Dremel' limit 1 [ RunTime:0.003705s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B80001B25' OR `brand` LIKE 'Dremel%' ) ) LIMIT 1 [ RunTime:0.001119s ]
SELECT `id` FROM `stock` WHERE `id` <> 58552963 AND `partno` = 'B80001B25' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dremel%' ) [ RunTime:0.002917s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12185469 [ RunTime:0.002360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58552311 LIMIT 5 [ RunTime:0.020072s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58552311 ORDER BY `minOrder` ASC [ RunTime:0.013382s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58552311 ORDER BY `unit` DESC [ RunTime:0.015064s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58552311 LIMIT 2 [ RunTime:0.017463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58552311 ORDER BY `minOrder` ASC [ RunTime:0.008073s ]
select * from pdf where partno='B80002B25' and brandshort='Dremel' limit 1 [ RunTime:0.000935s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B80002B25' OR `brand` LIKE 'Dremel%' ) ) LIMIT 1 [ RunTime:0.001061s ]
SELECT `id` FROM `stock` WHERE `id` <> 58552311 AND `partno` = 'B80002B25' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dremel%' ) [ RunTime:0.002305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12185158 [ RunTime:0.001342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58552102 LIMIT 5 [ RunTime:0.003898s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58552102 ORDER BY `minOrder` ASC [ RunTime:0.001852s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58552102 ORDER BY `unit` DESC [ RunTime:0.007109s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58552102 LIMIT 2 [ RunTime:0.000792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58552102 ORDER BY `minOrder` ASC [ RunTime:0.000441s ]
select * from pdf where partno='B80009B25' and brandshort='Dremel' limit 1 [ RunTime:0.000772s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B80009B25' OR `brand` LIKE 'Dremel%' ) ) LIMIT 1 [ RunTime:0.000666s ]
SELECT `id` FROM `stock` WHERE `id` <> 58552102 AND `partno` = 'B80009B25' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dremel%' ) [ RunTime:0.004438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58549050 LIMIT 5 [ RunTime:0.000497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58549050 ORDER BY `minOrder` ASC [ RunTime:0.002659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58549050 ORDER BY `unit` DESC [ RunTime:0.000444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58549050 LIMIT 2 [ RunTime:0.000469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58549050 ORDER BY `minOrder` ASC [ RunTime:0.007641s ]
select * from pdf where partno='B80006' and brandshort='Dremel' limit 1 [ RunTime:0.003697s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B80006' OR `brand` LIKE 'Dremel%' ) ) LIMIT 1 [ RunTime:0.003385s ]
SELECT `id` FROM `stock` WHERE `id` <> 58549050 AND `partno` = 'B80006' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dremel%' ) [ RunTime:0.005092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12183507 [ RunTime:0.000317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58548314 LIMIT 5 [ RunTime:0.009448s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58548314 ORDER BY `minOrder` ASC [ RunTime:0.003618s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58548314 ORDER BY `unit` DESC [ RunTime:0.004293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58548314 LIMIT 2 [ RunTime:0.003167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58548314 ORDER BY `minOrder` ASC [ RunTime:0.000243s ]
select * from pdf where partno='B80008' and brandshort='Dremel' limit 1 [ RunTime:0.000499s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B80008' OR `brand` LIKE 'Dremel%' ) ) LIMIT 1 [ RunTime:0.001856s ]
SELECT `id` FROM `stock` WHERE `id` <> 58548314 AND `partno` = 'B80008' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dremel%' ) [ RunTime:0.001063s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58548040 LIMIT 5 [ RunTime:0.002725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58548040 ORDER BY `minOrder` ASC [ RunTime:0.004303s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58548040 ORDER BY `unit` DESC [ RunTime:0.002830s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58548040 LIMIT 2 [ RunTime:0.001924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58548040 ORDER BY `minOrder` ASC [ RunTime:0.000211s ]
select * from pdf where partno='B80004' and brandshort='Dremel' limit 1 [ RunTime:0.000935s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B80004' OR `brand` LIKE 'Dremel%' ) ) LIMIT 1 [ RunTime:0.000371s ]
SELECT `id` FROM `stock` WHERE `id` <> 58548040 AND `partno` = 'B80004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dremel%' ) [ RunTime:0.000401s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182933 [ RunTime:0.003250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58547856 LIMIT 5 [ RunTime:0.000308s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58547856 ORDER BY `minOrder` ASC [ RunTime:0.008896s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58547856 ORDER BY `unit` DESC [ RunTime:0.002331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58547856 LIMIT 2 [ RunTime:0.009244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58547856 ORDER BY `minOrder` ASC [ RunTime:0.015531s ]
select * from pdf where partno='B80007' and brandshort='Dremel' limit 1 [ RunTime:0.014172s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B80007' OR `brand` LIKE 'Dremel%' ) ) LIMIT 1 [ RunTime:0.008725s ]
SELECT `id` FROM `stock` WHERE `id` <> 58547856 AND `partno` = 'B80007' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dremel%' ) [ RunTime:0.005173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11194972 [ RunTime:0.002071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58547758 LIMIT 5 [ RunTime:0.001473s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58547758 ORDER BY `minOrder` ASC [ RunTime:0.002875s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58547758 ORDER BY `unit` DESC [ RunTime:0.004547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58547758 LIMIT 2 [ RunTime:0.008195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58547758 ORDER BY `minOrder` ASC [ RunTime:0.006263s ]
select * from pdf where partno='B80003' and brandshort='Dremel' limit 1 [ RunTime:0.015618s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B80003' OR `brand` LIKE 'Dremel%' ) ) LIMIT 1 [ RunTime:0.009881s ]
SELECT `id` FROM `stock` WHERE `id` <> 58547758 AND `partno` = 'B80003' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dremel%' ) [ RunTime:0.025028s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182762 [ RunTime:0.002026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58547698 LIMIT 5 [ RunTime:0.000599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58547698 ORDER BY `minOrder` ASC [ RunTime:0.010838s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58547698 ORDER BY `unit` DESC [ RunTime:0.005860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58547698 LIMIT 2 [ RunTime:0.014501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58547698 ORDER BY `minOrder` ASC [ RunTime:0.005896s ]
select * from pdf where partno='B80001' and brandshort='Dremel' limit 1 [ RunTime:0.012131s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B80001' OR `brand` LIKE 'Dremel%' ) ) LIMIT 1 [ RunTime:0.000912s ]
SELECT `id` FROM `stock` WHERE `id` <> 58547698 AND `partno` = 'B80001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dremel%' ) [ RunTime:0.000801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182666 [ RunTime:0.000584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58547478 LIMIT 5 [ RunTime:0.009272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58547478 ORDER BY `minOrder` ASC [ RunTime:0.001749s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58547478 ORDER BY `unit` DESC [ RunTime:0.000743s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58547478 LIMIT 2 [ RunTime:0.008244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58547478 ORDER BY `minOrder` ASC [ RunTime:0.001851s ]
select * from pdf where partno='B80002' and brandshort='Dremel' limit 1 [ RunTime:0.002772s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B80002' OR `brand` LIKE 'Dremel%' ) ) LIMIT 1 [ RunTime:0.012115s ]
SELECT `id` FROM `stock` WHERE `id` <> 58547478 AND `partno` = 'B80002' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dremel%' ) [ RunTime:0.027002s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182568 [ RunTime:0.011251s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58547458 LIMIT 5 [ RunTime:0.009653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58547458 ORDER BY `minOrder` ASC [ RunTime:0.011031s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58547458 ORDER BY `unit` DESC [ RunTime:0.005005s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58547458 LIMIT 2 [ RunTime:0.008142s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58547458 ORDER BY `minOrder` ASC [ RunTime:0.005312s ]
select * from pdf where partno='B80009' and brandshort='Dremel' limit 1 [ RunTime:0.016555s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'B80009' OR `brand` LIKE 'Dremel%' ) ) LIMIT 1 [ RunTime:0.022682s ]
SELECT `id` FROM `stock` WHERE `id` <> 58547458 AND `partno` = 'B80009' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dremel%' ) [ RunTime:0.046266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12182547 [ RunTime:0.014374s ]
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 'B8000%' OR `brand` LIKE 'B8000%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002198s ]
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 'B8000%' OR `brand` LIKE 'B8000%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012484s ]
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 'B8000%' OR `brand` LIKE 'B8000%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028864s ]
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 'B8000%' OR `brand` LIKE 'B8000%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014025s ]
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 'B8000%' OR `brand` LIKE 'B8000%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005060s ]
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 'B8000%' OR `brand` LIKE 'B8000%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024346s ]
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 'B8000%' OR `brand` LIKE 'B8000%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013303s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'B8000%' OR `brand` LIKE 'B8000%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.075263s ]