SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002691s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.11' , `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=STMM-108-01-S-D&search=1' [ RunTime:0.011063s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002304s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.012465s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002428s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.11' ) [ RunTime:0.006515s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001944s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.010541s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002683s ]
SELECT * FROM `stock_search` WHERE `partno` = 'STMM-108-01-S-D' LIMIT 1 [ RunTime:0.025166s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-29 07:13:13' WHERE `partno` = 'STMM-108-01-S-D' [ RunTime:0.008110s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.004125s ]
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 'STMM-108-01-S-D%' OR `brand` LIKE 'STMM-108-01-S-D%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011993s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001243s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12750550 LIMIT 5 [ RunTime:0.013797s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.006373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12750550 ORDER BY `minOrder` ASC [ RunTime:0.016807s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004440s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12750550 ORDER BY `unit` DESC [ RunTime:0.009014s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12750550 LIMIT 2 [ RunTime:0.008738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12750550 ORDER BY `minOrder` ASC [ RunTime:0.000840s ]
select * from pdf where partno='STMM-108-01-S-D-SM-LC-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.015590s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12749254 LIMIT 5 [ RunTime:0.007530s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12749254 ORDER BY `minOrder` ASC [ RunTime:0.006610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12749254 ORDER BY `unit` DESC [ RunTime:0.009266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12749254 LIMIT 2 [ RunTime:0.004047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12749254 ORDER BY `minOrder` ASC [ RunTime:0.002670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12748408 LIMIT 5 [ RunTime:0.028957s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12748408 ORDER BY `minOrder` ASC [ RunTime:0.012091s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12748408 ORDER BY `unit` DESC [ RunTime:0.006799s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12748408 LIMIT 2 [ RunTime:0.008379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12748408 ORDER BY `minOrder` ASC [ RunTime:0.015706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12741082 LIMIT 5 [ RunTime:0.017903s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12741082 ORDER BY `minOrder` ASC [ RunTime:0.016746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12741082 ORDER BY `unit` DESC [ RunTime:0.010597s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12741082 LIMIT 2 [ RunTime:0.007506s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12741082 ORDER BY `minOrder` ASC [ RunTime:0.003737s ]
select * from pdf where partno='STMM-108-01-S-D-SM-LC-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12740166 LIMIT 5 [ RunTime:0.002187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12740166 ORDER BY `minOrder` ASC [ RunTime:0.000759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12740166 ORDER BY `unit` DESC [ RunTime:0.023721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12740166 LIMIT 2 [ RunTime:0.015926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12740166 ORDER BY `minOrder` ASC [ RunTime:0.007479s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12739213 LIMIT 5 [ RunTime:0.029850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12739213 ORDER BY `minOrder` ASC [ RunTime:0.011254s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12739213 ORDER BY `unit` DESC [ RunTime:0.006948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12739213 LIMIT 2 [ RunTime:0.003022s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12739213 ORDER BY `minOrder` ASC [ RunTime:0.004127s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11577335 LIMIT 5 [ RunTime:0.012871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11577335 ORDER BY `minOrder` ASC [ RunTime:0.012248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11577335 ORDER BY `unit` DESC [ RunTime:0.006362s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11577335 LIMIT 2 [ RunTime:0.006557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11577335 ORDER BY `minOrder` ASC [ RunTime:0.008824s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11577317 LIMIT 5 [ RunTime:0.008682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11577317 ORDER BY `minOrder` ASC [ RunTime:0.017629s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11577317 ORDER BY `unit` DESC [ RunTime:0.010174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11577317 LIMIT 2 [ RunTime:0.014552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11577317 ORDER BY `minOrder` ASC [ RunTime:0.006872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11576707 LIMIT 5 [ RunTime:0.006463s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11576707 ORDER BY `minOrder` ASC [ RunTime:0.010796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11576707 ORDER BY `unit` DESC [ RunTime:0.008871s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11576707 LIMIT 2 [ RunTime:0.000716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11576707 ORDER BY `minOrder` ASC [ RunTime:0.004386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11575399 LIMIT 5 [ RunTime:0.004569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11575399 ORDER BY `minOrder` ASC [ RunTime:0.015824s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11575399 ORDER BY `unit` DESC [ RunTime:0.001969s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11575399 LIMIT 2 [ RunTime:0.002435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11575399 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11571813 LIMIT 5 [ RunTime:0.001563s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11571813 ORDER BY `minOrder` ASC [ RunTime:0.006389s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11571813 ORDER BY `unit` DESC [ RunTime:0.007702s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11571813 LIMIT 2 [ RunTime:0.028010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11571813 ORDER BY `minOrder` ASC [ RunTime:0.028845s ]
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 'STMM-108-01-S-D%' OR `brand` LIKE 'STMM-108-01-S-D%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.044360s ]
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 'STMM-108-01-S-D%' OR `brand` LIKE 'STMM-108-01-S-D%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.022915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52856046 LIMIT 5 [ RunTime:0.029746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52856046 ORDER BY `minOrder` ASC [ RunTime:0.017066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52856046 ORDER BY `unit` DESC [ RunTime:0.017924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52856046 LIMIT 2 [ RunTime:0.013018s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52856046 ORDER BY `minOrder` ASC [ RunTime:0.004264s ]
select * from pdf where partno='STMM-108-01-S-D-SM-LC-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006446s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002262s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'STMM-108-01-S-D-SM-LC-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.007724s ]
SELECT `id` FROM `stock` WHERE `id` <> 52856046 AND `partno` = 'STMM-108-01-S-D-SM-LC-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.021100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12750550 [ RunTime:0.034413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52854271 LIMIT 5 [ RunTime:0.002366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52854271 ORDER BY `minOrder` ASC [ RunTime:0.009121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52854271 ORDER BY `unit` DESC [ RunTime:0.016217s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52854271 LIMIT 2 [ RunTime:0.033125s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52854271 ORDER BY `minOrder` ASC [ RunTime:0.000499s ]
select * from pdf where partno='STMM-108-01-S-D-SM-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008251s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'STMM-108-01-S-D-SM-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.015632s ]
SELECT `id` FROM `stock` WHERE `id` <> 52854271 AND `partno` = 'STMM-108-01-S-D-SM-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.024378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12749254 [ RunTime:0.040670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52853912 LIMIT 5 [ RunTime:0.024677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52853912 ORDER BY `minOrder` ASC [ RunTime:0.027687s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52853912 ORDER BY `unit` DESC [ RunTime:0.003012s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52853912 LIMIT 2 [ RunTime:0.010298s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52853912 ORDER BY `minOrder` ASC [ RunTime:0.003020s ]
select * from pdf where partno='STMM-108-01-S-D-SM-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000922s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'STMM-108-01-S-D-SM-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003116s ]
SELECT `id` FROM `stock` WHERE `id` <> 52853912 AND `partno` = 'STMM-108-01-S-D-SM-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.003049s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52853037 LIMIT 5 [ RunTime:0.000654s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52853037 ORDER BY `minOrder` ASC [ RunTime:0.015168s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52853037 ORDER BY `unit` DESC [ RunTime:0.000763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52853037 LIMIT 2 [ RunTime:0.001443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52853037 ORDER BY `minOrder` ASC [ RunTime:0.009331s ]
select * from pdf where partno='STMM-108-01-S-D-SM-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009487s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'STMM-108-01-S-D-SM-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.014665s ]
SELECT `id` FROM `stock` WHERE `id` <> 52853037 AND `partno` = 'STMM-108-01-S-D-SM-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12748408 [ RunTime:0.007701s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52851912 LIMIT 5 [ RunTime:0.008299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52851912 ORDER BY `minOrder` ASC [ RunTime:0.024998s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52851912 ORDER BY `unit` DESC [ RunTime:0.004461s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52851912 LIMIT 2 [ RunTime:0.004846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52851912 ORDER BY `minOrder` ASC [ RunTime:0.018059s ]
select * from pdf where partno='STMM-108-01-S-D-SM' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001157s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'STMM-108-01-S-D-SM' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.025719s ]
SELECT `id` FROM `stock` WHERE `id` <> 52851912 AND `partno` = 'STMM-108-01-S-D-SM' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.029678s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11577335 [ RunTime:0.013334s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52848202 LIMIT 5 [ RunTime:0.007498s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52848202 ORDER BY `minOrder` ASC [ RunTime:0.016782s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52848202 ORDER BY `unit` DESC [ RunTime:0.018430s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52848202 LIMIT 2 [ RunTime:0.019239s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52848202 ORDER BY `minOrder` ASC [ RunTime:0.000347s ]
select * from pdf where partno='STMM-108-01-S-D-RA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.028525s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'STMM-108-01-S-D-RA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.012656s ]
SELECT `id` FROM `stock` WHERE `id` <> 52848202 AND `partno` = 'STMM-108-01-S-D-RA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.032662s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11577317 [ RunTime:0.020242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52847273 LIMIT 5 [ RunTime:0.018753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52847273 ORDER BY `minOrder` ASC [ RunTime:0.001484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52847273 ORDER BY `unit` DESC [ RunTime:0.011374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52847273 LIMIT 2 [ RunTime:0.004437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52847273 ORDER BY `minOrder` ASC [ RunTime:0.004848s ]
select * from pdf where partno='STMM-108-01-S-D-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004887s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'STMM-108-01-S-D-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004788s ]
SELECT `id` FROM `stock` WHERE `id` <> 52847273 AND `partno` = 'STMM-108-01-S-D-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005472s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11576707 [ RunTime:0.009661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52843879 LIMIT 5 [ RunTime:0.008702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52843879 ORDER BY `minOrder` ASC [ RunTime:0.007582s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52843879 ORDER BY `unit` DESC [ RunTime:0.008157s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52843879 LIMIT 2 [ RunTime:0.000612s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52843879 ORDER BY `minOrder` ASC [ RunTime:0.018722s ]
select * from pdf where partno='STMM-108-01-S-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004757s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'STMM-108-01-S-D' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.011621s ]
SELECT `id` FROM `stock` WHERE `id` <> 52843879 AND `partno` = 'STMM-108-01-S-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.030891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11575399 [ RunTime:0.007057s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52842792 LIMIT 5 [ RunTime:0.030357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52842792 ORDER BY `minOrder` ASC [ RunTime:0.004483s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52842792 ORDER BY `unit` DESC [ RunTime:0.000987s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52842792 LIMIT 2 [ RunTime:0.007035s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52842792 ORDER BY `minOrder` ASC [ RunTime:0.005919s ]
select * from pdf where partno='STMM-108-01-S-D-SM-LC-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011847s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'STMM-108-01-S-D-SM-LC-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.012288s ]
SELECT `id` FROM `stock` WHERE `id` <> 52842792 AND `partno` = 'STMM-108-01-S-D-SM-LC-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12741082 [ RunTime:0.004181s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52842264 LIMIT 5 [ RunTime:0.005054s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52842264 ORDER BY `minOrder` ASC [ RunTime:0.008075s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52842264 ORDER BY `unit` DESC [ RunTime:0.001019s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52842264 LIMIT 2 [ RunTime:0.008912s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52842264 ORDER BY `minOrder` ASC [ RunTime:0.011760s ]
select * from pdf where partno='STMM-108-01-S-D-SM-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.012132s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'STMM-108-01-S-D-SM-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.026777s ]
SELECT `id` FROM `stock` WHERE `id` <> 52842264 AND `partno` = 'STMM-108-01-S-D-SM-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002861s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11571813 [ RunTime:0.022497s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52841109 LIMIT 5 [ RunTime:0.011366s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52841109 ORDER BY `minOrder` ASC [ RunTime:0.021072s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52841109 ORDER BY `unit` DESC [ RunTime:0.009264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52841109 LIMIT 2 [ RunTime:0.003385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52841109 ORDER BY `minOrder` ASC [ RunTime:0.008351s ]
select * from pdf where partno='STMM-108-01-S-D-SM-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.014648s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'STMM-108-01-S-D-SM-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.044351s ]
SELECT `id` FROM `stock` WHERE `id` <> 52841109 AND `partno` = 'STMM-108-01-S-D-SM-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.012030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12740166 [ RunTime:0.023830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52839613 LIMIT 5 [ RunTime:0.019750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52839613 ORDER BY `minOrder` ASC [ RunTime:0.056069s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52839613 ORDER BY `unit` DESC [ RunTime:0.014424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52839613 LIMIT 2 [ RunTime:0.010377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52839613 ORDER BY `minOrder` ASC [ RunTime:0.008249s ]
select * from pdf where partno='STMM-108-01-S-D-SM-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006690s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'STMM-108-01-S-D-SM-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.018619s ]
SELECT `id` FROM `stock` WHERE `id` <> 52839613 AND `partno` = 'STMM-108-01-S-D-SM-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12739213 [ RunTime:0.020694s ]
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 'STMM-108-01-S-D%' OR `brand` LIKE 'STMM-108-01-S-D%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.029449s ]
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 'STMM-108-01-S-D%' OR `brand` LIKE 'STMM-108-01-S-D%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015514s ]
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 'STMM-108-01-S-D%' OR `brand` LIKE 'STMM-108-01-S-D%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010209s ]
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 'STMM-108-01-S-D%' OR `brand` LIKE 'STMM-108-01-S-D%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012485s ]
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 'STMM-108-01-S-D%' OR `brand` LIKE 'STMM-108-01-S-D%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005966s ]
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 'STMM-108-01-S-D%' OR `brand` LIKE 'STMM-108-01-S-D%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002081s ]
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 'STMM-108-01-S-D%' OR `brand` LIKE 'STMM-108-01-S-D%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016484s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'STMM-108-01-S-D%' OR `brand` LIKE 'STMM-108-01-S-D%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.001517s ]