SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001307s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.254' , `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=10527&search=1' [ RunTime:0.005082s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001633s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002463s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002104s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.254' ) [ RunTime:0.007304s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001049s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.007892s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001494s ]
SELECT * FROM `stock_search` WHERE `partno` = '10527' LIMIT 1 [ RunTime:0.005367s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-04 09:23:00' WHERE `partno` = '10527' [ RunTime:0.005522s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001265s ]
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 '10527%' OR `brand` LIKE '10527%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026121s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002165s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18705046 LIMIT 5 [ RunTime:0.023143s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001717s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18705046 ORDER BY `minOrder` ASC [ RunTime:0.019232s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004901s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18705046 ORDER BY `unit` DESC [ RunTime:0.036743s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002267s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18705046 LIMIT 2 [ RunTime:0.026895s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18705046 ORDER BY `minOrder` ASC [ RunTime:0.025615s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17391522 LIMIT 5 [ RunTime:0.021880s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17391522 ORDER BY `minOrder` ASC [ RunTime:0.013940s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17391522 ORDER BY `unit` DESC [ RunTime:0.051716s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17391522 LIMIT 2 [ RunTime:0.047490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17391522 ORDER BY `minOrder` ASC [ RunTime:0.016239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15225549 LIMIT 5 [ RunTime:0.013931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15225549 ORDER BY `minOrder` ASC [ RunTime:0.061066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15225549 ORDER BY `unit` DESC [ RunTime:0.021814s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15225549 LIMIT 2 [ RunTime:0.018244s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15225549 ORDER BY `minOrder` ASC [ RunTime:0.023226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15225547 LIMIT 5 [ RunTime:0.014193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15225547 ORDER BY `minOrder` ASC [ RunTime:0.006235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15225547 ORDER BY `unit` DESC [ RunTime:0.027824s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15225547 LIMIT 2 [ RunTime:0.016815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15225547 ORDER BY `minOrder` ASC [ RunTime:0.005189s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13297449 LIMIT 5 [ RunTime:0.021216s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13297449 ORDER BY `minOrder` ASC [ RunTime:0.015556s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13297449 ORDER BY `unit` DESC [ RunTime:0.009312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13297449 LIMIT 2 [ RunTime:0.002783s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13297449 ORDER BY `minOrder` ASC [ RunTime:0.003096s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13187133 LIMIT 5 [ RunTime:0.013573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187133 ORDER BY `minOrder` ASC [ RunTime:0.016830s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13187133 ORDER BY `unit` DESC [ RunTime:0.014941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13187133 LIMIT 2 [ RunTime:0.008435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13187133 ORDER BY `minOrder` ASC [ RunTime:0.006751s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12550680 LIMIT 5 [ RunTime:0.005240s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12550680 ORDER BY `minOrder` ASC [ RunTime:0.009995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12550680 ORDER BY `unit` DESC [ RunTime:0.011514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12550680 LIMIT 2 [ RunTime:0.005084s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12550680 ORDER BY `minOrder` ASC [ RunTime:0.004184s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12028287 LIMIT 5 [ RunTime:0.008204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12028287 ORDER BY `minOrder` ASC [ RunTime:0.017235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12028287 ORDER BY `unit` DESC [ RunTime:0.012593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12028287 LIMIT 2 [ RunTime:0.003990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12028287 ORDER BY `minOrder` ASC [ RunTime:0.017013s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11680664 LIMIT 5 [ RunTime:0.002404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11680664 ORDER BY `minOrder` ASC [ RunTime:0.010535s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11680664 ORDER BY `unit` DESC [ RunTime:0.011623s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11680664 LIMIT 2 [ RunTime:0.005773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11680664 ORDER BY `minOrder` ASC [ RunTime:0.000490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11206981 LIMIT 5 [ RunTime:0.012602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11206981 ORDER BY `minOrder` ASC [ RunTime:0.013397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11206981 ORDER BY `unit` DESC [ RunTime:0.001353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11206981 LIMIT 2 [ RunTime:0.015255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11206981 ORDER BY `minOrder` ASC [ RunTime:0.022377s ]
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 '10527%' OR `brand` LIKE '10527%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.014979s ]
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 '10527%' OR `brand` LIKE '10527%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026595s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58556897 LIMIT 5 [ RunTime:0.014864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58556897 ORDER BY `minOrder` ASC [ RunTime:0.048530s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58556897 ORDER BY `unit` DESC [ RunTime:0.016501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58556897 LIMIT 2 [ RunTime:0.013124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58556897 ORDER BY `minOrder` ASC [ RunTime:0.011649s ]
select * from pdf where partno='10527B' and brandshort='Aven Tools' limit 1 [ RunTime:0.012166s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002823s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10527B' OR `brand` LIKE 'Aven Tools%' ) ) LIMIT 1 [ RunTime:0.009151s ]
SELECT `id` FROM `stock` WHERE `id` <> 58556897 AND `partno` = '10527B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%aven tools%' ) [ RunTime:0.036350s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18705046 [ RunTime:0.014354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63381430 LIMIT 5 [ RunTime:0.003487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63381430 ORDER BY `minOrder` ASC [ RunTime:0.022857s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63381430 ORDER BY `unit` DESC [ RunTime:0.038074s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63381430 LIMIT 2 [ RunTime:0.013567s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63381430 ORDER BY `minOrder` ASC [ RunTime:0.005461s ]
select * from pdf where partno='10527F' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.020110s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10527F' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.030607s ]
SELECT `id` FROM `stock` WHERE `id` <> 63381430 AND `partno` = '10527F' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.022403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63380563 LIMIT 5 [ RunTime:0.016842s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380563 ORDER BY `minOrder` ASC [ RunTime:0.051773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63380563 ORDER BY `unit` DESC [ RunTime:0.032350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63380563 LIMIT 2 [ RunTime:0.027710s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63380563 ORDER BY `minOrder` ASC [ RunTime:0.003926s ]
select * from pdf where partno='10527' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.006016s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10527' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.028439s ]
SELECT `id` FROM `stock` WHERE `id` <> 63380563 AND `partno` = '10527' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.056968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63350221 LIMIT 5 [ RunTime:0.029531s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63350221 ORDER BY `minOrder` ASC [ RunTime:0.029932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63350221 ORDER BY `unit` DESC [ RunTime:0.035699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63350221 LIMIT 2 [ RunTime:0.006490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63350221 ORDER BY `minOrder` ASC [ RunTime:0.013067s ]
select * from pdf where partno='1052701' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.046503s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052701' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.030524s ]
SELECT `id` FROM `stock` WHERE `id` <> 63350221 AND `partno` = '1052701' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.027175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15225549 [ RunTime:0.015990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63350189 LIMIT 5 [ RunTime:0.014643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63350189 ORDER BY `minOrder` ASC [ RunTime:0.012419s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63350189 ORDER BY `unit` DESC [ RunTime:0.039419s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63350189 LIMIT 2 [ RunTime:0.022876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63350189 ORDER BY `minOrder` ASC [ RunTime:0.010614s ]
select * from pdf where partno='1052700' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.035719s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052700' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.047623s ]
SELECT `id` FROM `stock` WHERE `id` <> 63350189 AND `partno` = '1052700' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.064440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15225547 [ RunTime:0.035035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60625563 LIMIT 5 [ RunTime:0.047652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625563 ORDER BY `minOrder` ASC [ RunTime:0.095075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60625563 ORDER BY `unit` DESC [ RunTime:0.050275s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60625563 LIMIT 2 [ RunTime:0.182282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625563 ORDER BY `minOrder` ASC [ RunTime:0.006386s ]
select * from pdf where partno='1052798:0001' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.057376s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052798:0001' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.072569s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60625413 LIMIT 5 [ RunTime:0.026525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625413 ORDER BY `minOrder` ASC [ RunTime:0.105882s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60625413 ORDER BY `unit` DESC [ RunTime:0.048733s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60625413 LIMIT 2 [ RunTime:0.027539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625413 ORDER BY `minOrder` ASC [ RunTime:0.024470s ]
select * from pdf where partno='1052798:0081' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.063197s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052798:0081' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.035319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60625412 LIMIT 5 [ RunTime:0.018695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625412 ORDER BY `minOrder` ASC [ RunTime:0.032969s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60625412 ORDER BY `unit` DESC [ RunTime:0.030925s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60625412 LIMIT 2 [ RunTime:0.040544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625412 ORDER BY `minOrder` ASC [ RunTime:0.017360s ]
select * from pdf where partno='1052798:0061' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.032714s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052798:0061' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.041062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60625411 LIMIT 5 [ RunTime:0.078263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625411 ORDER BY `minOrder` ASC [ RunTime:0.137350s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60625411 ORDER BY `unit` DESC [ RunTime:0.067348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60625411 LIMIT 2 [ RunTime:0.106491s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625411 ORDER BY `minOrder` ASC [ RunTime:0.066810s ]
select * from pdf where partno='1052798:0041' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.051234s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052798:0041' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.053807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60625410 LIMIT 5 [ RunTime:0.050966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625410 ORDER BY `minOrder` ASC [ RunTime:0.051104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60625410 ORDER BY `unit` DESC [ RunTime:0.051108s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60625410 LIMIT 2 [ RunTime:0.050992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60625410 ORDER BY `minOrder` ASC [ RunTime:0.051022s ]
select * from pdf where partno='1052798:0021' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.051571s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052798:0021' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.053858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60587464 LIMIT 5 [ RunTime:0.051226s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60587464 ORDER BY `minOrder` ASC [ RunTime:0.051626s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60587464 ORDER BY `unit` DESC [ RunTime:0.109144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60587464 LIMIT 2 [ RunTime:0.075913s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60587464 ORDER BY `minOrder` ASC [ RunTime:0.017145s ]
select * from pdf where partno='10527.1' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.146504s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '10527.1' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.074391s ]
SELECT `id` FROM `stock` WHERE `id` <> 60587464 AND `partno` = '10527.1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.049429s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12550680 [ RunTime:0.083775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32722220 LIMIT 5 [ RunTime:0.070977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32722220 ORDER BY `minOrder` ASC [ RunTime:0.048148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32722220 ORDER BY `unit` DESC [ RunTime:0.038732s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32722220 LIMIT 2 [ RunTime:0.039395s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32722220 ORDER BY `minOrder` ASC [ RunTime:0.038366s ]
select * from pdf where partno='1052706' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.056658s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052706' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.046667s ]
SELECT `id` FROM `stock` WHERE `id` <> 32722220 AND `partno` = '1052706' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.032990s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13297449 [ RunTime:0.032478s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32717831 LIMIT 5 [ RunTime:0.091182s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32717831 ORDER BY `minOrder` ASC [ RunTime:0.053914s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32717831 ORDER BY `unit` DESC [ RunTime:0.035219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32717831 LIMIT 2 [ RunTime:0.047121s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32717831 ORDER BY `minOrder` ASC [ RunTime:0.043375s ]
select * from pdf where partno='1052705' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.046763s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1052705' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.063833s ]
SELECT `id` FROM `stock` WHERE `id` <> 32717831 AND `partno` = '1052705' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.073574s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12028287 [ RunTime:0.064748s ]
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 '10527%' OR `brand` LIKE '10527%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020555s ]
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 '10527%' OR `brand` LIKE '10527%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017690s ]
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 '10527%' OR `brand` LIKE '10527%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021119s ]
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 '10527%' OR `brand` LIKE '10527%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010553s ]
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 '10527%' OR `brand` LIKE '10527%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019223s ]
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 '10527%' OR `brand` LIKE '10527%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021014s ]
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 '10527%' OR `brand` LIKE '10527%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.055705s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '10527%' OR `brand` LIKE '10527%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.072388s ]