SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001018s ]
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=60910&search=1' [ RunTime:0.004737s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.000929s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000376s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001870s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.194' ) [ RunTime:0.001225s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001013s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002618s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001326s ]
SELECT * FROM `stock_search` WHERE `partno` = '60910' LIMIT 1 [ RunTime:0.007119s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-02 21:11:25' WHERE `partno` = '60910' [ RunTime:0.013692s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001493s ]
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 '60910%' OR `brand` LIKE '60910%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009087s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.006259s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19667145 LIMIT 5 [ RunTime:0.009082s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667145 ORDER BY `minOrder` ASC [ RunTime:0.019848s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002441s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19667145 ORDER BY `unit` DESC [ RunTime:0.018890s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.008899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19667145 LIMIT 2 [ RunTime:0.018136s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667145 ORDER BY `minOrder` ASC [ RunTime:0.004751s ]
select * from pdf where partno='60910213421' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.044346s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19667272 LIMIT 5 [ RunTime:0.032234s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667272 ORDER BY `minOrder` ASC [ RunTime:0.027540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19667272 ORDER BY `unit` DESC [ RunTime:0.029198s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19667272 LIMIT 2 [ RunTime:0.011179s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667272 ORDER BY `minOrder` ASC [ RunTime:0.005312s ]
select * from pdf where partno='60910413421' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.013347s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15454058 LIMIT 5 [ RunTime:0.015083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15454058 ORDER BY `minOrder` ASC [ RunTime:0.025553s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15454058 ORDER BY `unit` DESC [ RunTime:0.016699s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15454058 LIMIT 2 [ RunTime:0.042424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15454058 ORDER BY `minOrder` ASC [ RunTime:0.018317s ]
select * from pdf where partno='60910613421' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.011630s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19667273 LIMIT 5 [ RunTime:0.029283s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667273 ORDER BY `minOrder` ASC [ RunTime:0.039091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19667273 ORDER BY `unit` DESC [ RunTime:0.038559s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19667273 LIMIT 2 [ RunTime:0.010675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667273 ORDER BY `minOrder` ASC [ RunTime:0.002809s ]
select * from pdf where partno='60910313421' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.014210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19667276 LIMIT 5 [ RunTime:0.027382s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667276 ORDER BY `minOrder` ASC [ RunTime:0.039606s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19667276 ORDER BY `unit` DESC [ RunTime:0.056550s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19667276 LIMIT 2 [ RunTime:0.017578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19667276 ORDER BY `minOrder` ASC [ RunTime:0.014687s ]
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 '60910%' OR `brand` LIKE '60910%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.013486s ]
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 '60910%' OR `brand` LIKE '60910%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049357s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59347096 LIMIT 5 [ RunTime:0.064933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59347096 ORDER BY `minOrder` ASC [ RunTime:0.034126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59347096 ORDER BY `unit` DESC [ RunTime:0.047903s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59347096 LIMIT 2 [ RunTime:0.064607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59347096 ORDER BY `minOrder` ASC [ RunTime:0.016522s ]
select * from pdf where partno='60910213421' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.067551s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003758s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60910213421' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.056064s ]
SELECT `id` FROM `stock` WHERE `id` <> 59347096 AND `partno` = '60910213421' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.091050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19667145 [ RunTime:0.093830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59347271 LIMIT 5 [ RunTime:0.037721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59347271 ORDER BY `minOrder` ASC [ RunTime:0.076182s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59347271 ORDER BY `unit` DESC [ RunTime:0.096449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59347271 LIMIT 2 [ RunTime:0.033906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59347271 ORDER BY `minOrder` ASC [ RunTime:0.042717s ]
select * from pdf where partno='60910313421' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.022550s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60910313421' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.021587s ]
SELECT `id` FROM `stock` WHERE `id` <> 59347271 AND `partno` = '60910313421' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.134417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19667273 [ RunTime:0.040451s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59347275 LIMIT 5 [ RunTime:0.052144s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59347275 ORDER BY `minOrder` ASC [ RunTime:0.022094s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59347275 ORDER BY `unit` DESC [ RunTime:0.029493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59347275 LIMIT 2 [ RunTime:0.027311s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59347275 ORDER BY `minOrder` ASC [ RunTime:0.021820s ]
select * from pdf where partno='60910813421' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.024557s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60910813421' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.024906s ]
SELECT `id` FROM `stock` WHERE `id` <> 59347275 AND `partno` = '60910813421' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.021762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19667276 [ RunTime:0.054860s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59347272 LIMIT 5 [ RunTime:0.016486s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59347272 ORDER BY `minOrder` ASC [ RunTime:0.062440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59347272 ORDER BY `unit` DESC [ RunTime:0.056703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59347272 LIMIT 2 [ RunTime:0.028859s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59347272 ORDER BY `minOrder` ASC [ RunTime:0.010996s ]
select * from pdf where partno='60910413421' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.022749s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60910413421' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.013392s ]
SELECT `id` FROM `stock` WHERE `id` <> 59347272 AND `partno` = '60910413421' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.028908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19667272 [ RunTime:0.013484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59347285 LIMIT 5 [ RunTime:0.016863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59347285 ORDER BY `minOrder` ASC [ RunTime:0.014709s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59347285 ORDER BY `unit` DESC [ RunTime:0.028723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59347285 LIMIT 2 [ RunTime:0.031371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59347285 ORDER BY `minOrder` ASC [ RunTime:0.013019s ]
select * from pdf where partno='60910613421' and brandshort='Würth Elektronik' limit 1 [ RunTime:0.017431s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60910613421' OR `brand` LIKE 'Würth Elektronik%' ) ) LIMIT 1 [ RunTime:0.016966s ]
SELECT `id` FROM `stock` WHERE `id` <> 59347285 AND `partno` = '60910613421' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%würth elektronik%' ) [ RunTime:0.025888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15454058 [ RunTime:0.006084s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58586461 LIMIT 5 [ RunTime:0.015816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58586461 ORDER BY `minOrder` ASC [ RunTime:0.014758s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58586461 ORDER BY `unit` DESC [ RunTime:0.011008s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58586461 LIMIT 2 [ RunTime:0.024112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58586461 ORDER BY `minOrder` ASC [ RunTime:0.015222s ]
select * from pdf where partno='60910' and brandshort='Klein Tools, Inc.' limit 1 [ RunTime:0.004043s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '60910' OR `brand` LIKE 'Klein Tools, Inc.%' ) ) LIMIT 1 [ RunTime:0.031621s ]
SELECT `id` FROM `stock` WHERE `id` <> 58586461 AND `partno` = '60910' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%klein tools, inc.%' ) [ RunTime:0.015999s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57897988 LIMIT 5 [ RunTime:0.023997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57897988 ORDER BY `minOrder` ASC [ RunTime:0.043986s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57897988 ORDER BY `unit` DESC [ RunTime:0.021880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57897988 LIMIT 2 [ RunTime:0.022779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57897988 ORDER BY `minOrder` ASC [ RunTime:0.023819s ]
select * from pdf where partno='6091069' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.015284s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6091069' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.009425s ]
SELECT `id` FROM `stock` WHERE `id` <> 57897988 AND `partno` = '6091069' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.030832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57897987 LIMIT 5 [ RunTime:0.012214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57897987 ORDER BY `minOrder` ASC [ RunTime:0.010692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57897987 ORDER BY `unit` DESC [ RunTime:0.016809s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57897987 LIMIT 2 [ RunTime:0.046265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57897987 ORDER BY `minOrder` ASC [ RunTime:0.033895s ]
select * from pdf where partno='6091076' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.025467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6091076' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.016747s ]
SELECT `id` FROM `stock` WHERE `id` <> 57897987 AND `partno` = '6091076' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.014842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57897986 LIMIT 5 [ RunTime:0.024694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57897986 ORDER BY `minOrder` ASC [ RunTime:0.023843s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57897986 ORDER BY `unit` DESC [ RunTime:0.039601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57897986 LIMIT 2 [ RunTime:0.012708s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57897986 ORDER BY `minOrder` ASC [ RunTime:0.013452s ]
select * from pdf where partno='6091075' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.079620s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6091075' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.056904s ]
SELECT `id` FROM `stock` WHERE `id` <> 57897986 AND `partno` = '6091075' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.031020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57897472 LIMIT 5 [ RunTime:0.040408s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57897472 ORDER BY `minOrder` ASC [ RunTime:0.066261s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57897472 ORDER BY `unit` DESC [ RunTime:0.034987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57897472 LIMIT 2 [ RunTime:0.106503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57897472 ORDER BY `minOrder` ASC [ RunTime:0.004127s ]
select * from pdf where partno='6091074' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.031798s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6091074' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.025605s ]
SELECT `id` FROM `stock` WHERE `id` <> 57897472 AND `partno` = '6091074' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.061497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57897471 LIMIT 5 [ RunTime:0.038342s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57897471 ORDER BY `minOrder` ASC [ RunTime:0.029191s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57897471 ORDER BY `unit` DESC [ RunTime:0.029860s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57897471 LIMIT 2 [ RunTime:0.027683s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57897471 ORDER BY `minOrder` ASC [ RunTime:0.051605s ]
select * from pdf where partno='6091071' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.038623s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6091071' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.018779s ]
SELECT `id` FROM `stock` WHERE `id` <> 57897471 AND `partno` = '6091071' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.010784s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57897470 LIMIT 5 [ RunTime:0.043265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57897470 ORDER BY `minOrder` ASC [ RunTime:0.038948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57897470 ORDER BY `unit` DESC [ RunTime:0.069182s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57897470 LIMIT 2 [ RunTime:0.093453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57897470 ORDER BY `minOrder` ASC [ RunTime:0.025048s ]
select * from pdf where partno='6091072' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.064606s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6091072' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.026182s ]
SELECT `id` FROM `stock` WHERE `id` <> 57897470 AND `partno` = '6091072' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.052501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57897469 LIMIT 5 [ RunTime:0.055890s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57897469 ORDER BY `minOrder` ASC [ RunTime:0.026533s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57897469 ORDER BY `unit` DESC [ RunTime:0.005532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57897469 LIMIT 2 [ RunTime:0.007940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57897469 ORDER BY `minOrder` ASC [ RunTime:0.002804s ]
select * from pdf where partno='6091077' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.007353s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6091077' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.012789s ]
SELECT `id` FROM `stock` WHERE `id` <> 57897469 AND `partno` = '6091077' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.029345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57897468 LIMIT 5 [ RunTime:0.068014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57897468 ORDER BY `minOrder` ASC [ RunTime:0.031813s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57897468 ORDER BY `unit` DESC [ RunTime:0.023602s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57897468 LIMIT 2 [ RunTime:0.035169s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57897468 ORDER BY `minOrder` ASC [ RunTime:0.018422s ]
select * from pdf where partno='6091073' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.051922s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6091073' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.026966s ]
SELECT `id` FROM `stock` WHERE `id` <> 57897468 AND `partno` = '6091073' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.083043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57897467 LIMIT 5 [ RunTime:0.029867s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57897467 ORDER BY `minOrder` ASC [ RunTime:0.015763s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57897467 ORDER BY `unit` DESC [ RunTime:0.037127s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57897467 LIMIT 2 [ RunTime:0.015013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57897467 ORDER BY `minOrder` ASC [ RunTime:0.006098s ]
select * from pdf where partno='6091078' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.037305s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6091078' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.007766s ]
SELECT `id` FROM `stock` WHERE `id` <> 57897467 AND `partno` = '6091078' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.014977s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57897274 LIMIT 5 [ RunTime:0.046727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57897274 ORDER BY `minOrder` ASC [ RunTime:0.045397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57897274 ORDER BY `unit` DESC [ RunTime:0.056513s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57897274 LIMIT 2 [ RunTime:0.061882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57897274 ORDER BY `minOrder` ASC [ RunTime:0.013098s ]
select * from pdf where partno='6091055' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.034294s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6091055' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.038074s ]
SELECT `id` FROM `stock` WHERE `id` <> 57897274 AND `partno` = '6091055' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.023509s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57897273 LIMIT 5 [ RunTime:0.165681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57897273 ORDER BY `minOrder` ASC [ RunTime:0.041692s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57897273 ORDER BY `unit` DESC [ RunTime:0.082149s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57897273 LIMIT 2 [ RunTime:0.069225s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57897273 ORDER BY `minOrder` ASC [ RunTime:0.016076s ]
select * from pdf where partno='6091067' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.026084s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6091067' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.039453s ]
SELECT `id` FROM `stock` WHERE `id` <> 57897273 AND `partno` = '6091067' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.044673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57896940 LIMIT 5 [ RunTime:0.031971s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57896940 ORDER BY `minOrder` ASC [ RunTime:0.004933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57896940 ORDER BY `unit` DESC [ RunTime:0.028329s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57896940 LIMIT 2 [ RunTime:0.037969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57896940 ORDER BY `minOrder` ASC [ RunTime:0.013538s ]
select * from pdf where partno='6091063' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.025422s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6091063' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.027372s ]
SELECT `id` FROM `stock` WHERE `id` <> 57896940 AND `partno` = '6091063' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.034199s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57896938 LIMIT 5 [ RunTime:0.060287s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57896938 ORDER BY `minOrder` ASC [ RunTime:0.032242s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57896938 ORDER BY `unit` DESC [ RunTime:0.032726s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57896938 LIMIT 2 [ RunTime:0.081561s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57896938 ORDER BY `minOrder` ASC [ RunTime:0.029352s ]
select * from pdf where partno='6091062' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.048562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6091062' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.065328s ]
SELECT `id` FROM `stock` WHERE `id` <> 57896938 AND `partno` = '6091062' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.025690s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 57896937 LIMIT 5 [ RunTime:0.022417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57896937 ORDER BY `minOrder` ASC [ RunTime:0.016307s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 57896937 ORDER BY `unit` DESC [ RunTime:0.007857s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 57896937 LIMIT 2 [ RunTime:0.036431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 57896937 ORDER BY `minOrder` ASC [ RunTime:0.016152s ]
select * from pdf where partno='6091066' and brandshort='SICK, Inc.' limit 1 [ RunTime:0.039698s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '6091066' OR `brand` LIKE 'SICK, Inc.%' ) ) LIMIT 1 [ RunTime:0.020082s ]
SELECT `id` FROM `stock` WHERE `id` <> 57896937 AND `partno` = '6091066' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%sick, inc.%' ) [ RunTime:0.035057s ]
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 '60910%' OR `brand` LIKE '60910%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024333s ]
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 '60910%' OR `brand` LIKE '60910%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053360s ]
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 '60910%' OR `brand` LIKE '60910%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010472s ]
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 '60910%' OR `brand` LIKE '60910%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036569s ]
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 '60910%' OR `brand` LIKE '60910%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.030847s ]
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 '60910%' OR `brand` LIKE '60910%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027679s ]
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 '60910%' OR `brand` LIKE '60910%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019518s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '60910%' OR `brand` LIKE '60910%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.040457s ]