SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001149s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.20' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://ic118.com/stock&keyword=3013&page=6&srecordnum=180' [ RunTime:0.002540s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002542s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.002170s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001681s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.20' ) [ RunTime:0.000248s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001028s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.005931s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001424s ]
SELECT * FROM `stock_search` WHERE `partno` = '3013' LIMIT 1 [ RunTime:0.004880s ]
UPDATE `stock_search` SET `count` = 20153 , `updatetime` = '2026-06-15 07:05:32' WHERE `partno` = '3013' [ RunTime:0.002096s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002141s ]
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 '3013%' OR `brand` LIKE '3013%' ) AND `s`.`status` <> '2' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 100,20 [ RunTime:0.036483s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001105s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35325031 LIMIT 4 [ RunTime:0.003734s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.005955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35325031 ORDER BY `minOrder` ASC [ RunTime:0.013657s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.003002s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35325031 ORDER BY `unit` DESC [ RunTime:0.000923s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35325031 LIMIT 2 [ RunTime:0.000411s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35325031 ORDER BY `minOrder` ASC [ RunTime:0.002910s ]
select * from pdf where partno='3013W3PAM99A30X' and brandshort='Amphenol CONEC' limit 1 [ RunTime:0.006802s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001436s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3013W3PAM99A30X' OR `brand` LIKE 'Amphenol CONEC%' ) ) LIMIT 1 [ RunTime:0.008452s ]
SELECT `id` FROM `stock` WHERE `id` <> 35325031 AND `partno` = '3013W3PAM99A30X' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol conec%' ) [ RunTime:0.005302s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13142877 [ RunTime:0.017203s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35324773 LIMIT 4 [ RunTime:0.008861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35324773 ORDER BY `minOrder` ASC [ RunTime:0.020119s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35324773 ORDER BY `unit` DESC [ RunTime:0.001626s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35324773 LIMIT 2 [ RunTime:0.000835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35324773 ORDER BY `minOrder` ASC [ RunTime:0.002139s ]
select * from pdf where partno='3013W6PAM99A30X' and brandshort='Amphenol CONEC' limit 1 [ RunTime:0.007467s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3013W6PAM99A30X' OR `brand` LIKE 'Amphenol CONEC%' ) ) LIMIT 1 [ RunTime:0.014305s ]
SELECT `id` FROM `stock` WHERE `id` <> 35324773 AND `partno` = '3013W6PAM99A30X' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol conec%' ) [ RunTime:0.002103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11881823 [ RunTime:0.001620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35324580 LIMIT 4 [ RunTime:0.000366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35324580 ORDER BY `minOrder` ASC [ RunTime:0.002922s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35324580 ORDER BY `unit` DESC [ RunTime:0.003343s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35324580 LIMIT 2 [ RunTime:0.001033s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35324580 ORDER BY `minOrder` ASC [ RunTime:0.000410s ]
select * from pdf where partno='3013W3PAN99A10X' and brandshort='Amphenol CONEC' limit 1 [ RunTime:0.000761s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3013W3PAN99A10X' OR `brand` LIKE 'Amphenol CONEC%' ) ) LIMIT 1 [ RunTime:0.000439s ]
SELECT `id` FROM `stock` WHERE `id` <> 35324580 AND `partno` = '3013W3PAN99A10X' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol conec%' ) [ RunTime:0.002698s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35322934 LIMIT 4 [ RunTime:0.000345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35322934 ORDER BY `minOrder` ASC [ RunTime:0.004886s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35322934 ORDER BY `unit` DESC [ RunTime:0.001420s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35322934 LIMIT 2 [ RunTime:0.001337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35322934 ORDER BY `minOrder` ASC [ RunTime:0.000770s ]
select * from pdf where partno='3013W6SAM99A10X' and brandshort='Amphenol CONEC' limit 1 [ RunTime:0.003877s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3013W6SAM99A10X' OR `brand` LIKE 'Amphenol CONEC%' ) ) LIMIT 1 [ RunTime:0.003703s ]
SELECT `id` FROM `stock` WHERE `id` <> 35322934 AND `partno` = '3013W6SAM99A10X' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol conec%' ) [ RunTime:0.002726s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35322909 LIMIT 4 [ RunTime:0.010696s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35322909 ORDER BY `minOrder` ASC [ RunTime:0.000411s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35322909 ORDER BY `unit` DESC [ RunTime:0.003896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35322909 LIMIT 2 [ RunTime:0.000305s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35322909 ORDER BY `minOrder` ASC [ RunTime:0.004871s ]
select * from pdf where partno='3013W3SAR99A10X' and brandshort='Amphenol CONEC' limit 1 [ RunTime:0.013898s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3013W3SAR99A10X' OR `brand` LIKE 'Amphenol CONEC%' ) ) LIMIT 1 [ RunTime:0.016797s ]
SELECT `id` FROM `stock` WHERE `id` <> 35322909 AND `partno` = '3013W3SAR99A10X' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol conec%' ) [ RunTime:0.006671s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13141564 [ RunTime:0.002354s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35322302 LIMIT 4 [ RunTime:0.002891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35322302 ORDER BY `minOrder` ASC [ RunTime:0.017674s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35322302 ORDER BY `unit` DESC [ RunTime:0.013941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35322302 LIMIT 2 [ RunTime:0.001720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35322302 ORDER BY `minOrder` ASC [ RunTime:0.015127s ]
select * from pdf where partno='3013W6SAR99A10X' and brandshort='Amphenol CONEC' limit 1 [ RunTime:0.001035s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3013W6SAR99A10X' OR `brand` LIKE 'Amphenol CONEC%' ) ) LIMIT 1 [ RunTime:0.012213s ]
SELECT `id` FROM `stock` WHERE `id` <> 35322302 AND `partno` = '3013W6SAR99A10X' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol conec%' ) [ RunTime:0.000964s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33594208 LIMIT 4 [ RunTime:0.000662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33594208 ORDER BY `minOrder` ASC [ RunTime:0.001525s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33594208 ORDER BY `unit` DESC [ RunTime:0.000514s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33594208 LIMIT 2 [ RunTime:0.002261s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33594208 ORDER BY `minOrder` ASC [ RunTime:0.004947s ]
select * from pdf where partno='3013081' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.003482s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3013081' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002828s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33560462 LIMIT 4 [ RunTime:0.002189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33560462 ORDER BY `minOrder` ASC [ RunTime:0.001060s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33560462 ORDER BY `unit` DESC [ RunTime:0.001090s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33560462 LIMIT 2 [ RunTime:0.000550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33560462 ORDER BY `minOrder` ASC [ RunTime:0.000319s ]
select * from pdf where partno='3013094' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.000786s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3013094' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.002107s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33528721 LIMIT 4 [ RunTime:0.005344s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528721 ORDER BY `minOrder` ASC [ RunTime:0.002764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33528721 ORDER BY `unit` DESC [ RunTime:0.000938s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33528721 LIMIT 2 [ RunTime:0.000423s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33528721 ORDER BY `minOrder` ASC [ RunTime:0.001448s ]
select * from pdf where partno='3013.0' and brandshort='Conta-Clip, Inc.' limit 1 [ RunTime:0.002672s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3013.0' OR `brand` LIKE 'Conta-Clip, Inc.%' ) ) LIMIT 1 [ RunTime:0.000714s ]
SELECT `id` FROM `stock` WHERE `id` <> 33528721 AND `partno` = '3013.0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%conta-clip, inc.%' ) [ RunTime:0.000610s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33399369 LIMIT 4 [ RunTime:0.004933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33399369 ORDER BY `minOrder` ASC [ RunTime:0.002249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33399369 ORDER BY `unit` DESC [ RunTime:0.003611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33399369 LIMIT 2 [ RunTime:0.002972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33399369 ORDER BY `minOrder` ASC [ RunTime:0.000366s ]
select * from pdf where partno='3013-0-15-15-32-27-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.001191s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3013-0-15-15-32-27-04-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.001815s ]
SELECT `id` FROM `stock` WHERE `id` <> 33399369 AND `partno` = '3013-0-15-15-32-27-04-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.012850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19596385 [ RunTime:0.007499s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33399007 LIMIT 4 [ RunTime:0.003393s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33399007 ORDER BY `minOrder` ASC [ RunTime:0.010319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33399007 ORDER BY `unit` DESC [ RunTime:0.001184s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33399007 LIMIT 2 [ RunTime:0.004611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33399007 ORDER BY `minOrder` ASC [ RunTime:0.002310s ]
select * from pdf where partno='3013-0-15-15-32-14-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.003179s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3013-0-15-15-32-14-04-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.003221s ]
SELECT `id` FROM `stock` WHERE `id` <> 33399007 AND `partno` = '3013-0-15-15-32-14-04-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.001846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15443109 [ RunTime:0.001748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33398131 LIMIT 4 [ RunTime:0.000390s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33398131 ORDER BY `minOrder` ASC [ RunTime:0.001454s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33398131 ORDER BY `unit` DESC [ RunTime:0.006109s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33398131 LIMIT 2 [ RunTime:0.001416s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33398131 ORDER BY `minOrder` ASC [ RunTime:0.003292s ]
select * from pdf where partno='3013-0-15-80-32-27-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.000716s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3013-0-15-80-32-27-04-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.001132s ]
SELECT `id` FROM `stock` WHERE `id` <> 33398131 AND `partno` = '3013-0-15-80-32-27-04-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.000504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19595757 [ RunTime:0.001298s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33398130 LIMIT 4 [ RunTime:0.003203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33398130 ORDER BY `minOrder` ASC [ RunTime:0.004699s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33398130 ORDER BY `unit` DESC [ RunTime:0.004014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33398130 LIMIT 2 [ RunTime:0.004836s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33398130 ORDER BY `minOrder` ASC [ RunTime:0.000333s ]
select * from pdf where partno='3013-0-15-01-32-27-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.004932s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3013-0-15-01-32-27-04-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.000718s ]
SELECT `id` FROM `stock` WHERE `id` <> 33398130 AND `partno` = '3013-0-15-01-32-27-04-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.000544s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19595756 [ RunTime:0.000437s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33396996 LIMIT 4 [ RunTime:0.000482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33396996 ORDER BY `minOrder` ASC [ RunTime:0.000903s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33396996 ORDER BY `unit` DESC [ RunTime:0.001673s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33396996 LIMIT 2 [ RunTime:0.005127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33396996 ORDER BY `minOrder` ASC [ RunTime:0.006016s ]
select * from pdf where partno='3013-0-15-80-32-14-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.011075s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3013-0-15-80-32-14-04-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.005078s ]
SELECT `id` FROM `stock` WHERE `id` <> 33396996 AND `partno` = '3013-0-15-80-32-14-04-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.004370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19595219 [ RunTime:0.010345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33396995 LIMIT 4 [ RunTime:0.008725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33396995 ORDER BY `minOrder` ASC [ RunTime:0.015341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33396995 ORDER BY `unit` DESC [ RunTime:0.013691s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33396995 LIMIT 2 [ RunTime:0.011392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33396995 ORDER BY `minOrder` ASC [ RunTime:0.006263s ]
select * from pdf where partno='3013-0-15-01-32-14-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.012751s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3013-0-15-01-32-14-04-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.016410s ]
SELECT `id` FROM `stock` WHERE `id` <> 33396995 AND `partno` = '3013-0-15-01-32-14-04-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.011340s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19595218 [ RunTime:0.001021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33396594 LIMIT 4 [ RunTime:0.013597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33396594 ORDER BY `minOrder` ASC [ RunTime:0.012399s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33396594 ORDER BY `unit` DESC [ RunTime:0.004495s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33396594 LIMIT 2 [ RunTime:0.000694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33396594 ORDER BY `minOrder` ASC [ RunTime:0.000388s ]
select * from pdf where partno='3013-0-15-80-32-84-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.001286s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3013-0-15-80-32-84-04-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.011048s ]
SELECT `id` FROM `stock` WHERE `id` <> 33396594 AND `partno` = '3013-0-15-80-32-84-04-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.001035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19594657 [ RunTime:0.004281s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33396592 LIMIT 4 [ RunTime:0.030516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33396592 ORDER BY `minOrder` ASC [ RunTime:0.027892s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33396592 ORDER BY `unit` DESC [ RunTime:0.015303s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33396592 LIMIT 2 [ RunTime:0.004716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33396592 ORDER BY `minOrder` ASC [ RunTime:0.001151s ]
select * from pdf where partno='3013-0-15-01-32-02-04-0' and brandshort='Mill-Max Manufacturing Corp.' limit 1 [ RunTime:0.006277s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3013-0-15-01-32-02-04-0' OR `brand` LIKE 'Mill-Max Manufacturing Corp.%' ) ) LIMIT 1 [ RunTime:0.015402s ]
SELECT `id` FROM `stock` WHERE `id` <> 33396592 AND `partno` = '3013-0-15-01-32-02-04-0' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%mill-max manufacturing corp.%' ) [ RunTime:0.049066s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19594656 [ RunTime:0.008100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33361407 LIMIT 4 [ RunTime:0.013846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33361407 ORDER BY `minOrder` ASC [ RunTime:0.009291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33361407 ORDER BY `unit` DESC [ RunTime:0.003234s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33361407 LIMIT 2 [ RunTime:0.001664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33361407 ORDER BY `minOrder` ASC [ RunTime:0.000472s ]
select * from pdf where partno='3013W6SXK99A30X' and brandshort='Amphenol CONEC' limit 1 [ RunTime:0.000906s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3013W6SXK99A30X' OR `brand` LIKE 'Amphenol CONEC%' ) ) LIMIT 1 [ RunTime:0.000703s ]
SELECT `id` FROM `stock` WHERE `id` <> 33361407 AND `partno` = '3013W6SXK99A30X' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol conec%' ) [ RunTime:0.003702s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33361345 LIMIT 4 [ RunTime:0.010657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33361345 ORDER BY `minOrder` ASC [ RunTime:0.001353s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33361345 ORDER BY `unit` DESC [ RunTime:0.000810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33361345 LIMIT 2 [ RunTime:0.002521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33361345 ORDER BY `minOrder` ASC [ RunTime:0.000445s ]
select * from pdf where partno='3013W6PXK99A60X' and brandshort='Amphenol CONEC' limit 1 [ RunTime:0.000881s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3013W6PXK99A60X' OR `brand` LIKE 'Amphenol CONEC%' ) ) LIMIT 1 [ RunTime:0.009520s ]
SELECT `id` FROM `stock` WHERE `id` <> 33361345 AND `partno` = '3013W6PXK99A60X' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol conec%' ) [ RunTime:0.003766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 33361330 LIMIT 4 [ RunTime:0.001093s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33361330 ORDER BY `minOrder` ASC [ RunTime:0.000663s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 33361330 ORDER BY `unit` DESC [ RunTime:0.004073s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 33361330 LIMIT 2 [ RunTime:0.000383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 33361330 ORDER BY `minOrder` ASC [ RunTime:0.005658s ]
select * from pdf where partno='3013W6PXK99A30X' and brandshort='Amphenol CONEC' limit 1 [ RunTime:0.000744s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '3013W6PXK99A30X' OR `brand` LIKE 'Amphenol CONEC%' ) ) LIMIT 1 [ RunTime:0.012503s ]
SELECT `id` FROM `stock` WHERE `id` <> 33361330 AND `partno` = '3013W6PXK99A30X' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol conec%' ) [ RunTime:0.001019s ]
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 '3013%' OR `brand` LIKE '3013%' ) AND `s`.`status` <> '2' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 100,20 [ RunTime:0.005555s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '3013%' OR `brand` LIKE '3013%' ) AND `s`.`status` <> '2' ) ) tmp GROUP BY `brand` [ RunTime:0.000454s ]
SELECT DISTINCT `categoryid` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '3013%' OR `brand` LIKE '3013%' ) AND `s`.`status` <> '2' ) AND `categoryid` > 0 [ RunTime:0.005963s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 643 [ RunTime:0.000289s ]