SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001848s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.72' , `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=clm-107-02-f-d&search=1' [ RunTime:0.012220s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002232s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.026596s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.003683s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.72' ) [ RunTime:0.010256s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002761s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.031917s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001999s ]
SELECT * FROM `stock_search` WHERE `partno` = 'clm-107-02-f-d' LIMIT 1 [ RunTime:0.016137s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-08-08 20:02:41' WHERE `partno` = 'clm-107-02-f-d' [ RunTime:0.021080s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002519s ]
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 'clm-107-02-f-d%' OR `brand` LIKE 'clm-107-02-f-d%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.045406s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.002363s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11524124 LIMIT 5 [ RunTime:0.018354s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.011587s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11524124 ORDER BY `minOrder` ASC [ RunTime:0.022598s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.004117s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11524124 ORDER BY `unit` DESC [ RunTime:0.009325s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.004056s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11524124 LIMIT 2 [ RunTime:0.017063s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11524124 ORDER BY `minOrder` ASC [ RunTime:0.008225s ]
select * from pdf where partno='CLM-107-02-F-D-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12682839 LIMIT 5 [ RunTime:0.013779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12682839 ORDER BY `minOrder` ASC [ RunTime:0.018501s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12682839 ORDER BY `unit` DESC [ RunTime:0.013853s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12682839 LIMIT 2 [ RunTime:0.005151s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12682839 ORDER BY `minOrder` ASC [ RunTime:0.012670s ]
select * from pdf where partno='CLM-107-02-F-D-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002757s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12662414 LIMIT 5 [ RunTime:0.013893s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12662414 ORDER BY `minOrder` ASC [ RunTime:0.015193s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12662414 ORDER BY `unit` DESC [ RunTime:0.000721s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12662414 LIMIT 2 [ RunTime:0.003736s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12662414 ORDER BY `minOrder` ASC [ RunTime:0.004060s ]
select * from pdf where partno='CLM-107-02-F-D' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001376s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12667131 LIMIT 5 [ RunTime:0.005172s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12667131 ORDER BY `minOrder` ASC [ RunTime:0.020689s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12667131 ORDER BY `unit` DESC [ RunTime:0.003264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12667131 LIMIT 2 [ RunTime:0.000655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12667131 ORDER BY `minOrder` ASC [ RunTime:0.000377s ]
select * from pdf where partno='CLM-107-02-F-D-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.005969s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12707582 LIMIT 5 [ RunTime:0.010595s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12707582 ORDER BY `minOrder` ASC [ RunTime:0.018551s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12707582 ORDER BY `unit` DESC [ RunTime:0.000737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12707582 LIMIT 2 [ RunTime:0.001901s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12707582 ORDER BY `minOrder` ASC [ RunTime:0.003907s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12706959 LIMIT 5 [ RunTime:0.006792s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12706959 ORDER BY `minOrder` ASC [ RunTime:0.013666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12706959 ORDER BY `unit` DESC [ RunTime:0.016906s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12706959 LIMIT 2 [ RunTime:0.009823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12706959 ORDER BY `minOrder` ASC [ RunTime:0.007319s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12685506 LIMIT 5 [ RunTime:0.013068s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12685506 ORDER BY `minOrder` ASC [ RunTime:0.004170s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12685506 ORDER BY `unit` DESC [ RunTime:0.004500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12685506 LIMIT 2 [ RunTime:0.002976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12685506 ORDER BY `minOrder` ASC [ RunTime:0.010178s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12684203 LIMIT 5 [ RunTime:0.015266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12684203 ORDER BY `minOrder` ASC [ RunTime:0.009129s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12684203 ORDER BY `unit` DESC [ RunTime:0.007067s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12684203 LIMIT 2 [ RunTime:0.019697s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12684203 ORDER BY `minOrder` ASC [ RunTime:0.009806s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12681812 LIMIT 5 [ RunTime:0.015476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12681812 ORDER BY `minOrder` ASC [ RunTime:0.001752s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12681812 ORDER BY `unit` DESC [ RunTime:0.000554s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12681812 LIMIT 2 [ RunTime:0.000480s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12681812 ORDER BY `minOrder` ASC [ RunTime:0.003202s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12679703 LIMIT 5 [ RunTime:0.005588s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12679703 ORDER BY `minOrder` ASC [ RunTime:0.010148s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12679703 ORDER BY `unit` DESC [ RunTime:0.012664s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12679703 LIMIT 2 [ RunTime:0.002992s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12679703 ORDER BY `minOrder` ASC [ RunTime:0.003889s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12633654 LIMIT 5 [ RunTime:0.008025s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12633654 ORDER BY `minOrder` ASC [ RunTime:0.003658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12633654 ORDER BY `unit` DESC [ RunTime:0.010931s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12633654 LIMIT 2 [ RunTime:0.014964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12633654 ORDER BY `minOrder` ASC [ RunTime:0.003763s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11533129 LIMIT 5 [ RunTime:0.002086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11533129 ORDER BY `minOrder` ASC [ RunTime:0.000514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11533129 ORDER BY `unit` DESC [ RunTime:0.000428s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11533129 LIMIT 2 [ RunTime:0.003550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11533129 ORDER BY `minOrder` ASC [ RunTime:0.007061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11532503 LIMIT 5 [ RunTime:0.009601s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11532503 ORDER BY `minOrder` ASC [ RunTime:0.022006s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11532503 ORDER BY `unit` DESC [ RunTime:0.042533s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11532503 LIMIT 2 [ RunTime:0.001730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11532503 ORDER BY `minOrder` ASC [ RunTime:0.000329s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11530618 LIMIT 5 [ RunTime:0.001621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11530618 ORDER BY `minOrder` ASC [ RunTime:0.018126s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11530618 ORDER BY `unit` DESC [ RunTime:0.036768s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11530618 LIMIT 2 [ RunTime:0.020429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11530618 ORDER BY `minOrder` ASC [ RunTime:0.008839s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11518064 LIMIT 5 [ RunTime:0.017700s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11518064 ORDER BY `minOrder` ASC [ RunTime:0.011747s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11518064 ORDER BY `unit` DESC [ RunTime:0.028976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11518064 LIMIT 2 [ RunTime:0.025321s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11518064 ORDER BY `minOrder` ASC [ RunTime:0.009298s ]
select * from pdf where partno='CLM-107-02-F-D-A-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.014733s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11513225 LIMIT 5 [ RunTime:0.022570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11513225 ORDER BY `minOrder` ASC [ RunTime:0.018267s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11513225 ORDER BY `unit` DESC [ RunTime:0.029222s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11513225 LIMIT 2 [ RunTime:0.021635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11513225 ORDER BY `minOrder` ASC [ RunTime:0.015909s ]
select * from pdf where partno='CLM-107-02-F-D-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.022361s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11511417 LIMIT 5 [ RunTime:0.012086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11511417 ORDER BY `minOrder` ASC [ RunTime:0.013643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11511417 ORDER BY `unit` DESC [ RunTime:0.015867s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11511417 LIMIT 2 [ RunTime:0.024201s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11511417 ORDER BY `minOrder` ASC [ RunTime:0.011514s ]
select * from pdf where partno='CLM-107-02-F-D-PA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.019944s ]
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 'clm-107-02-f-d%' OR `brand` LIKE 'clm-107-02-f-d%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.036102s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32268854 LIMIT 5 [ RunTime:0.020380s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268854 ORDER BY `minOrder` ASC [ RunTime:0.014484s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32268854 ORDER BY `unit` DESC [ RunTime:0.037122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32268854 LIMIT 2 [ RunTime:0.022602s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268854 ORDER BY `minOrder` ASC [ RunTime:0.022010s ]
select * from pdf where partno='clm-107-02-f-d-tr' and brandshort='samtec' limit 1 [ RunTime:0.041040s ]
select foldpath,foldpath2,filename from pdf_file where id=1918363 limit 1 [ RunTime:0.038585s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001580s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'clm-107-02-f-d-tr' OR `brand` LIKE 'samtec%' ) ) LIMIT 1 [ RunTime:0.019888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32268703 LIMIT 5 [ RunTime:0.079666s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268703 ORDER BY `minOrder` ASC [ RunTime:0.057705s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32268703 ORDER BY `unit` DESC [ RunTime:0.074694s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32268703 LIMIT 2 [ RunTime:0.058884s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268703 ORDER BY `minOrder` ASC [ RunTime:0.010590s ]
select * from pdf where partno='clm-107-02-f-d' and brandshort='samtec' limit 1 [ RunTime:0.030868s ]
select foldpath,foldpath2,filename from pdf_file where id=1492507 limit 1 [ RunTime:0.033055s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'clm-107-02-f-d' OR `brand` LIKE 'samtec%' ) ) LIMIT 1 [ RunTime:0.074798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32268648 LIMIT 5 [ RunTime:0.047716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268648 ORDER BY `minOrder` ASC [ RunTime:0.019319s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32268648 ORDER BY `unit` DESC [ RunTime:0.008648s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32268648 LIMIT 2 [ RunTime:0.044738s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32268648 ORDER BY `minOrder` ASC [ RunTime:0.020778s ]
select * from pdf where partno='clm-107-02-f-d-k-tr' and brandshort='samtec' limit 1 [ RunTime:0.001517s ]
select foldpath,foldpath2,filename from pdf_file where id=1250370 limit 1 [ RunTime:0.024929s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'clm-107-02-f-d-k-tr' OR `brand` LIKE 'samtec%' ) ) LIMIT 1 [ RunTime:0.021820s ]
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 'clm-107-02-f-d%' OR `brand` LIKE 'clm-107-02-f-d%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59752411 LIMIT 5 [ RunTime:0.012932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59752411 ORDER BY `minOrder` ASC [ RunTime:0.014855s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59752411 ORDER BY `unit` DESC [ RunTime:0.027415s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59752411 LIMIT 2 [ RunTime:0.016228s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59752411 ORDER BY `minOrder` ASC [ RunTime:0.014065s ]
select * from pdf where partno='CLM-107-02-F-D-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003962s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-107-02-F-D-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.010132s ]
SELECT `id` FROM `stock` WHERE `id` <> 59752411 AND `partno` = 'CLM-107-02-F-D-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.017082s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11524124 [ RunTime:0.023108s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59750428 LIMIT 5 [ RunTime:0.021702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59750428 ORDER BY `minOrder` ASC [ RunTime:0.025468s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59750428 ORDER BY `unit` DESC [ RunTime:0.010080s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59750428 LIMIT 2 [ RunTime:0.018131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59750428 ORDER BY `minOrder` ASC [ RunTime:0.000730s ]
select * from pdf where partno='CLM-107-02-F-D-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.018604s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-107-02-F-D-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.027052s ]
SELECT `id` FROM `stock` WHERE `id` <> 59750428 AND `partno` = 'CLM-107-02-F-D-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.036265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59750378 LIMIT 5 [ RunTime:0.004643s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59750378 ORDER BY `minOrder` ASC [ RunTime:0.027962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59750378 ORDER BY `unit` DESC [ RunTime:0.024631s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59750378 LIMIT 2 [ RunTime:0.057980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59750378 ORDER BY `minOrder` ASC [ RunTime:0.008883s ]
select * from pdf where partno='CLM-107-02-F-D-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.019935s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-107-02-F-D-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.066591s ]
SELECT `id` FROM `stock` WHERE `id` <> 59750378 AND `partno` = 'CLM-107-02-F-D-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.023914s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12682839 [ RunTime:0.042762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59754398 LIMIT 5 [ RunTime:0.049010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59754398 ORDER BY `minOrder` ASC [ RunTime:0.031372s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59754398 ORDER BY `unit` DESC [ RunTime:0.035106s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59754398 LIMIT 2 [ RunTime:0.032981s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59754398 ORDER BY `minOrder` ASC [ RunTime:0.008884s ]
select * from pdf where partno='CLM-107-02-F-D-BE' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.025919s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-107-02-F-D-BE' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.015402s ]
SELECT `id` FROM `stock` WHERE `id` <> 59754398 AND `partno` = 'CLM-107-02-F-D-BE' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.016731s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59774899 LIMIT 5 [ RunTime:0.033754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59774899 ORDER BY `minOrder` ASC [ RunTime:0.015651s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59774899 ORDER BY `unit` DESC [ RunTime:0.012553s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59774899 LIMIT 2 [ RunTime:0.016753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59774899 ORDER BY `minOrder` ASC [ RunTime:0.016603s ]
select * from pdf where partno='CLM-107-02-F-D-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.013698s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-107-02-F-D-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.015069s ]
SELECT `id` FROM `stock` WHERE `id` <> 59774899 AND `partno` = 'CLM-107-02-F-D-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.019398s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12667131 [ RunTime:0.013223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59856764 LIMIT 5 [ RunTime:0.023405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59856764 ORDER BY `minOrder` ASC [ RunTime:0.048288s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59856764 ORDER BY `unit` DESC [ RunTime:0.043561s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59856764 LIMIT 2 [ RunTime:0.037340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59856764 ORDER BY `minOrder` ASC [ RunTime:0.018379s ]
select * from pdf where partno='CLM-107-02-F-D-BE-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.054398s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-107-02-F-D-BE-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.016779s ]
SELECT `id` FROM `stock` WHERE `id` <> 59856764 AND `partno` = 'CLM-107-02-F-D-BE-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.029584s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59855870 LIMIT 5 [ RunTime:0.025637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59855870 ORDER BY `minOrder` ASC [ RunTime:0.035832s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59855870 ORDER BY `unit` DESC [ RunTime:0.041192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59855870 LIMIT 2 [ RunTime:0.074288s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59855870 ORDER BY `minOrder` ASC [ RunTime:0.046084s ]
select * from pdf where partno='CLM-107-02-F-D-BE-A-PA-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.041350s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-107-02-F-D-BE-A-PA-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.026022s ]
SELECT `id` FROM `stock` WHERE `id` <> 59855870 AND `partno` = 'CLM-107-02-F-D-BE-A-PA-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.030133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59854857 LIMIT 5 [ RunTime:0.030251s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59854857 ORDER BY `minOrder` ASC [ RunTime:0.049806s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59854857 ORDER BY `unit` DESC [ RunTime:0.049966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59854857 LIMIT 2 [ RunTime:0.074840s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59854857 ORDER BY `minOrder` ASC [ RunTime:0.013607s ]
select * from pdf where partno='CLM-107-02-F-D-BE-A-PA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.061932s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-107-02-F-D-BE-A-PA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.018787s ]
SELECT `id` FROM `stock` WHERE `id` <> 59854857 AND `partno` = 'CLM-107-02-F-D-BE-A-PA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.018228s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12633654 [ RunTime:0.075567s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59854477 LIMIT 5 [ RunTime:0.021539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59854477 ORDER BY `minOrder` ASC [ RunTime:0.048035s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59854477 ORDER BY `unit` DESC [ RunTime:0.043908s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59854477 LIMIT 2 [ RunTime:0.055519s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59854477 ORDER BY `minOrder` ASC [ RunTime:0.041304s ]
select * from pdf where partno='CLM-107-02-F-D-BE-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.035978s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-107-02-F-D-BE-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.043313s ]
SELECT `id` FROM `stock` WHERE `id` <> 59854477 AND `partno` = 'CLM-107-02-F-D-BE-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.024180s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59853558 LIMIT 5 [ RunTime:0.029157s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59853558 ORDER BY `minOrder` ASC [ RunTime:0.016734s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59853558 ORDER BY `unit` DESC [ RunTime:0.053367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59853558 LIMIT 2 [ RunTime:0.043955s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59853558 ORDER BY `minOrder` ASC [ RunTime:0.036719s ]
select * from pdf where partno='CLM-107-02-F-D-BE-A-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.095110s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-107-02-F-D-BE-A-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.026103s ]
SELECT `id` FROM `stock` WHERE `id` <> 59853558 AND `partno` = 'CLM-107-02-F-D-BE-A-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.065621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12707582 [ RunTime:0.043696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59853295 LIMIT 5 [ RunTime:0.019257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59853295 ORDER BY `minOrder` ASC [ RunTime:0.020356s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59853295 ORDER BY `unit` DESC [ RunTime:0.055378s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59853295 LIMIT 2 [ RunTime:0.011205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59853295 ORDER BY `minOrder` ASC [ RunTime:0.009757s ]
select * from pdf where partno='CLM-107-02-F-D-A-PA-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.017336s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-107-02-F-D-A-PA-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.031287s ]
SELECT `id` FROM `stock` WHERE `id` <> 59853295 AND `partno` = 'CLM-107-02-F-D-A-PA-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.017898s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59852173 LIMIT 5 [ RunTime:0.014926s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59852173 ORDER BY `minOrder` ASC [ RunTime:0.050230s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59852173 ORDER BY `unit` DESC [ RunTime:0.016386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59852173 LIMIT 2 [ RunTime:0.014256s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59852173 ORDER BY `minOrder` ASC [ RunTime:0.002959s ]
select * from pdf where partno='CLM-107-02-F-D-A-PA' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.026454s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-107-02-F-D-A-PA' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.019011s ]
SELECT `id` FROM `stock` WHERE `id` <> 59852173 AND `partno` = 'CLM-107-02-F-D-A-PA' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.010190s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12706959 [ RunTime:0.019689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59852074 LIMIT 5 [ RunTime:0.028753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59852074 ORDER BY `minOrder` ASC [ RunTime:0.067321s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59852074 ORDER BY `unit` DESC [ RunTime:0.055063s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59852074 LIMIT 2 [ RunTime:0.057028s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59852074 ORDER BY `minOrder` ASC [ RunTime:0.001883s ]
select * from pdf where partno='CLM-107-02-F-D-BE-PA-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.045537s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-107-02-F-D-BE-PA-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.019735s ]
SELECT `id` FROM `stock` WHERE `id` <> 59852074 AND `partno` = 'CLM-107-02-F-D-BE-PA-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.077385s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59831161 LIMIT 5 [ RunTime:0.016592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59831161 ORDER BY `minOrder` ASC [ RunTime:0.053853s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59831161 ORDER BY `unit` DESC [ RunTime:0.055515s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59831161 LIMIT 2 [ RunTime:0.044911s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59831161 ORDER BY `minOrder` ASC [ RunTime:0.002496s ]
select * from pdf where partno='CLM-107-02-F-D-A-P-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.048677s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-107-02-F-D-A-P-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.026640s ]
SELECT `id` FROM `stock` WHERE `id` <> 59831161 AND `partno` = 'CLM-107-02-F-D-A-P-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.046960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59829332 LIMIT 5 [ RunTime:0.059819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59829332 ORDER BY `minOrder` ASC [ RunTime:0.051476s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59829332 ORDER BY `unit` DESC [ RunTime:0.078714s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59829332 LIMIT 2 [ RunTime:0.069670s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59829332 ORDER BY `minOrder` ASC [ RunTime:0.014929s ]
select * from pdf where partno='CLM-107-02-F-D-A-K-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.034860s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-107-02-F-D-A-K-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.030859s ]
SELECT `id` FROM `stock` WHERE `id` <> 59829332 AND `partno` = 'CLM-107-02-F-D-A-K-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.024040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59829173 LIMIT 5 [ RunTime:0.031679s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59829173 ORDER BY `minOrder` ASC [ RunTime:0.025950s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59829173 ORDER BY `unit` DESC [ RunTime:0.019312s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59829173 LIMIT 2 [ RunTime:0.018936s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59829173 ORDER BY `minOrder` ASC [ RunTime:0.000983s ]
select * from pdf where partno='CLM-107-02-F-D-PA-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.054097s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-107-02-F-D-PA-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.036122s ]
SELECT `id` FROM `stock` WHERE `id` <> 59829173 AND `partno` = 'CLM-107-02-F-D-PA-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.037116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59823158 LIMIT 5 [ RunTime:0.079397s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59823158 ORDER BY `minOrder` ASC [ RunTime:0.025828s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59823158 ORDER BY `unit` DESC [ RunTime:0.031136s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59823158 LIMIT 2 [ RunTime:0.017551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59823158 ORDER BY `minOrder` ASC [ RunTime:0.014082s ]
select * from pdf where partno='CLM-107-02-F-D-BE-P-FR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.032720s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-107-02-F-D-BE-P-FR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.014593s ]
SELECT `id` FROM `stock` WHERE `id` <> 59823158 AND `partno` = 'CLM-107-02-F-D-BE-P-FR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.022080s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59814494 LIMIT 5 [ RunTime:0.006245s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59814494 ORDER BY `minOrder` ASC [ RunTime:0.002347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59814494 ORDER BY `unit` DESC [ RunTime:0.015605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59814494 LIMIT 2 [ RunTime:0.009784s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59814494 ORDER BY `minOrder` ASC [ RunTime:0.020589s ]
select * from pdf where partno='CLM-107-02-F-D-BE-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.040494s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-107-02-F-D-BE-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009715s ]
SELECT `id` FROM `stock` WHERE `id` <> 59814494 AND `partno` = 'CLM-107-02-F-D-BE-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005998s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11533129 [ RunTime:0.009837s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59812319 LIMIT 5 [ RunTime:0.003785s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59812319 ORDER BY `minOrder` ASC [ RunTime:0.005559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59812319 ORDER BY `unit` DESC [ RunTime:0.000593s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59812319 LIMIT 2 [ RunTime:0.011990s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59812319 ORDER BY `minOrder` ASC [ RunTime:0.006233s ]
select * from pdf where partno='CLM-107-02-F-D-BE-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001710s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-107-02-F-D-BE-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001243s ]
SELECT `id` FROM `stock` WHERE `id` <> 59812319 AND `partno` = 'CLM-107-02-F-D-BE-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002143s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11532503 [ RunTime:0.001805s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59811670 LIMIT 5 [ RunTime:0.001731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59811670 ORDER BY `minOrder` ASC [ RunTime:0.012364s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59811670 ORDER BY `unit` DESC [ RunTime:0.003181s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59811670 LIMIT 2 [ RunTime:0.000681s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59811670 ORDER BY `minOrder` ASC [ RunTime:0.004183s ]
select * from pdf where partno='CLM-107-02-F-D-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011117s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CLM-107-02-F-D-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.013419s ]
SELECT `id` FROM `stock` WHERE `id` <> 59811670 AND `partno` = 'CLM-107-02-F-D-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.010775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12684203 [ RunTime:0.000634s ]
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 'clm-107-02-f-d%' OR `brand` LIKE 'clm-107-02-f-d%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.028766s ]
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 'clm-107-02-f-d%' OR `brand` LIKE 'clm-107-02-f-d%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015833s ]
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 'clm-107-02-f-d%' OR `brand` LIKE 'clm-107-02-f-d%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011105s ]
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 'clm-107-02-f-d%' OR `brand` LIKE 'clm-107-02-f-d%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007966s ]
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 'clm-107-02-f-d%' OR `brand` LIKE 'clm-107-02-f-d%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.015207s ]
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 'clm-107-02-f-d%' OR `brand` LIKE 'clm-107-02-f-d%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.032170s ]
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 'clm-107-02-f-d%' OR `brand` LIKE 'clm-107-02-f-d%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.027818s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'clm-107-02-f-d%' OR `brand` LIKE 'clm-107-02-f-d%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.041197s ]