SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002391s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `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=5015&page=6&srecordnum=194' [ RunTime:0.001776s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001017s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003033s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001196s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.003268s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001159s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000273s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001827s ]
SELECT * FROM `stock_search` WHERE `partno` = '5015' LIMIT 1 [ RunTime:0.012672s ]
UPDATE `stock_search` SET `count` = 19432 , `updatetime` = '2026-06-13 07:06:02' WHERE `partno` = '5015' [ RunTime:0.019198s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001401s ]
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 '5015%' OR `brand` LIKE '5015%' ) AND `s`.`status` <> '2' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 100,20 [ RunTime:0.029525s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.015609s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33069340 LIMIT 4 [ RunTime:0.004594s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001727s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33069340 ORDER BY `minOrder` ASC [ RunTime:0.004807s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002113s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33069340 ORDER BY `unit` DESC [ RunTime:0.007756s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001290s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33069340 LIMIT 2 [ RunTime:0.008193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33069340 ORDER BY `minOrder` ASC [ RunTime:0.003518s ]
select * from pdf where partno='5015KL-05W-B59-E50' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.037467s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001555s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5015KL-05W-B59-E50' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.020738s ]
SELECT `id` FROM `stock` WHERE `id` <> 33069340 AND `partno` = '5015KL-05W-B59-E50' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.008576s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16967893 [ RunTime:0.035223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33069339 LIMIT 4 [ RunTime:0.027102s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33069339 ORDER BY `minOrder` ASC [ RunTime:0.004554s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33069339 ORDER BY `unit` DESC [ RunTime:0.019088s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33069339 LIMIT 2 [ RunTime:0.026851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33069339 ORDER BY `minOrder` ASC [ RunTime:0.005486s ]
select * from pdf where partno='5015KL-05W-B59-E00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.025843s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5015KL-05W-B59-E00' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.039846s ]
SELECT `id` FROM `stock` WHERE `id` <> 33069339 AND `partno` = '5015KL-05W-B59-E00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.036605s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16967892 [ RunTime:0.023930s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33069338 LIMIT 4 [ RunTime:0.025424s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33069338 ORDER BY `minOrder` ASC [ RunTime:0.010655s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33069338 ORDER BY `unit` DESC [ RunTime:0.090232s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33069338 LIMIT 2 [ RunTime:0.013270s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33069338 ORDER BY `minOrder` ASC [ RunTime:0.002910s ]
select * from pdf where partno='5015KL-05W-B39-E50' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.041919s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5015KL-05W-B39-E50' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.058491s ]
SELECT `id` FROM `stock` WHERE `id` <> 33069338 AND `partno` = '5015KL-05W-B39-E50' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.008613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18593361 [ RunTime:0.021753s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33069337 LIMIT 4 [ RunTime:0.011041s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33069337 ORDER BY `minOrder` ASC [ RunTime:0.015796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33069337 ORDER BY `unit` DESC [ RunTime:0.040703s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33069337 LIMIT 2 [ RunTime:0.011994s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33069337 ORDER BY `minOrder` ASC [ RunTime:0.014512s ]
select * from pdf where partno='5015KL-05W-B29-E50' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.040973s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5015KL-05W-B29-E50' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.019440s ]
SELECT `id` FROM `stock` WHERE `id` <> 33069337 AND `partno` = '5015KL-05W-B29-E50' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.011589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18593360 [ RunTime:0.029378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33069336 LIMIT 4 [ RunTime:0.018040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33069336 ORDER BY `minOrder` ASC [ RunTime:0.018497s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33069336 ORDER BY `unit` DESC [ RunTime:0.037660s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33069336 LIMIT 2 [ RunTime:0.012868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33069336 ORDER BY `minOrder` ASC [ RunTime:0.005481s ]
select * from pdf where partno='5015KL-04W-B59-E50' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.029169s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5015KL-04W-B59-E50' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.011766s ]
SELECT `id` FROM `stock` WHERE `id` <> 33069336 AND `partno` = '5015KL-04W-B59-E50' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.016618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14168800 [ RunTime:0.064971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33069335 LIMIT 4 [ RunTime:0.009176s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33069335 ORDER BY `minOrder` ASC [ RunTime:0.028620s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33069335 ORDER BY `unit` DESC [ RunTime:0.034101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33069335 LIMIT 2 [ RunTime:0.014639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33069335 ORDER BY `minOrder` ASC [ RunTime:0.015810s ]
select * from pdf where partno='5015KL-04W-B59-E00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.027083s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5015KL-04W-B59-E00' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.011726s ]
SELECT `id` FROM `stock` WHERE `id` <> 33069335 AND `partno` = '5015KL-04W-B59-E00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.013901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18593359 [ RunTime:0.021170s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33069334 LIMIT 4 [ RunTime:0.009790s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33069334 ORDER BY `minOrder` ASC [ RunTime:0.001433s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33069334 ORDER BY `unit` DESC [ RunTime:0.032662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33069334 LIMIT 2 [ RunTime:0.021985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33069334 ORDER BY `minOrder` ASC [ RunTime:0.003574s ]
select * from pdf where partno='5015KL-04W-B49-E50' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.042716s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5015KL-04W-B49-E50' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.012981s ]
SELECT `id` FROM `stock` WHERE `id` <> 33069334 AND `partno` = '5015KL-04W-B49-E50' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.017157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15180941 [ RunTime:0.025413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33069333 LIMIT 4 [ RunTime:0.017322s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33069333 ORDER BY `minOrder` ASC [ RunTime:0.008903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33069333 ORDER BY `unit` DESC [ RunTime:0.021772s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33069333 LIMIT 2 [ RunTime:0.009995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33069333 ORDER BY `minOrder` ASC [ RunTime:0.025756s ]
select * from pdf where partno='5015KL-04W-B39-E50' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.011379s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5015KL-04W-B39-E50' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.023044s ]
SELECT `id` FROM `stock` WHERE `id` <> 33069333 AND `partno` = '5015KL-04W-B39-E50' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.018500s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18593358 [ RunTime:0.024021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33069320 LIMIT 4 [ RunTime:0.036962s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33069320 ORDER BY `minOrder` ASC [ RunTime:0.021092s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33069320 ORDER BY `unit` DESC [ RunTime:0.022543s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33069320 LIMIT 2 [ RunTime:0.006220s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33069320 ORDER BY `minOrder` ASC [ RunTime:0.041856s ]
select * from pdf where partno='5015KL-05W-B40-E00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.032279s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5015KL-05W-B40-E00' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.015143s ]
SELECT `id` FROM `stock` WHERE `id` <> 33069320 AND `partno` = '5015KL-05W-B40-E00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.007935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15180917 [ RunTime:0.040906s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33069319 LIMIT 4 [ RunTime:0.022393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33069319 ORDER BY `minOrder` ASC [ RunTime:0.004011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33069319 ORDER BY `unit` DESC [ RunTime:0.014801s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33069319 LIMIT 2 [ RunTime:0.030325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33069319 ORDER BY `minOrder` ASC [ RunTime:0.009052s ]
select * from pdf where partno='5015KL-07W-B50-E00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.013991s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5015KL-07W-B50-E00' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.006542s ]
SELECT `id` FROM `stock` WHERE `id` <> 33069319 AND `partno` = '5015KL-07W-B50-E00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.003570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15180943 [ RunTime:0.022628s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33069318 LIMIT 4 [ RunTime:0.011512s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33069318 ORDER BY `minOrder` ASC [ RunTime:0.017274s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33069318 ORDER BY `unit` DESC [ RunTime:0.010613s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33069318 LIMIT 2 [ RunTime:0.022157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33069318 ORDER BY `minOrder` ASC [ RunTime:0.003994s ]
select * from pdf where partno='5015KL-05W-B50-E00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.008846s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5015KL-05W-B50-E00' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.018161s ]
SELECT `id` FROM `stock` WHERE `id` <> 33069318 AND `partno` = '5015KL-05W-B50-E00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.009487s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16007222 [ RunTime:0.010213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33069317 LIMIT 4 [ RunTime:0.041139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33069317 ORDER BY `minOrder` ASC [ RunTime:0.033793s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33069317 ORDER BY `unit` DESC [ RunTime:0.016304s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33069317 LIMIT 2 [ RunTime:0.020328s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33069317 ORDER BY `minOrder` ASC [ RunTime:0.003450s ]
select * from pdf where partno='5015KL-05W-B30-E00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.024183s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5015KL-05W-B30-E00' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.007229s ]
SELECT `id` FROM `stock` WHERE `id` <> 33069317 AND `partno` = '5015KL-05W-B30-E00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.011895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18593366 [ RunTime:0.017823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33069316 LIMIT 4 [ RunTime:0.010263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33069316 ORDER BY `minOrder` ASC [ RunTime:0.028038s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33069316 ORDER BY `unit` DESC [ RunTime:0.015101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33069316 LIMIT 2 [ RunTime:0.010447s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33069316 ORDER BY `minOrder` ASC [ RunTime:0.008324s ]
select * from pdf where partno='5015KL-04W-B50-E00' and brandshort='NMB Technologies Corporation' limit 1 [ RunTime:0.029101s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '5015KL-04W-B50-E00' OR `brand` LIKE 'NMB Technologies Corporation%' ) ) LIMIT 1 [ RunTime:0.010518s ]
SELECT `id` FROM `stock` WHERE `id` <> 33069316 AND `partno` = '5015KL-04W-B50-E00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%nmb technologies corporation%' ) [ RunTime:0.014616s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 18593365 [ RunTime:0.018543s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33037527 LIMIT 4 [ RunTime:0.023875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33037527 ORDER BY `minOrder` ASC [ RunTime:0.018128s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33037527 ORDER BY `unit` DESC [ RunTime:0.002141s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33037527 LIMIT 2 [ RunTime:0.005534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33037527 ORDER BY `minOrder` ASC [ RunTime:0.005149s ]
select * from pdf where partno='50154 25 YELLOW' and brandshort='APM Hexseal' limit 1 [ RunTime:0.004039s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50154 25 YELLOW' OR `brand` LIKE 'APM Hexseal%' ) ) LIMIT 1 [ RunTime:0.021456s ]
SELECT `id` FROM `stock` WHERE `id` <> 33037527 AND `partno` = '50154 25 YELLOW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apm hexseal%' ) [ RunTime:0.026705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19531245 [ RunTime:0.001684s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33037526 LIMIT 4 [ RunTime:0.005027s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33037526 ORDER BY `minOrder` ASC [ RunTime:0.024157s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33037526 ORDER BY `unit` DESC [ RunTime:0.012315s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33037526 LIMIT 2 [ RunTime:0.018219s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33037526 ORDER BY `minOrder` ASC [ RunTime:0.008256s ]
select * from pdf where partno='50154 25 17 1/2-32' and brandshort='APM Hexseal' limit 1 [ RunTime:0.032641s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50154 25 17 1/2-32' OR `brand` LIKE 'APM Hexseal%' ) ) LIMIT 1 [ RunTime:0.009095s ]
SELECT `id` FROM `stock` WHERE `id` <> 33037526 AND `partno` = '50154 25 17 1/2-32' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apm hexseal%' ) [ RunTime:0.012561s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19531244 [ RunTime:0.012785s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33037525 LIMIT 4 [ RunTime:0.013759s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33037525 ORDER BY `minOrder` ASC [ RunTime:0.009435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33037525 ORDER BY `unit` DESC [ RunTime:0.009618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33037525 LIMIT 2 [ RunTime:0.026535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33037525 ORDER BY `minOrder` ASC [ RunTime:0.005635s ]
select * from pdf where partno='50154 25 B12-6' and brandshort='APM Hexseal' limit 1 [ RunTime:0.007256s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50154 25 B12-6' OR `brand` LIKE 'APM Hexseal%' ) ) LIMIT 1 [ RunTime:0.019202s ]
SELECT `id` FROM `stock` WHERE `id` <> 33037525 AND `partno` = '50154 25 B12-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apm hexseal%' ) [ RunTime:0.011062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19531243 [ RunTime:0.005256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33037524 LIMIT 4 [ RunTime:0.007431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33037524 ORDER BY `minOrder` ASC [ RunTime:0.022423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33037524 ORDER BY `unit` DESC [ RunTime:0.015293s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33037524 LIMIT 2 [ RunTime:0.008562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33037524 ORDER BY `minOrder` ASC [ RunTime:0.004689s ]
select * from pdf where partno='50154 25 ORANGE' and brandshort='APM Hexseal' limit 1 [ RunTime:0.001073s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50154 25 ORANGE' OR `brand` LIKE 'APM Hexseal%' ) ) LIMIT 1 [ RunTime:0.004256s ]
SELECT `id` FROM `stock` WHERE `id` <> 33037524 AND `partno` = '50154 25 ORANGE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apm hexseal%' ) [ RunTime:0.006567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19531239 [ RunTime:0.024052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33037523 LIMIT 4 [ RunTime:0.012742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33037523 ORDER BY `minOrder` ASC [ RunTime:0.028531s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33037523 ORDER BY `unit` DESC [ RunTime:0.017972s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33037523 LIMIT 2 [ RunTime:0.005922s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33037523 ORDER BY `minOrder` ASC [ RunTime:0.011154s ]
select * from pdf where partno='50154 25 CLEAR' and brandshort='APM Hexseal' limit 1 [ RunTime:0.013509s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50154 25 CLEAR' OR `brand` LIKE 'APM Hexseal%' ) ) LIMIT 1 [ RunTime:0.008470s ]
SELECT `id` FROM `stock` WHERE `id` <> 33037523 AND `partno` = '50154 25 CLEAR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apm hexseal%' ) [ RunTime:0.002395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19531238 [ RunTime:0.004285s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33037522 LIMIT 4 [ RunTime:0.011281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33037522 ORDER BY `minOrder` ASC [ RunTime:0.000972s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33037522 ORDER BY `unit` DESC [ RunTime:0.008449s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33037522 LIMIT 2 [ RunTime:0.012686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33037522 ORDER BY `minOrder` ASC [ RunTime:0.003167s ]
select * from pdf where partno='50154 25 2202' and brandshort='APM Hexseal' limit 1 [ RunTime:0.005487s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50154 25 2202' OR `brand` LIKE 'APM Hexseal%' ) ) LIMIT 1 [ RunTime:0.012924s ]
SELECT `id` FROM `stock` WHERE `id` <> 33037522 AND `partno` = '50154 25 2202' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apm hexseal%' ) [ RunTime:0.002580s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17288709 [ RunTime:0.000526s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33037488 LIMIT 4 [ RunTime:0.000458s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33037488 ORDER BY `minOrder` ASC [ RunTime:0.015060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33037488 ORDER BY `unit` DESC [ RunTime:0.004965s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33037488 LIMIT 2 [ RunTime:0.013960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33037488 ORDER BY `minOrder` ASC [ RunTime:0.010890s ]
select * from pdf where partno='50154 S5004' and brandshort='APM Hexseal' limit 1 [ RunTime:0.007343s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '50154 S5004' OR `brand` LIKE 'APM Hexseal%' ) ) LIMIT 1 [ RunTime:0.004139s ]
SELECT `id` FROM `stock` WHERE `id` <> 33037488 AND `partno` = '50154 S5004' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%apm hexseal%' ) [ RunTime:0.016433s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19531218 [ RunTime:0.010866s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5015%' OR `brand` LIKE '5015%' ) AND `s`.`status` <> '2' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 100,20 [ RunTime:0.004977s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5015%' OR `brand` LIKE '5015%' ) AND `s`.`status` <> '2' ) ) tmp GROUP BY `brand` [ RunTime:0.002142s ]
SELECT DISTINCT `categoryid` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '5015%' OR `brand` LIKE '5015%' ) AND `s`.`status` <> '2' ) AND `categoryid` > 0 [ RunTime:0.000509s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 29 [ RunTime:0.000423s ]