SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003135s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.134' , `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=HCSD-10-D-04.00-01&search=1' [ RunTime:0.002207s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002274s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000518s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002553s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.134' ) [ RunTime:0.000355s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002355s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000485s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002574s ]
SELECT * FROM `stock_search` WHERE `partno` = 'HCSD-10-D-04.00-01' LIMIT 1 [ RunTime:0.010973s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-12 01:06:26' WHERE `partno` = 'HCSD-10-D-04.00-01' [ RunTime:0.005741s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002170s ]
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 'HCSD-10-D-04.00-01%' OR `brand` LIKE 'HCSD-10-D-04.00-01%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011144s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.004914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16471496 LIMIT 5 [ RunTime:0.000884s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.000938s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16471496 ORDER BY `minOrder` ASC [ RunTime:0.007463s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004955s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16471496 ORDER BY `unit` DESC [ RunTime:0.003429s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001497s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16471496 LIMIT 2 [ RunTime:0.016363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16471496 ORDER BY `minOrder` ASC [ RunTime:0.002157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16471495 LIMIT 5 [ RunTime:0.000417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16471495 ORDER BY `minOrder` ASC [ RunTime:0.000436s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16471495 ORDER BY `unit` DESC [ RunTime:0.005556s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16471495 LIMIT 2 [ RunTime:0.015449s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16471495 ORDER BY `minOrder` ASC [ RunTime:0.004603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16470409 LIMIT 5 [ RunTime:0.001967s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16470409 ORDER BY `minOrder` ASC [ RunTime:0.006633s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16470409 ORDER BY `unit` DESC [ RunTime:0.001407s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16470409 LIMIT 2 [ RunTime:0.005352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16470409 ORDER BY `minOrder` ASC [ RunTime:0.000301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16466454 LIMIT 5 [ RunTime:0.005528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16466454 ORDER BY `minOrder` ASC [ RunTime:0.000443s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16466454 ORDER BY `unit` DESC [ RunTime:0.002270s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16466454 LIMIT 2 [ RunTime:0.000474s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16466454 ORDER BY `minOrder` ASC [ RunTime:0.000869s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16465511 LIMIT 5 [ RunTime:0.005933s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16465511 ORDER BY `minOrder` ASC [ RunTime:0.003612s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16465511 ORDER BY `unit` DESC [ RunTime:0.000378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16465511 LIMIT 2 [ RunTime:0.000358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16465511 ORDER BY `minOrder` ASC [ RunTime:0.000289s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16465509 LIMIT 5 [ RunTime:0.005600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16465509 ORDER BY `minOrder` ASC [ RunTime:0.001051s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16465509 ORDER BY `unit` DESC [ RunTime:0.002308s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16465509 LIMIT 2 [ RunTime:0.000357s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16465509 ORDER BY `minOrder` ASC [ RunTime:0.001749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14478357 LIMIT 5 [ RunTime:0.003608s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14478357 ORDER BY `minOrder` ASC [ RunTime:0.000928s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14478357 ORDER BY `unit` DESC [ RunTime:0.001610s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14478357 LIMIT 2 [ RunTime:0.002295s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14478357 ORDER BY `minOrder` ASC [ RunTime:0.005388s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13616179 LIMIT 5 [ RunTime:0.001663s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13616179 ORDER BY `minOrder` ASC [ RunTime:0.001677s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13616179 ORDER BY `unit` DESC [ RunTime:0.001350s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13616179 LIMIT 2 [ RunTime:0.003649s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13616179 ORDER BY `minOrder` ASC [ RunTime:0.004035s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13615255 LIMIT 5 [ RunTime:0.017764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13615255 ORDER BY `minOrder` ASC [ RunTime:0.002893s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13615255 ORDER BY `unit` DESC [ RunTime:0.002540s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13615255 LIMIT 2 [ RunTime:0.003803s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13615255 ORDER BY `minOrder` ASC [ RunTime:0.002241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13611365 LIMIT 5 [ RunTime:0.000858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13611365 ORDER BY `minOrder` ASC [ RunTime:0.007397s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13611365 ORDER BY `unit` DESC [ RunTime:0.005858s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13611365 LIMIT 2 [ RunTime:0.001747s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13611365 ORDER BY `minOrder` ASC [ RunTime:0.005039s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13610629 LIMIT 5 [ RunTime:0.001109s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13610629 ORDER BY `minOrder` ASC [ RunTime:0.002659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13610629 ORDER BY `unit` DESC [ RunTime:0.007223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13610629 LIMIT 2 [ RunTime:0.007820s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13610629 ORDER BY `minOrder` ASC [ RunTime:0.005442s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13607302 LIMIT 5 [ RunTime:0.002251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13607302 ORDER BY `minOrder` ASC [ RunTime:0.009320s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13607302 ORDER BY `unit` DESC [ RunTime:0.005730s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13607302 LIMIT 2 [ RunTime:0.022014s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13607302 ORDER BY `minOrder` ASC [ RunTime:0.000504s ]
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 'HCSD-10-D-04.00-01%' OR `brand` LIKE 'HCSD-10-D-04.00-01%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001886s ]
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 'HCSD-10-D-04.00-01%' OR `brand` LIKE 'HCSD-10-D-04.00-01%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009864s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62306790 LIMIT 5 [ RunTime:0.000640s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62306790 ORDER BY `minOrder` ASC [ RunTime:0.005894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62306790 ORDER BY `unit` DESC [ RunTime:0.006644s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62306790 LIMIT 2 [ RunTime:0.004940s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62306790 ORDER BY `minOrder` ASC [ RunTime:0.008734s ]
select * from pdf where partno='HCSD-10-D-04.00-01-N-P10-R' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005690s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001720s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCSD-10-D-04.00-01-N-P10-R' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004025s ]
SELECT `id` FROM `stock` WHERE `id` <> 62306790 AND `partno` = 'HCSD-10-D-04.00-01-N-P10-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.007635s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62305814 LIMIT 5 [ RunTime:0.008120s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62305814 ORDER BY `minOrder` ASC [ RunTime:0.007514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62305814 ORDER BY `unit` DESC [ RunTime:0.002943s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62305814 LIMIT 2 [ RunTime:0.013705s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62305814 ORDER BY `minOrder` ASC [ RunTime:0.003276s ]
select * from pdf where partno='HCSD-10-D-04.00-01' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005406s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCSD-10-D-04.00-01' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005767s ]
SELECT `id` FROM `stock` WHERE `id` <> 62305814 AND `partno` = 'HCSD-10-D-04.00-01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16471496 [ RunTime:0.001596s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62305813 LIMIT 5 [ RunTime:0.005930s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62305813 ORDER BY `minOrder` ASC [ RunTime:0.012773s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62305813 ORDER BY `unit` DESC [ RunTime:0.007864s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62305813 LIMIT 2 [ RunTime:0.011695s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62305813 ORDER BY `minOrder` ASC [ RunTime:0.001874s ]
select * from pdf where partno='HCSD-10-D-04.00-01-N-R' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.008620s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCSD-10-D-04.00-01-N-R' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.016187s ]
SELECT `id` FROM `stock` WHERE `id` <> 62305813 AND `partno` = 'HCSD-10-D-04.00-01-N-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.017213s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16471495 [ RunTime:0.015430s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62305812 LIMIT 5 [ RunTime:0.001487s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62305812 ORDER BY `minOrder` ASC [ RunTime:0.015325s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62305812 ORDER BY `unit` DESC [ RunTime:0.005117s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62305812 LIMIT 2 [ RunTime:0.012813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62305812 ORDER BY `minOrder` ASC [ RunTime:0.006047s ]
select * from pdf where partno='HCSD-10-D-04.00-01-N' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009800s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCSD-10-D-04.00-01-N' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001590s ]
SELECT `id` FROM `stock` WHERE `id` <> 62305812 AND `partno` = 'HCSD-10-D-04.00-01-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.004589s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13616179 [ RunTime:0.010761s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62305809 LIMIT 5 [ RunTime:0.006490s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62305809 ORDER BY `minOrder` ASC [ RunTime:0.009409s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62305809 ORDER BY `unit` DESC [ RunTime:0.003186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62305809 LIMIT 2 [ RunTime:0.001108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62305809 ORDER BY `minOrder` ASC [ RunTime:0.001524s ]
select * from pdf where partno='HCSD-10-D-04.00-01-R' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003453s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCSD-10-D-04.00-01-R' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006395s ]
SELECT `id` FROM `stock` WHERE `id` <> 62305809 AND `partno` = 'HCSD-10-D-04.00-01-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14478357 [ RunTime:0.005177s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62302839 LIMIT 5 [ RunTime:0.002191s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62302839 ORDER BY `minOrder` ASC [ RunTime:0.003380s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62302839 ORDER BY `unit` DESC [ RunTime:0.000621s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62302839 LIMIT 2 [ RunTime:0.000428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62302839 ORDER BY `minOrder` ASC [ RunTime:0.001675s ]
select * from pdf where partno='HCSD-10-D-04.00-01-G' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009565s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCSD-10-D-04.00-01-G' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.017742s ]
SELECT `id` FROM `stock` WHERE `id` <> 62302839 AND `partno` = 'HCSD-10-D-04.00-01-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.006378s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13615255 [ RunTime:0.007459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62302836 LIMIT 5 [ RunTime:0.021680s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62302836 ORDER BY `minOrder` ASC [ RunTime:0.028391s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62302836 ORDER BY `unit` DESC [ RunTime:0.012058s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62302836 LIMIT 2 [ RunTime:0.025761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62302836 ORDER BY `minOrder` ASC [ RunTime:0.001785s ]
select * from pdf where partno='HCSD-10-D-04.00-01-N-G-R' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.013206s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCSD-10-D-04.00-01-N-G-R' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.007150s ]
SELECT `id` FROM `stock` WHERE `id` <> 62302836 AND `partno` = 'HCSD-10-D-04.00-01-N-G-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.027691s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16470409 [ RunTime:0.006175s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62289923 LIMIT 5 [ RunTime:0.007528s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62289923 ORDER BY `minOrder` ASC [ RunTime:0.016927s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62289923 ORDER BY `unit` DESC [ RunTime:0.019219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62289923 LIMIT 2 [ RunTime:0.022961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62289923 ORDER BY `minOrder` ASC [ RunTime:0.012155s ]
select * from pdf where partno='HCSD-10-D-04.00-01-T-N-R' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.017738s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCSD-10-D-04.00-01-T-N-R' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001184s ]
SELECT `id` FROM `stock` WHERE `id` <> 62289923 AND `partno` = 'HCSD-10-D-04.00-01-T-N-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.010674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62289888 LIMIT 5 [ RunTime:0.027560s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62289888 ORDER BY `minOrder` ASC [ RunTime:0.016445s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62289888 ORDER BY `unit` DESC [ RunTime:0.018747s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62289888 LIMIT 2 [ RunTime:0.015557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62289888 ORDER BY `minOrder` ASC [ RunTime:0.004905s ]
select * from pdf where partno='HCSD-10-D-04.00-01-T-N' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010724s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCSD-10-D-04.00-01-T-N' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.013887s ]
SELECT `id` FROM `stock` WHERE `id` <> 62289888 AND `partno` = 'HCSD-10-D-04.00-01-T-N' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.006959s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16466454 [ RunTime:0.004343s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62289887 LIMIT 5 [ RunTime:0.022744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62289887 ORDER BY `minOrder` ASC [ RunTime:0.037277s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62289887 ORDER BY `unit` DESC [ RunTime:0.042161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62289887 LIMIT 2 [ RunTime:0.023666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62289887 ORDER BY `minOrder` ASC [ RunTime:0.012469s ]
select * from pdf where partno='HCSD-10-D-04.00-01-T' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.028688s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCSD-10-D-04.00-01-T' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.023989s ]
SELECT `id` FROM `stock` WHERE `id` <> 62289887 AND `partno` = 'HCSD-10-D-04.00-01-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.050323s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13611365 [ RunTime:0.053424s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62287241 LIMIT 5 [ RunTime:0.016514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62287241 ORDER BY `minOrder` ASC [ RunTime:0.032121s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62287241 ORDER BY `unit` DESC [ RunTime:0.089256s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62287241 LIMIT 2 [ RunTime:0.046848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62287241 ORDER BY `minOrder` ASC [ RunTime:0.025325s ]
select * from pdf where partno='HCSD-10-D-04.00-01-T-N-G-RW' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.027501s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCSD-10-D-04.00-01-T-N-G-RW' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.041255s ]
SELECT `id` FROM `stock` WHERE `id` <> 62287241 AND `partno` = 'HCSD-10-D-04.00-01-T-N-G-RW' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.046954s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13610629 [ RunTime:0.017706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62287239 LIMIT 5 [ RunTime:0.043260s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62287239 ORDER BY `minOrder` ASC [ RunTime:0.030026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62287239 ORDER BY `unit` DESC [ RunTime:0.104866s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62287239 LIMIT 2 [ RunTime:0.098238s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62287239 ORDER BY `minOrder` ASC [ RunTime:0.023095s ]
select * from pdf where partno='HCSD-10-D-04.00-01-T-N-G' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.098525s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCSD-10-D-04.00-01-T-N-G' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.039631s ]
SELECT `id` FROM `stock` WHERE `id` <> 62287239 AND `partno` = 'HCSD-10-D-04.00-01-T-N-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.082629s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16465511 [ RunTime:0.057157s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62287235 LIMIT 5 [ RunTime:0.123515s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62287235 ORDER BY `minOrder` ASC [ RunTime:0.069888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62287235 ORDER BY `unit` DESC [ RunTime:0.105926s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62287235 LIMIT 2 [ RunTime:0.032999s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62287235 ORDER BY `minOrder` ASC [ RunTime:0.016671s ]
select * from pdf where partno='HCSD-10-D-04.00-01-T-G' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.063913s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCSD-10-D-04.00-01-T-G' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.066726s ]
SELECT `id` FROM `stock` WHERE `id` <> 62287235 AND `partno` = 'HCSD-10-D-04.00-01-T-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.053540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16465509 [ RunTime:0.120276s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62251843 LIMIT 5 [ RunTime:0.062746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62251843 ORDER BY `minOrder` ASC [ RunTime:0.060255s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62251843 ORDER BY `unit` DESC [ RunTime:0.057231s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62251843 LIMIT 2 [ RunTime:0.045905s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62251843 ORDER BY `minOrder` ASC [ RunTime:0.034917s ]
select * from pdf where partno='HCSD-10-D-04.00-01-N-G' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.033181s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'HCSD-10-D-04.00-01-N-G' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.058304s ]
SELECT `id` FROM `stock` WHERE `id` <> 62251843 AND `partno` = 'HCSD-10-D-04.00-01-N-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.015420s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13607302 [ RunTime:0.075158s ]
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 'HCSD-10-D-04.00-01%' OR `brand` LIKE 'HCSD-10-D-04.00-01%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.093123s ]
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 'HCSD-10-D-04.00-01%' OR `brand` LIKE 'HCSD-10-D-04.00-01%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.046307s ]
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 'HCSD-10-D-04.00-01%' OR `brand` LIKE 'HCSD-10-D-04.00-01%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.051546s ]
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 'HCSD-10-D-04.00-01%' OR `brand` LIKE 'HCSD-10-D-04.00-01%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040921s ]
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 'HCSD-10-D-04.00-01%' OR `brand` LIKE 'HCSD-10-D-04.00-01%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045435s ]
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 'HCSD-10-D-04.00-01%' OR `brand` LIKE 'HCSD-10-D-04.00-01%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016419s ]
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 'HCSD-10-D-04.00-01%' OR `brand` LIKE 'HCSD-10-D-04.00-01%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.053622s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'HCSD-10-D-04.00-01%' OR `brand` LIKE 'HCSD-10-D-04.00-01%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.033204s ]