SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003762s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.177' , `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=CES-1&search=1' [ RunTime:0.002065s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002632s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000565s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002731s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.177' ) [ RunTime:0.000694s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002420s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.004142s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002020s ]
SELECT * FROM `stock_search` WHERE `partno` = 'CES-1' LIMIT 1 [ RunTime:0.016587s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-28 09:42:57' WHERE `partno` = 'CES-1' [ RunTime:0.015164s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002390s ]
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 'CES-1%' OR `brand` LIKE 'CES-1%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.084313s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11544827 LIMIT 5 [ RunTime:0.016486s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11544827 ORDER BY `minOrder` ASC [ RunTime:0.003357s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002481s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11544827 ORDER BY `unit` DESC [ RunTime:0.000874s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.005790s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11544827 LIMIT 2 [ RunTime:0.005503s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11544827 ORDER BY `minOrder` ASC [ RunTime:0.009558s ]
select * from pdf where partno='CES-105-01-G-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12685974 LIMIT 5 [ RunTime:0.016640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12685974 ORDER BY `minOrder` ASC [ RunTime:0.009464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12685974 ORDER BY `unit` DESC [ RunTime:0.013117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12685974 LIMIT 2 [ RunTime:0.013383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12685974 ORDER BY `minOrder` ASC [ RunTime:0.006430s ]
select * from pdf where partno='CES-102-01-G-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.014402s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12669207 LIMIT 5 [ RunTime:0.016138s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12669207 ORDER BY `minOrder` ASC [ RunTime:0.007890s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12669207 ORDER BY `unit` DESC [ RunTime:0.002300s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12669207 LIMIT 2 [ RunTime:0.023319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12669207 ORDER BY `minOrder` ASC [ RunTime:0.003611s ]
select * from pdf where partno='CES-150-01-T-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.023831s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12696975 LIMIT 5 [ RunTime:0.013863s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12696975 ORDER BY `minOrder` ASC [ RunTime:0.010788s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12696975 ORDER BY `unit` DESC [ RunTime:0.008399s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12696975 LIMIT 2 [ RunTime:0.016760s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12696975 ORDER BY `minOrder` ASC [ RunTime:0.016079s ]
select * from pdf where partno='CES-103-01-L-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.035676s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12691972 LIMIT 5 [ RunTime:0.016885s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12691972 ORDER BY `minOrder` ASC [ RunTime:0.057637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12691972 ORDER BY `unit` DESC [ RunTime:0.033804s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12691972 LIMIT 2 [ RunTime:0.032684s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12691972 ORDER BY `minOrder` ASC [ RunTime:0.001994s ]
select * from pdf where partno='CES-105-01-T-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.013854s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12691373 LIMIT 5 [ RunTime:0.008728s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12691373 ORDER BY `minOrder` ASC [ RunTime:0.003270s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12691373 ORDER BY `unit` DESC [ RunTime:0.006880s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12691373 LIMIT 2 [ RunTime:0.001508s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12691373 ORDER BY `minOrder` ASC [ RunTime:0.000468s ]
select * from pdf where partno='CES-104-01-L-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12690252 LIMIT 5 [ RunTime:0.007149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12690252 ORDER BY `minOrder` ASC [ RunTime:0.008022s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12690252 ORDER BY `unit` DESC [ RunTime:0.024262s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12690252 LIMIT 2 [ RunTime:0.006394s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12690252 ORDER BY `minOrder` ASC [ RunTime:0.014404s ]
select * from pdf where partno='CES-102-01-T-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12693687 LIMIT 5 [ RunTime:0.022015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12693687 ORDER BY `minOrder` ASC [ RunTime:0.039796s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12693687 ORDER BY `unit` DESC [ RunTime:0.025469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12693687 LIMIT 2 [ RunTime:0.007015s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12693687 ORDER BY `minOrder` ASC [ RunTime:0.006647s ]
select * from pdf where partno='CES-102-01-S-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12695887 LIMIT 5 [ RunTime:0.005414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12695887 ORDER BY `minOrder` ASC [ RunTime:0.011341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12695887 ORDER BY `unit` DESC [ RunTime:0.012268s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12695887 LIMIT 2 [ RunTime:0.016963s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12695887 ORDER BY `minOrder` ASC [ RunTime:0.010560s ]
select * from pdf where partno='CES-106-01-T-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.014078s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12700237 LIMIT 5 [ RunTime:0.020835s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12700237 ORDER BY `minOrder` ASC [ RunTime:0.026007s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12700237 ORDER BY `unit` DESC [ RunTime:0.025527s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12700237 LIMIT 2 [ RunTime:0.004794s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12700237 ORDER BY `minOrder` ASC [ RunTime:0.011924s ]
select * from pdf where partno='CES-114-01-T-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.013280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12638288 LIMIT 5 [ RunTime:0.005816s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12638288 ORDER BY `minOrder` ASC [ RunTime:0.002842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12638288 ORDER BY `unit` DESC [ RunTime:0.000528s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12638288 LIMIT 2 [ RunTime:0.000385s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12638288 ORDER BY `minOrder` ASC [ RunTime:0.005449s ]
select * from pdf where partno='CES-114-01-S-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004929s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12705123 LIMIT 5 [ RunTime:0.000862s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12705123 ORDER BY `minOrder` ASC [ RunTime:0.007738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12705123 ORDER BY `unit` DESC [ RunTime:0.000815s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12705123 LIMIT 2 [ RunTime:0.008497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12705123 ORDER BY `minOrder` ASC [ RunTime:0.003378s ]
select * from pdf where partno='CES-120-01-T-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12664446 LIMIT 5 [ RunTime:0.013332s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12664446 ORDER BY `minOrder` ASC [ RunTime:0.004462s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12664446 ORDER BY `unit` DESC [ RunTime:0.000794s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12664446 LIMIT 2 [ RunTime:0.011955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12664446 ORDER BY `minOrder` ASC [ RunTime:0.003687s ]
select * from pdf where partno='CES-150-01-S-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005117s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11537378 LIMIT 5 [ RunTime:0.010363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11537378 ORDER BY `minOrder` ASC [ RunTime:0.001235s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11537378 ORDER BY `unit` DESC [ RunTime:0.000720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11537378 LIMIT 2 [ RunTime:0.004551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11537378 ORDER BY `minOrder` ASC [ RunTime:0.004851s ]
select * from pdf where partno='CES-104-01-T-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.014432s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11523723 LIMIT 5 [ RunTime:0.006955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11523723 ORDER BY `minOrder` ASC [ RunTime:0.005413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11523723 ORDER BY `unit` DESC [ RunTime:0.009048s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11523723 LIMIT 2 [ RunTime:0.006088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11523723 ORDER BY `minOrder` ASC [ RunTime:0.000548s ]
select * from pdf where partno='CES-110-01-G-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11542962 LIMIT 5 [ RunTime:0.001566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11542962 ORDER BY `minOrder` ASC [ RunTime:0.011302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11542962 ORDER BY `unit` DESC [ RunTime:0.007746s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11542962 LIMIT 2 [ RunTime:0.001263s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11542962 ORDER BY `minOrder` ASC [ RunTime:0.003948s ]
select * from pdf where partno='CES-106-01-S-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.012994s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12701323 LIMIT 5 [ RunTime:0.009873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12701323 ORDER BY `minOrder` ASC [ RunTime:0.000995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12701323 ORDER BY `unit` DESC [ RunTime:0.007926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12701323 LIMIT 2 [ RunTime:0.004124s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12701323 ORDER BY `minOrder` ASC [ RunTime:0.000477s ]
select * from pdf where partno='CES-109-01-T-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001409s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12697004 LIMIT 5 [ RunTime:0.012996s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12697004 ORDER BY `minOrder` ASC [ RunTime:0.000860s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12697004 ORDER BY `unit` DESC [ RunTime:0.003035s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12697004 LIMIT 2 [ RunTime:0.007608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12697004 ORDER BY `minOrder` ASC [ RunTime:0.000439s ]
select * from pdf where partno='CES-111-01-T-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001019s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12673010 LIMIT 5 [ RunTime:0.004380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12673010 ORDER BY `minOrder` ASC [ RunTime:0.007691s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12673010 ORDER BY `unit` DESC [ RunTime:0.003775s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12673010 LIMIT 2 [ RunTime:0.002215s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12673010 ORDER BY `minOrder` ASC [ RunTime:0.000463s ]
select * from pdf where partno='CES-150-01-T-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002115s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12697030 LIMIT 5 [ RunTime:0.001139s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12697030 ORDER BY `minOrder` ASC [ RunTime:0.010654s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12697030 ORDER BY `unit` DESC [ RunTime:0.002707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12697030 LIMIT 2 [ RunTime:0.001765s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12697030 ORDER BY `minOrder` ASC [ RunTime:0.009169s ]
select * from pdf where partno='CES-105-01-S-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004067s ]
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 'CES-1%' OR `brand` LIKE 'CES-1%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276955 LIMIT 5 [ RunTime:0.006267s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276955 ORDER BY `minOrder` ASC [ RunTime:0.005407s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276955 ORDER BY `unit` DESC [ RunTime:0.001666s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276955 LIMIT 2 [ RunTime:0.000758s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276955 ORDER BY `minOrder` ASC [ RunTime:0.000423s ]
select * from pdf where partno='ces-104-01-l-s' and brandshort='samtec' limit 1 [ RunTime:0.001452s ]
select foldpath,foldpath2,filename from pdf_file where id=1918129 limit 1 [ RunTime:0.004539s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002594s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ces-104-01-l-s' OR `brand` LIKE 'samtec%' ) ) LIMIT 1 [ RunTime:0.008691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277391 LIMIT 5 [ RunTime:0.008730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277391 ORDER BY `minOrder` ASC [ RunTime:0.002932s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277391 ORDER BY `unit` DESC [ RunTime:0.008382s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277391 LIMIT 2 [ RunTime:0.001071s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277391 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
select * from pdf where partno='ces-120-01-l-d' and brandshort='samtec' limit 1 [ RunTime:0.001260s ]
select foldpath,foldpath2,filename from pdf_file where id=1115150 limit 1 [ RunTime:0.001561s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ces-120-01-l-d' OR `brand` LIKE 'samtec%' ) ) LIMIT 1 [ RunTime:0.003870s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276956 LIMIT 5 [ RunTime:0.000725s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276956 ORDER BY `minOrder` ASC [ RunTime:0.000755s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276956 ORDER BY `unit` DESC [ RunTime:0.003474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276956 LIMIT 2 [ RunTime:0.025028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276956 ORDER BY `minOrder` ASC [ RunTime:0.011694s ]
select * from pdf where partno='ces-150-01-s-d' and brandshort='samtec' limit 1 [ RunTime:0.001666s ]
select foldpath,foldpath2,filename from pdf_file where id=1617216 limit 1 [ RunTime:0.001076s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ces-150-01-s-d' OR `brand` LIKE 'samtec%' ) ) LIMIT 1 [ RunTime:0.010397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51133522 LIMIT 5 [ RunTime:0.004193s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51133522 ORDER BY `minOrder` ASC [ RunTime:0.010645s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51133522 ORDER BY `unit` DESC [ RunTime:0.004227s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51133522 LIMIT 2 [ RunTime:0.016415s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51133522 ORDER BY `minOrder` ASC [ RunTime:0.006832s ]
select * from pdf where partno='ces-1a50' and brandshort='te connectivity / raychem' limit 1 [ RunTime:0.009558s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ces-1a50' OR `brand` LIKE 'te connectivity / raychem%' ) ) LIMIT 1 [ RunTime:0.005955s ]
SELECT `id` FROM `stock` WHERE `id` <> 51133522 AND `partno` = 'ces-1a50' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / raychem%' ) [ RunTime:0.001316s ]
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 'CES-1%' OR `brand` LIKE 'CES-1%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.047886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52889625 LIMIT 5 [ RunTime:0.008446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52889625 ORDER BY `minOrder` ASC [ RunTime:0.003948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52889625 ORDER BY `unit` DESC [ RunTime:0.001579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52889625 LIMIT 2 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52889625 ORDER BY `minOrder` ASC [ RunTime:0.000384s ]
select * from pdf where partno='CES-150-01-T-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000395s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CES-150-01-T-S' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.003134s ]
SELECT `id` FROM `stock` WHERE `id` <> 52889625 AND `partno` = 'CES-150-01-T-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12669207 [ RunTime:0.004823s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52888576 LIMIT 5 [ RunTime:0.000544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52888576 ORDER BY `minOrder` ASC [ RunTime:0.000954s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52888576 ORDER BY `unit` DESC [ RunTime:0.001201s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52888576 LIMIT 2 [ RunTime:0.002371s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52888576 ORDER BY `minOrder` ASC [ RunTime:0.000311s ]
select * from pdf where partno='CES-104-01-L-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000485s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CES-104-01-L-S' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002513s ]
SELECT `id` FROM `stock` WHERE `id` <> 52888576 AND `partno` = 'CES-104-01-L-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12691373 [ RunTime:0.002316s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52889099 LIMIT 5 [ RunTime:0.008706s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52889099 ORDER BY `minOrder` ASC [ RunTime:0.004750s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52889099 ORDER BY `unit` DESC [ RunTime:0.007144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52889099 LIMIT 2 [ RunTime:0.009870s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52889099 ORDER BY `minOrder` ASC [ RunTime:0.000610s ]
select * from pdf where partno='CES-105-01-G-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008332s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CES-105-01-G-S' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000830s ]
SELECT `id` FROM `stock` WHERE `id` <> 52889099 AND `partno` = 'CES-105-01-G-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000594s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11544827 [ RunTime:0.013414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52888736 LIMIT 5 [ RunTime:0.003096s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52888736 ORDER BY `minOrder` ASC [ RunTime:0.002250s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52888736 ORDER BY `unit` DESC [ RunTime:0.008266s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52888736 LIMIT 2 [ RunTime:0.000664s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52888736 ORDER BY `minOrder` ASC [ RunTime:0.000691s ]
select * from pdf where partno='CES-103-01-L-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000314s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CES-103-01-L-D' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000599s ]
SELECT `id` FROM `stock` WHERE `id` <> 52888736 AND `partno` = 'CES-103-01-L-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000579s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12696975 [ RunTime:0.010006s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52888484 LIMIT 5 [ RunTime:0.000699s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52888484 ORDER BY `minOrder` ASC [ RunTime:0.001631s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52888484 ORDER BY `unit` DESC [ RunTime:0.009424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52888484 LIMIT 2 [ RunTime:0.030250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52888484 ORDER BY `minOrder` ASC [ RunTime:0.015290s ]
select * from pdf where partno='CES-102-01-G-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CES-102-01-G-S' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.018810s ]
SELECT `id` FROM `stock` WHERE `id` <> 52888484 AND `partno` = 'CES-102-01-G-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.026520s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12685974 [ RunTime:0.021075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52889743 LIMIT 5 [ RunTime:0.011268s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52889743 ORDER BY `minOrder` ASC [ RunTime:0.025899s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52889743 ORDER BY `unit` DESC [ RunTime:0.028166s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52889743 LIMIT 2 [ RunTime:0.069877s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52889743 ORDER BY `minOrder` ASC [ RunTime:0.013534s ]
select * from pdf where partno='CES-108-01-G-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.019665s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CES-108-01-G-D' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.018385s ]
SELECT `id` FROM `stock` WHERE `id` <> 52889743 AND `partno` = 'CES-108-01-G-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.027624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12674263 [ RunTime:0.021728s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52889960 LIMIT 5 [ RunTime:0.035593s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52889960 ORDER BY `minOrder` ASC [ RunTime:0.074636s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52889960 ORDER BY `unit` DESC [ RunTime:0.013869s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52889960 LIMIT 2 [ RunTime:0.020954s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52889960 ORDER BY `minOrder` ASC [ RunTime:0.002076s ]
select * from pdf where partno='CES-150-01-S-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004400s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CES-150-01-S-S' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.025095s ]
SELECT `id` FROM `stock` WHERE `id` <> 52889960 AND `partno` = 'CES-150-01-S-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.056832s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12664446 [ RunTime:0.025538s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52892264 LIMIT 5 [ RunTime:0.007355s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52892264 ORDER BY `minOrder` ASC [ RunTime:0.005070s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52892264 ORDER BY `unit` DESC [ RunTime:0.004961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52892264 LIMIT 2 [ RunTime:0.009983s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52892264 ORDER BY `minOrder` ASC [ RunTime:0.000474s ]
select * from pdf where partno='CES-120-01-L-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001451s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CES-120-01-L-D' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.010839s ]
SELECT `id` FROM `stock` WHERE `id` <> 52892264 AND `partno` = 'CES-120-01-L-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.016712s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11527065 [ RunTime:0.018512s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52891692 LIMIT 5 [ RunTime:0.002218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52891692 ORDER BY `minOrder` ASC [ RunTime:0.011062s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52891692 ORDER BY `unit` DESC [ RunTime:0.010740s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52891692 LIMIT 2 [ RunTime:0.018876s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52891692 ORDER BY `minOrder` ASC [ RunTime:0.008799s ]
select * from pdf where partno='CES-110-01-G-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005041s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CES-110-01-G-S' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.012898s ]
SELECT `id` FROM `stock` WHERE `id` <> 52891692 AND `partno` = 'CES-110-01-G-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.010042s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11523723 [ RunTime:0.024842s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52890432 LIMIT 5 [ RunTime:0.008078s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52890432 ORDER BY `minOrder` ASC [ RunTime:0.014820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52890432 ORDER BY `unit` DESC [ RunTime:0.010710s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52890432 LIMIT 2 [ RunTime:0.011097s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52890432 ORDER BY `minOrder` ASC [ RunTime:0.010827s ]
select * from pdf where partno='CES-105-01-L-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009946s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CES-105-01-L-S' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.019896s ]
SELECT `id` FROM `stock` WHERE `id` <> 52890432 AND `partno` = 'CES-105-01-L-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.012851s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11520704 [ RunTime:0.031971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52913438 LIMIT 5 [ RunTime:0.035667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52913438 ORDER BY `minOrder` ASC [ RunTime:0.086771s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52913438 ORDER BY `unit` DESC [ RunTime:0.022105s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52913438 LIMIT 2 [ RunTime:0.026672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52913438 ORDER BY `minOrder` ASC [ RunTime:0.002556s ]
select * from pdf where partno='CES-102-01-F-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.019806s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CES-102-01-F-D' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.012421s ]
SELECT `id` FROM `stock` WHERE `id` <> 52913438 AND `partno` = 'CES-102-01-F-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.049738s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12667880 [ RunTime:0.016283s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52889256 LIMIT 5 [ RunTime:0.009627s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52889256 ORDER BY `minOrder` ASC [ RunTime:0.023291s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52889256 ORDER BY `unit` DESC [ RunTime:0.026959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52889256 LIMIT 2 [ RunTime:0.024036s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52889256 ORDER BY `minOrder` ASC [ RunTime:0.010056s ]
select * from pdf where partno='CES-107-01-G-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.031126s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CES-107-01-G-S' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009026s ]
SELECT `id` FROM `stock` WHERE `id` <> 52889256 AND `partno` = 'CES-107-01-G-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.008668s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11523368 [ RunTime:0.029100s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52913466 LIMIT 5 [ RunTime:0.016377s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52913466 ORDER BY `minOrder` ASC [ RunTime:0.015298s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52913466 ORDER BY `unit` DESC [ RunTime:0.008200s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52913466 LIMIT 2 [ RunTime:0.016010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52913466 ORDER BY `minOrder` ASC [ RunTime:0.027025s ]
select * from pdf where partno='CES-103-02-L-S-RA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CES-103-02-L-S-RA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.021327s ]
SELECT `id` FROM `stock` WHERE `id` <> 52913466 AND `partno` = 'CES-103-02-L-S-RA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.016621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11521534 [ RunTime:0.037975s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52891513 LIMIT 5 [ RunTime:0.016750s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52891513 ORDER BY `minOrder` ASC [ RunTime:0.010774s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52891513 ORDER BY `unit` DESC [ RunTime:0.022697s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52891513 LIMIT 2 [ RunTime:0.006074s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52891513 ORDER BY `minOrder` ASC [ RunTime:0.005893s ]
select * from pdf where partno='CES-109-01-G-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005778s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CES-109-01-G-S' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.026633s ]
SELECT `id` FROM `stock` WHERE `id` <> 52891513 AND `partno` = 'CES-109-01-G-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.051978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12662906 [ RunTime:0.026779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52890583 LIMIT 5 [ RunTime:0.033026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52890583 ORDER BY `minOrder` ASC [ RunTime:0.087650s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52890583 ORDER BY `unit` DESC [ RunTime:0.025297s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52890583 LIMIT 2 [ RunTime:0.020657s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52890583 ORDER BY `minOrder` ASC [ RunTime:0.023502s ]
select * from pdf where partno='CES-106-01-L-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.031303s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CES-106-01-L-S' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.059451s ]
SELECT `id` FROM `stock` WHERE `id` <> 52890583 AND `partno` = 'CES-106-01-L-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.019133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52889663 LIMIT 5 [ RunTime:0.042331s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52889663 ORDER BY `minOrder` ASC [ RunTime:0.046047s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52889663 ORDER BY `unit` DESC [ RunTime:0.047872s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52889663 LIMIT 2 [ RunTime:0.008590s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52889663 ORDER BY `minOrder` ASC [ RunTime:0.042482s ]
select * from pdf where partno='CES-120-01-L-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.052421s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CES-120-01-L-S' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.025233s ]
SELECT `id` FROM `stock` WHERE `id` <> 52889663 AND `partno` = 'CES-120-01-L-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.038279s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11517590 [ RunTime:0.036119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52889864 LIMIT 5 [ RunTime:0.009280s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52889864 ORDER BY `minOrder` ASC [ RunTime:0.056757s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52889864 ORDER BY `unit` DESC [ RunTime:0.040396s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52889864 LIMIT 2 [ RunTime:0.020510s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52889864 ORDER BY `minOrder` ASC [ RunTime:0.038050s ]
select * from pdf where partno='CES-124-01-G-S' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.038291s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CES-124-01-G-S' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.024879s ]
SELECT `id` FROM `stock` WHERE `id` <> 52889864 AND `partno` = 'CES-124-01-G-S' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.023484s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12677346 [ RunTime:0.036648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52889885 LIMIT 5 [ RunTime:0.030040s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52889885 ORDER BY `minOrder` ASC [ RunTime:0.087522s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52889885 ORDER BY `unit` DESC [ RunTime:0.025876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52889885 LIMIT 2 [ RunTime:0.025208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52889885 ORDER BY `minOrder` ASC [ RunTime:0.003284s ]
select * from pdf where partno='CES-150-01-T-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003817s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CES-150-01-T-D' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.045745s ]
SELECT `id` FROM `stock` WHERE `id` <> 52889885 AND `partno` = 'CES-150-01-T-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.038997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12673010 [ RunTime:0.037581s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52913484 LIMIT 5 [ RunTime:0.025936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52913484 ORDER BY `minOrder` ASC [ RunTime:0.042112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52913484 ORDER BY `unit` DESC [ RunTime:0.080330s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52913484 LIMIT 2 [ RunTime:0.088348s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52913484 ORDER BY `minOrder` ASC [ RunTime:0.037088s ]
select * from pdf where partno='CES-102-02-G-S-RA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.073006s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CES-102-02-G-S-RA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.023187s ]
SELECT `id` FROM `stock` WHERE `id` <> 52913484 AND `partno` = 'CES-102-02-G-S-RA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.053369s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11520770 [ RunTime:0.041566s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52891974 LIMIT 5 [ RunTime:0.113738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52891974 ORDER BY `minOrder` ASC [ RunTime:0.065498s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52891974 ORDER BY `unit` DESC [ RunTime:0.028833s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52891974 LIMIT 2 [ RunTime:0.023178s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52891974 ORDER BY `minOrder` ASC [ RunTime:0.007476s ]
select * from pdf where partno='CES-107-01-G-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.036592s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CES-107-01-G-D' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.047587s ]
SELECT `id` FROM `stock` WHERE `id` <> 52891974 AND `partno` = 'CES-107-01-G-D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.015615s ]
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 'CES-1%' OR `brand` LIKE 'CES-1%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039949s ]
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 'CES-1%' OR `brand` LIKE 'CES-1%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.067719s ]
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 'CES-1%' OR `brand` LIKE 'CES-1%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.024345s ]
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 'CES-1%' OR `brand` LIKE 'CES-1%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.043334s ]
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 'CES-1%' OR `brand` LIKE 'CES-1%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021536s ]
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 'CES-1%' OR `brand` LIKE 'CES-1%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.082815s ]
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 'CES-1%' OR `brand` LIKE 'CES-1%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.064728s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'CES-1%' OR `brand` LIKE 'CES-1%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.065400s ]