SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002909s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.37' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/category_676/1.html' [ RunTime:0.017849s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001409s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.022294s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001441s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.37' ) [ RunTime:0.022752s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001140s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.041850s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 676 [ RunTime:0.022022s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 676 LIMIT 1 [ RunTime:0.006647s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001689s ]
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` FORCE INDEX ( idx_categoryid ) LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`categoryid` = '676' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.050042s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.028381s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16367 LIMIT 5 [ RunTime:0.018759s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16367 ORDER BY `minOrder` ASC [ RunTime:0.046760s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.012505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16367 ORDER BY `unit` DESC [ RunTime:0.016036s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.015204s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16367 LIMIT 2 [ RunTime:0.028262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16367 ORDER BY `minOrder` ASC [ RunTime:0.016572s ]
select * from pdf where partno='36280' and brandshort='WIHA' limit 1 [ RunTime:0.018313s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001407s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '36280' OR `brand` LIKE 'WIHA%' ) ) LIMIT 1 [ RunTime:0.018982s ]
SELECT `id` FROM `stock` WHERE `id` <> 16367 AND `partno` = '36280' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.033129s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3086 [ RunTime:0.009582s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15347 [ RunTime:0.022438s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12166313 [ RunTime:0.018173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15347 LIMIT 5 [ RunTime:0.019525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15347 ORDER BY `minOrder` ASC [ RunTime:0.025277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15347 ORDER BY `unit` DESC [ RunTime:0.013976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15347 LIMIT 2 [ RunTime:0.019890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15347 ORDER BY `minOrder` ASC [ RunTime:0.008530s ]
select * from pdf where partno='36280' and brandshort='WIHA' limit 1 [ RunTime:0.002492s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '36280' OR `brand` LIKE 'WIHA%' ) ) LIMIT 1 [ RunTime:0.003126s ]
SELECT `id` FROM `stock` WHERE `id` <> 15347 AND `partno` = '36280' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.015333s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3086 [ RunTime:0.017565s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16367 [ RunTime:0.010722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12166313 [ RunTime:0.002110s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15219 LIMIT 5 [ RunTime:0.003682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15219 ORDER BY `minOrder` ASC [ RunTime:0.005652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15219 ORDER BY `unit` DESC [ RunTime:0.004670s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15219 LIMIT 2 [ RunTime:0.012350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15219 ORDER BY `minOrder` ASC [ RunTime:0.009743s ]
select * from pdf where partno='26101' and brandshort='WIHA' limit 1 [ RunTime:0.018604s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '26101' OR `brand` LIKE 'WIHA%' ) ) LIMIT 1 [ RunTime:0.019143s ]
SELECT `id` FROM `stock` WHERE `id` <> 15219 AND `partno` = '26101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.004752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3049 [ RunTime:0.001339s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15114 [ RunTime:0.007785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12167250 [ RunTime:0.008617s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15114 LIMIT 5 [ RunTime:0.008543s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15114 ORDER BY `minOrder` ASC [ RunTime:0.014283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15114 ORDER BY `unit` DESC [ RunTime:0.000762s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15114 LIMIT 2 [ RunTime:0.001760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15114 ORDER BY `minOrder` ASC [ RunTime:0.006196s ]
select * from pdf where partno='26101' and brandshort='WIHA' limit 1 [ RunTime:0.002133s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '26101' OR `brand` LIKE 'WIHA%' ) ) LIMIT 1 [ RunTime:0.003016s ]
SELECT `id` FROM `stock` WHERE `id` <> 15114 AND `partno` = '26101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.005336s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3049 [ RunTime:0.001620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15219 [ RunTime:0.000494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12167250 [ RunTime:0.003142s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8539 LIMIT 5 [ RunTime:0.014074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8539 ORDER BY `minOrder` ASC [ RunTime:0.012413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8539 ORDER BY `unit` DESC [ RunTime:0.008829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8539 LIMIT 2 [ RunTime:0.025704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8539 ORDER BY `minOrder` ASC [ RunTime:0.003111s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MAV0120/3D' OR `brand` LIKE 'BULGIN LIMITED%' ) ) LIMIT 1 [ RunTime:0.011488s ]
SELECT `id` FROM `stock` WHERE `id` <> 8539 AND `partno` = 'MAV0120/3D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%bulgin limited%' ) [ RunTime:0.015252s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5866 LIMIT 5 [ RunTime:0.005828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5866 ORDER BY `minOrder` ASC [ RunTime:0.001585s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 5866 ORDER BY `unit` DESC [ RunTime:0.001581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 5866 LIMIT 2 [ RunTime:0.003363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 5866 ORDER BY `minOrder` ASC [ RunTime:0.003649s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RMD05024' OR `brand` LIKE 'SCHRACK - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.002793s ]
SELECT `id` FROM `stock` WHERE `id` <> 5866 AND `partno` = 'RMD05024' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schrack - te connectivity%' ) [ RunTime:0.004704s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3669 LIMIT 5 [ RunTime:0.001187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3669 ORDER BY `minOrder` ASC [ RunTime:0.010251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3669 ORDER BY `unit` DESC [ RunTime:0.014867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3669 LIMIT 2 [ RunTime:0.004487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3669 ORDER BY `minOrder` ASC [ RunTime:0.002377s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '26705.' OR `brand` LIKE 'WIHA%' ) ) LIMIT 1 [ RunTime:0.009569s ]
SELECT `id` FROM `stock` WHERE `id` <> 3669 AND `partno` = '26705.' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.017375s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13392 LIMIT 5 [ RunTime:0.006309s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13392 ORDER BY `minOrder` ASC [ RunTime:0.006877s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13392 ORDER BY `unit` DESC [ RunTime:0.022409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13392 LIMIT 2 [ RunTime:0.001768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13392 ORDER BY `minOrder` ASC [ RunTime:0.005601s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XN100' OR `brand` LIKE 'WELLER XCELITE%' ) ) LIMIT 1 [ RunTime:0.004809s ]
SELECT `id` FROM `stock` WHERE `id` <> 13392 AND `partno` = 'XN100' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weller xcelite%' ) [ RunTime:0.013179s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3006 LIMIT 5 [ RunTime:0.000967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3006 ORDER BY `minOrder` ASC [ RunTime:0.003716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3006 ORDER BY `unit` DESC [ RunTime:0.015896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3006 LIMIT 2 [ RunTime:0.007964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3006 ORDER BY `minOrder` ASC [ RunTime:0.005966s ]
select * from pdf where partno='26008' and brandshort='WIHA' limit 1 [ RunTime:0.026326s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '26008' OR `brand` LIKE 'WIHA%' ) ) LIMIT 1 [ RunTime:0.020460s ]
SELECT `id` FROM `stock` WHERE `id` <> 3006 AND `partno` = '26008' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.001852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11183525 [ RunTime:0.007461s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13393 LIMIT 5 [ RunTime:0.003133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13393 ORDER BY `minOrder` ASC [ RunTime:0.000708s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13393 ORDER BY `unit` DESC [ RunTime:0.008329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13393 LIMIT 2 [ RunTime:0.013302s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13393 ORDER BY `minOrder` ASC [ RunTime:0.003802s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'XNB103' OR `brand` LIKE 'WELLER XCELITE%' ) ) LIMIT 1 [ RunTime:0.007236s ]
SELECT `id` FROM `stock` WHERE `id` <> 13393 AND `partno` = 'XNB103' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weller xcelite%' ) [ RunTime:0.004275s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3078 LIMIT 5 [ RunTime:0.009477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3078 ORDER BY `minOrder` ASC [ RunTime:0.014907s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3078 ORDER BY `unit` DESC [ RunTime:0.009115s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3078 LIMIT 2 [ RunTime:0.002820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3078 ORDER BY `minOrder` ASC [ RunTime:0.007860s ]
select * from pdf where partno='36270' and brandshort='WIHA' limit 1 [ RunTime:0.008422s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '36270' OR `brand` LIKE 'WIHA%' ) ) LIMIT 1 [ RunTime:0.002296s ]
SELECT `id` FROM `stock` WHERE `id` <> 3078 AND `partno` = '36270' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.001566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11183173 [ RunTime:0.003783s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3056 LIMIT 5 [ RunTime:0.004846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3056 ORDER BY `minOrder` ASC [ RunTime:0.007047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3056 ORDER BY `unit` DESC [ RunTime:0.009685s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3056 LIMIT 2 [ RunTime:0.001787s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3056 ORDER BY `minOrder` ASC [ RunTime:0.000442s ]
select * from pdf where partno='31140' and brandshort='WIHA' limit 1 [ RunTime:0.003818s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '31140' OR `brand` LIKE 'WIHA%' ) ) LIMIT 1 [ RunTime:0.014167s ]
SELECT `id` FROM `stock` WHERE `id` <> 3056 AND `partno` = '31140' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.001105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11183522 [ RunTime:0.000890s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3086 LIMIT 5 [ RunTime:0.005924s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3086 ORDER BY `minOrder` ASC [ RunTime:0.004140s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3086 ORDER BY `unit` DESC [ RunTime:0.009610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3086 LIMIT 2 [ RunTime:0.000664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3086 ORDER BY `minOrder` ASC [ RunTime:0.003370s ]
select * from pdf where partno='36280' and brandshort='WIHA' limit 1 [ RunTime:0.000579s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '36280' OR `brand` LIKE 'WIHA%' ) ) LIMIT 1 [ RunTime:0.000494s ]
SELECT `id` FROM `stock` WHERE `id` <> 3086 AND `partno` = '36280' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.000864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15347 [ RunTime:0.000782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16367 [ RunTime:0.000377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12166313 [ RunTime:0.000377s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3007 LIMIT 5 [ RunTime:0.000590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3007 ORDER BY `minOrder` ASC [ RunTime:0.000643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3007 ORDER BY `unit` DESC [ RunTime:0.005117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3007 LIMIT 2 [ RunTime:0.000599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3007 ORDER BY `minOrder` ASC [ RunTime:0.000651s ]
select * from pdf where partno='31118' and brandshort='WIHA' limit 1 [ RunTime:0.004377s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '31118' OR `brand` LIKE 'WIHA%' ) ) LIMIT 1 [ RunTime:0.009626s ]
SELECT `id` FROM `stock` WHERE `id` <> 3007 AND `partno` = '31118' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.010270s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10732 LIMIT 5 [ RunTime:0.003164s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10732 ORDER BY `minOrder` ASC [ RunTime:0.004601s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10732 ORDER BY `unit` DESC [ RunTime:0.003202s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10732 LIMIT 2 [ RunTime:0.001322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10732 ORDER BY `minOrder` ASC [ RunTime:0.004606s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '138070' OR `brand` LIKE 'WERA%' ) ) LIMIT 1 [ RunTime:0.003471s ]
SELECT `id` FROM `stock` WHERE `id` <> 10732 AND `partno` = '138070' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wera%' ) [ RunTime:0.002768s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3076 LIMIT 5 [ RunTime:0.000622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3076 ORDER BY `minOrder` ASC [ RunTime:0.010634s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3076 ORDER BY `unit` DESC [ RunTime:0.003637s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3076 LIMIT 2 [ RunTime:0.004228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3076 ORDER BY `minOrder` ASC [ RunTime:0.004579s ]
select * from pdf where partno='36266' and brandshort='WIHA' limit 1 [ RunTime:0.013522s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '36266' OR `brand` LIKE 'WIHA%' ) ) LIMIT 1 [ RunTime:0.004005s ]
SELECT `id` FROM `stock` WHERE `id` <> 3076 AND `partno` = '36266' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.006991s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12165777 [ RunTime:0.001092s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3049 LIMIT 5 [ RunTime:0.000620s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3049 ORDER BY `minOrder` ASC [ RunTime:0.006826s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3049 ORDER BY `unit` DESC [ RunTime:0.004656s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3049 LIMIT 2 [ RunTime:0.005162s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3049 ORDER BY `minOrder` ASC [ RunTime:0.000387s ]
select * from pdf where partno='26101' and brandshort='WIHA' limit 1 [ RunTime:0.005160s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '26101' OR `brand` LIKE 'WIHA%' ) ) LIMIT 1 [ RunTime:0.000397s ]
SELECT `id` FROM `stock` WHERE `id` <> 3049 AND `partno` = '26101' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.003603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15114 [ RunTime:0.000384s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15219 [ RunTime:0.000329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12167250 [ RunTime:0.000341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10790 LIMIT 5 [ RunTime:0.002677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10790 ORDER BY `minOrder` ASC [ RunTime:0.000560s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 10790 ORDER BY `unit` DESC [ RunTime:0.000506s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 10790 LIMIT 2 [ RunTime:0.000691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 10790 ORDER BY `minOrder` ASC [ RunTime:0.001686s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C-730' OR `brand` LIKE 'DURATOOL%' ) ) LIMIT 1 [ RunTime:0.005974s ]
SELECT `id` FROM `stock` WHERE `id` <> 10790 AND `partno` = 'C-730' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%duratool%' ) [ RunTime:0.001386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3080 LIMIT 5 [ RunTime:0.000507s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3080 ORDER BY `minOrder` ASC [ RunTime:0.004876s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 3080 ORDER BY `unit` DESC [ RunTime:0.001875s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 3080 LIMIT 2 [ RunTime:0.000541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 3080 ORDER BY `minOrder` ASC [ RunTime:0.000374s ]
select * from pdf where partno='31115' and brandshort='WIHA' limit 1 [ RunTime:0.003736s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '31115' OR `brand` LIKE 'WIHA%' ) ) LIMIT 1 [ RunTime:0.003180s ]
SELECT `id` FROM `stock` WHERE `id` <> 3080 AND `partno` = '31115' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wiha%' ) [ RunTime:0.007852s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12166325 [ RunTime:0.001000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11304 LIMIT 5 [ RunTime:0.000698s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11304 ORDER BY `minOrder` ASC [ RunTime:0.003627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11304 ORDER BY `unit` DESC [ RunTime:0.003118s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11304 LIMIT 2 [ RunTime:0.012446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11304 ORDER BY `minOrder` ASC [ RunTime:0.002473s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '002990' OR `brand` LIKE 'WERA%' ) ) LIMIT 1 [ RunTime:0.001277s ]
SELECT `id` FROM `stock` WHERE `id` <> 11304 AND `partno` = '002990' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wera%' ) [ RunTime:0.001291s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` FORCE INDEX ( idx_categoryid ) LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`categoryid` = '676' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003985s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`categoryid` = '676' ) LIMIT 23 ) tmp GROUP BY `brand` [ RunTime:0.000965s ]