SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001487s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.194' , `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=60707&search=1' [ RunTime:0.010974s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001301s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.007007s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002733s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.194' ) [ RunTime:0.002552s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002843s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000658s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002052s ]
SELECT * FROM `stock_search` WHERE `partno` = '60707' LIMIT 1 [ RunTime:0.002168s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-03 03:01:27' WHERE `partno` = '60707' [ RunTime:0.002471s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002283s ]
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 '60707%' OR `brand` LIKE '60707%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004379s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001027s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19526825 LIMIT 5 [ RunTime:0.006927s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001145s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526825 ORDER BY `minOrder` ASC [ RunTime:0.003487s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001373s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19526825 ORDER BY `unit` DESC [ RunTime:0.006607s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.002076s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19526825 LIMIT 2 [ RunTime:0.002188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526825 ORDER BY `minOrder` ASC [ RunTime:0.000228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19526833 LIMIT 5 [ RunTime:0.000292s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526833 ORDER BY `minOrder` ASC [ RunTime:0.010456s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19526833 ORDER BY `unit` DESC [ RunTime:0.004369s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19526833 LIMIT 2 [ RunTime:0.004554s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526833 ORDER BY `minOrder` ASC [ RunTime:0.002077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17287399 LIMIT 5 [ RunTime:0.000936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17287399 ORDER BY `minOrder` ASC [ RunTime:0.000283s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17287399 ORDER BY `unit` DESC [ RunTime:0.001881s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17287399 LIMIT 2 [ RunTime:0.004563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17287399 ORDER BY `minOrder` ASC [ RunTime:0.000348s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19526111 LIMIT 5 [ RunTime:0.001108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526111 ORDER BY `minOrder` ASC [ RunTime:0.000268s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19526111 ORDER BY `unit` DESC [ RunTime:0.005049s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19526111 LIMIT 2 [ RunTime:0.001468s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526111 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19526826 LIMIT 5 [ RunTime:0.000403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526826 ORDER BY `minOrder` ASC [ RunTime:0.002506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19526826 ORDER BY `unit` DESC [ RunTime:0.000245s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19526826 LIMIT 2 [ RunTime:0.001119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526826 ORDER BY `minOrder` ASC [ RunTime:0.013872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19526360 LIMIT 5 [ RunTime:0.006825s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526360 ORDER BY `minOrder` ASC [ RunTime:0.004170s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19526360 ORDER BY `unit` DESC [ RunTime:0.004700s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19526360 LIMIT 2 [ RunTime:0.008637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526360 ORDER BY `minOrder` ASC [ RunTime:0.000842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19526314 LIMIT 5 [ RunTime:0.014262s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526314 ORDER BY `minOrder` ASC [ RunTime:0.004186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19526314 ORDER BY `unit` DESC [ RunTime:0.007068s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19526314 LIMIT 2 [ RunTime:0.000943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526314 ORDER BY `minOrder` ASC [ RunTime:0.002883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19526264 LIMIT 5 [ RunTime:0.003691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526264 ORDER BY `minOrder` ASC [ RunTime:0.000951s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19526264 ORDER BY `unit` DESC [ RunTime:0.003350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19526264 LIMIT 2 [ RunTime:0.010775s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526264 ORDER BY `minOrder` ASC [ RunTime:0.003495s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19526223 LIMIT 5 [ RunTime:0.007802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526223 ORDER BY `minOrder` ASC [ RunTime:0.006063s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19526223 ORDER BY `unit` DESC [ RunTime:0.004894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19526223 LIMIT 2 [ RunTime:0.000642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526223 ORDER BY `minOrder` ASC [ RunTime:0.017718s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19526215 LIMIT 5 [ RunTime:0.014059s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526215 ORDER BY `minOrder` ASC [ RunTime:0.007868s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19526215 ORDER BY `unit` DESC [ RunTime:0.004300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19526215 LIMIT 2 [ RunTime:0.003161s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19526215 ORDER BY `minOrder` ASC [ RunTime:0.002752s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18777530 LIMIT 5 [ RunTime:0.001086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777530 ORDER BY `minOrder` ASC [ RunTime:0.010503s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 18777530 ORDER BY `unit` DESC [ RunTime:0.007706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 18777530 LIMIT 2 [ RunTime:0.000802s ]
SELECT * FROM `stock_price` WHERE `stockid` = 18777530 ORDER BY `minOrder` ASC [ RunTime:0.009585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17506414 LIMIT 5 [ RunTime:0.002025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17506414 ORDER BY `minOrder` ASC [ RunTime:0.001434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17506414 ORDER BY `unit` DESC [ RunTime:0.000619s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17506414 LIMIT 2 [ RunTime:0.009646s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17506414 ORDER BY `minOrder` ASC [ RunTime:0.005755s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17287229 LIMIT 5 [ RunTime:0.002750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17287229 ORDER BY `minOrder` ASC [ RunTime:0.000669s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17287229 ORDER BY `unit` DESC [ RunTime:0.009160s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17287229 LIMIT 2 [ RunTime:0.006193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17287229 ORDER BY `minOrder` ASC [ RunTime:0.004954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17287228 LIMIT 5 [ RunTime:0.005017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17287228 ORDER BY `minOrder` ASC [ RunTime:0.000731s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 17287228 ORDER BY `unit` DESC [ RunTime:0.004614s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 17287228 LIMIT 2 [ RunTime:0.001833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 17287228 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430554 LIMIT 5 [ RunTime:0.005622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430554 ORDER BY `minOrder` ASC [ RunTime:0.000719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15430554 ORDER BY `unit` DESC [ RunTime:0.009564s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15430554 LIMIT 2 [ RunTime:0.001465s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15430554 ORDER BY `minOrder` ASC [ RunTime:0.003803s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15232223 LIMIT 5 [ RunTime:0.007397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15232223 ORDER BY `minOrder` ASC [ RunTime:0.002158s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15232223 ORDER BY `unit` DESC [ RunTime:0.003023s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15232223 LIMIT 2 [ RunTime:0.003188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15232223 ORDER BY `minOrder` ASC [ RunTime:0.000434s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13296905 LIMIT 5 [ RunTime:0.000932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13296905 ORDER BY `minOrder` ASC [ RunTime:0.000670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13296905 ORDER BY `unit` DESC [ RunTime:0.007301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13296905 LIMIT 2 [ RunTime:0.000592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13296905 ORDER BY `minOrder` ASC [ RunTime:0.002475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12028510 LIMIT 5 [ RunTime:0.002270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12028510 ORDER BY `minOrder` ASC [ RunTime:0.008562s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12028510 ORDER BY `unit` DESC [ RunTime:0.000443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12028510 LIMIT 2 [ RunTime:0.000397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12028510 ORDER BY `minOrder` ASC [ RunTime:0.001852s ]
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 '60707%' OR `brand` LIKE '60707%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001724s ]
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 '60707%' OR `brand` LIKE '60707%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57793104 LIMIT 5 [ RunTime:0.000799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57793104 ORDER BY `minOrder` ASC [ RunTime:0.012144s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57793104 ORDER BY `unit` DESC [ RunTime:0.000768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57793104 LIMIT 2 [ RunTime:0.000540s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57793104 ORDER BY `minOrder` ASC [ RunTime:0.001227s ]
select * from pdf where partno='6070789' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007883s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001246s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6070789' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000941s ]
SELECT `id` FROM `stock` WHERE `id` <> 57793104 AND `partno` = '6070789' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.006697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19526111 [ RunTime:0.000592s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57793105 LIMIT 5 [ RunTime:0.004168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57793105 ORDER BY `minOrder` ASC [ RunTime:0.000380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57793105 ORDER BY `unit` DESC [ RunTime:0.000867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57793105 LIMIT 2 [ RunTime:0.000315s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57793105 ORDER BY `minOrder` ASC [ RunTime:0.000176s ]
select * from pdf where partno='6070799' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000734s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6070799' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000395s ]
SELECT `id` FROM `stock` WHERE `id` <> 57793105 AND `partno` = '6070799' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19526825 [ RunTime:0.000341s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57793118 LIMIT 5 [ RunTime:0.000656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57793118 ORDER BY `minOrder` ASC [ RunTime:0.000349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57793118 ORDER BY `unit` DESC [ RunTime:0.000242s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57793118 LIMIT 2 [ RunTime:0.001864s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57793118 ORDER BY `minOrder` ASC [ RunTime:0.000177s ]
select * from pdf where partno='6070792' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.001427s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6070792' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000557s ]
SELECT `id` FROM `stock` WHERE `id` <> 57793118 AND `partno` = '6070792' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.000496s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19526833 [ RunTime:0.000481s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57793110 LIMIT 5 [ RunTime:0.003331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57793110 ORDER BY `minOrder` ASC [ RunTime:0.002752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57793110 ORDER BY `unit` DESC [ RunTime:0.000663s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57793110 LIMIT 2 [ RunTime:0.000363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57793110 ORDER BY `minOrder` ASC [ RunTime:0.000314s ]
select * from pdf where partno='6070795' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004675s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6070795' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008789s ]
SELECT `id` FROM `stock` WHERE `id` <> 57793110 AND `partno` = '6070795' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.004482s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17287399 [ RunTime:0.003754s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57793485 LIMIT 5 [ RunTime:0.003434s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57793485 ORDER BY `minOrder` ASC [ RunTime:0.002643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57793485 ORDER BY `unit` DESC [ RunTime:0.008420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57793485 LIMIT 2 [ RunTime:0.000584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57793485 ORDER BY `minOrder` ASC [ RunTime:0.000341s ]
select * from pdf where partno='6070787' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.004155s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6070787' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000733s ]
SELECT `id` FROM `stock` WHERE `id` <> 57793485 AND `partno` = '6070787' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011268s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19526826 [ RunTime:0.002403s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57370127 LIMIT 5 [ RunTime:0.005018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57370127 ORDER BY `minOrder` ASC [ RunTime:0.007700s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57370127 ORDER BY `unit` DESC [ RunTime:0.006512s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57370127 LIMIT 2 [ RunTime:0.005282s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57370127 ORDER BY `minOrder` ASC [ RunTime:0.001951s ]
select * from pdf where partno='6070746' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000843s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6070746' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004281s ]
SELECT `id` FROM `stock` WHERE `id` <> 57370127 AND `partno` = '6070746' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.001123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57897189 LIMIT 5 [ RunTime:0.000759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57897189 ORDER BY `minOrder` ASC [ RunTime:0.001114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57897189 ORDER BY `unit` DESC [ RunTime:0.001318s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57897189 LIMIT 2 [ RunTime:0.001517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57897189 ORDER BY `minOrder` ASC [ RunTime:0.001735s ]
select * from pdf where partno='6070744' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000880s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6070744' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.003892s ]
SELECT `id` FROM `stock` WHERE `id` <> 57897189 AND `partno` = '6070744' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.010395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15232223 [ RunTime:0.002692s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57819767 LIMIT 5 [ RunTime:0.003988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57819767 ORDER BY `minOrder` ASC [ RunTime:0.003913s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57819767 ORDER BY `unit` DESC [ RunTime:0.011138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57819767 LIMIT 2 [ RunTime:0.002638s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57819767 ORDER BY `minOrder` ASC [ RunTime:0.001425s ]
select * from pdf where partno='6070717' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.013755s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6070717' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.008144s ]
SELECT `id` FROM `stock` WHERE `id` <> 57819767 AND `partno` = '6070717' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.002938s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18777530 [ RunTime:0.009736s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57795595 LIMIT 5 [ RunTime:0.013236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57795595 ORDER BY `minOrder` ASC [ RunTime:0.008480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57795595 ORDER BY `unit` DESC [ RunTime:0.001028s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57795595 LIMIT 2 [ RunTime:0.003479s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57795595 ORDER BY `minOrder` ASC [ RunTime:0.002269s ]
select * from pdf where partno='6070797' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.000800s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6070797' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.000868s ]
SELECT `id` FROM `stock` WHERE `id` <> 57795595 AND `partno` = '6070797' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.003501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19526360 [ RunTime:0.017074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57795507 LIMIT 5 [ RunTime:0.006463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57795507 ORDER BY `minOrder` ASC [ RunTime:0.018207s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57795507 ORDER BY `unit` DESC [ RunTime:0.006063s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57795507 LIMIT 2 [ RunTime:0.013492s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57795507 ORDER BY `minOrder` ASC [ RunTime:0.001412s ]
select * from pdf where partno='6070791' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.025694s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6070791' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.001801s ]
SELECT `id` FROM `stock` WHERE `id` <> 57795507 AND `partno` = '6070791' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.014462s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19526314 [ RunTime:0.019227s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57795464 LIMIT 5 [ RunTime:0.007583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57795464 ORDER BY `minOrder` ASC [ RunTime:0.016101s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57795464 ORDER BY `unit` DESC [ RunTime:0.034060s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57795464 LIMIT 2 [ RunTime:0.087755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57795464 ORDER BY `minOrder` ASC [ RunTime:0.009201s ]
select * from pdf where partno='6070798' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.026154s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6070798' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.078273s ]
SELECT `id` FROM `stock` WHERE `id` <> 57795464 AND `partno` = '6070798' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.022194s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17287229 [ RunTime:0.039533s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57795463 LIMIT 5 [ RunTime:0.017719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57795463 ORDER BY `minOrder` ASC [ RunTime:0.031238s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57795463 ORDER BY `unit` DESC [ RunTime:0.057829s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57795463 LIMIT 2 [ RunTime:0.041426s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57795463 ORDER BY `minOrder` ASC [ RunTime:0.058371s ]
select * from pdf where partno='6070796' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.022712s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6070796' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.056523s ]
SELECT `id` FROM `stock` WHERE `id` <> 57795463 AND `partno` = '6070796' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.032421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17287228 [ RunTime:0.044202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57795403 LIMIT 5 [ RunTime:0.054295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57795403 ORDER BY `minOrder` ASC [ RunTime:0.088947s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57795403 ORDER BY `unit` DESC [ RunTime:0.027174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57795403 LIMIT 2 [ RunTime:0.036809s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57795403 ORDER BY `minOrder` ASC [ RunTime:0.026085s ]
select * from pdf where partno='6070790' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.035780s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6070790' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.027749s ]
SELECT `id` FROM `stock` WHERE `id` <> 57795403 AND `partno` = '6070790' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.033085s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19526264 [ RunTime:0.046039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57795331 LIMIT 5 [ RunTime:0.023855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57795331 ORDER BY `minOrder` ASC [ RunTime:0.044185s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57795331 ORDER BY `unit` DESC [ RunTime:0.017490s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57795331 LIMIT 2 [ RunTime:0.016841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57795331 ORDER BY `minOrder` ASC [ RunTime:0.015301s ]
select * from pdf where partno='6070794' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.028282s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6070794' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.026506s ]
SELECT `id` FROM `stock` WHERE `id` <> 57795331 AND `partno` = '6070794' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.064978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19526223 [ RunTime:0.041117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57795304 LIMIT 5 [ RunTime:0.027035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57795304 ORDER BY `minOrder` ASC [ RunTime:0.040647s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57795304 ORDER BY `unit` DESC [ RunTime:0.031100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57795304 LIMIT 2 [ RunTime:0.037933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57795304 ORDER BY `minOrder` ASC [ RunTime:0.017637s ]
select * from pdf where partno='6070788' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.019312s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6070788' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.021347s ]
SELECT `id` FROM `stock` WHERE `id` <> 57795304 AND `partno` = '6070788' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.027359s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19526215 [ RunTime:0.010134s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57795086 LIMIT 5 [ RunTime:0.008752s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57795086 ORDER BY `minOrder` ASC [ RunTime:0.032744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57795086 ORDER BY `unit` DESC [ RunTime:0.016928s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57795086 LIMIT 2 [ RunTime:0.014163s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57795086 ORDER BY `minOrder` ASC [ RunTime:0.006239s ]
select * from pdf where partno='6070793' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.009778s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6070793' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.004440s ]
SELECT `id` FROM `stock` WHERE `id` <> 57795086 AND `partno` = '6070793' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.026760s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15430554 [ RunTime:0.004020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55385685 LIMIT 5 [ RunTime:0.023887s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55385685 ORDER BY `minOrder` ASC [ RunTime:0.013236s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55385685 ORDER BY `unit` DESC [ RunTime:0.009117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55385685 LIMIT 2 [ RunTime:0.005790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55385685 ORDER BY `minOrder` ASC [ RunTime:0.002753s ]
select * from pdf where partno='60707' and brandshort='Lumberg Automation' limit 1 [ RunTime:0.016841s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60707' OR `brand` LIKE 'Lumberg Automation%' ) ) LIMIT 1 [ RunTime:0.016049s ]
SELECT `id` FROM `stock` WHERE `id` <> 55385685 AND `partno` = '60707' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%lumberg automation%' ) [ RunTime:0.004907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17506414 [ RunTime:0.018388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32364440 LIMIT 5 [ RunTime:0.011930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32364440 ORDER BY `minOrder` ASC [ RunTime:0.028789s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32364440 ORDER BY `unit` DESC [ RunTime:0.034143s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32364440 LIMIT 2 [ RunTime:0.005042s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32364440 ORDER BY `minOrder` ASC [ RunTime:0.006710s ]
select * from pdf where partno='6070747' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.011791s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6070747' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.021616s ]
SELECT `id` FROM `stock` WHERE `id` <> 32364440 AND `partno` = '6070747' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.011413s ]
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 '60707%' OR `brand` LIKE '60707%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016700s ]
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 '60707%' OR `brand` LIKE '60707%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.034139s ]
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 '60707%' OR `brand` LIKE '60707%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016622s ]
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 '60707%' OR `brand` LIKE '60707%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010795s ]
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 '60707%' OR `brand` LIKE '60707%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015768s ]
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 '60707%' OR `brand` LIKE '60707%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009128s ]
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 '60707%' OR `brand` LIKE '60707%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012819s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '60707%' OR `brand` LIKE '60707%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.013474s ]