SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002852s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.227' , `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=SSM-105-S-DV&search=1' [ RunTime:0.003687s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002311s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.005543s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002683s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.227' ) [ RunTime:0.000712s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002100s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002068s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002733s ]
SELECT * FROM `stock_search` WHERE `partno` = 'SSM-105-S-DV' LIMIT 1 [ RunTime:0.024077s ]
UPDATE `stock_search` SET `count` = 3 , `updatetime` = '2026-07-27 13:38:30' WHERE `partno` = 'SSM-105-S-DV' [ RunTime:0.022000s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002889s ]
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 'SSM-105-S-DV%' OR `brand` LIKE 'SSM-105-S-DV%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.059447s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.021024s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12684927 LIMIT 5 [ RunTime:0.031025s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002516s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12684927 ORDER BY `minOrder` ASC [ RunTime:0.061272s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002652s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12684927 ORDER BY `unit` DESC [ RunTime:0.037132s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.006890s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12684927 LIMIT 2 [ RunTime:0.089917s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12684927 ORDER BY `minOrder` ASC [ RunTime:0.060285s ]
select * from pdf where partno='SSM-105-S-DV-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.035380s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12683910 LIMIT 5 [ RunTime:0.043720s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12683910 ORDER BY `minOrder` ASC [ RunTime:0.049104s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12683910 ORDER BY `unit` DESC [ RunTime:0.059081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12683910 LIMIT 2 [ RunTime:0.117972s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12683910 ORDER BY `minOrder` ASC [ RunTime:0.027162s ]
select * from pdf where partno='SSM-105-S-DV-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.046618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12684431 LIMIT 5 [ RunTime:0.098249s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12684431 ORDER BY `minOrder` ASC [ RunTime:0.080040s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12684431 ORDER BY `unit` DESC [ RunTime:0.134161s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12684431 LIMIT 2 [ RunTime:0.097945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12684431 ORDER BY `minOrder` ASC [ RunTime:0.084419s ]
select * from pdf where partno='SSM-105-S-DV-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.095807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11500389 LIMIT 5 [ RunTime:0.110615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11500389 ORDER BY `minOrder` ASC [ RunTime:0.059635s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11500389 ORDER BY `unit` DESC [ RunTime:0.097301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11500389 LIMIT 2 [ RunTime:0.055570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11500389 ORDER BY `minOrder` ASC [ RunTime:0.076288s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12683881 LIMIT 5 [ RunTime:0.058052s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12683881 ORDER BY `minOrder` ASC [ RunTime:0.160394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12683881 ORDER BY `unit` DESC [ RunTime:0.126537s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12683881 LIMIT 2 [ RunTime:0.130336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12683881 ORDER BY `minOrder` ASC [ RunTime:0.034745s ]
select * from pdf where partno='SSM-105-S-DV-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.105310s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12637189 LIMIT 5 [ RunTime:0.129686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12637189 ORDER BY `minOrder` ASC [ RunTime:0.074065s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12637189 ORDER BY `unit` DESC [ RunTime:0.121723s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12637189 LIMIT 2 [ RunTime:0.099799s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12637189 ORDER BY `minOrder` ASC [ RunTime:0.079573s ]
select * from pdf where partno='SSM-105-S-DV-BE-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.049766s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11525920 LIMIT 5 [ RunTime:0.140631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11525920 ORDER BY `minOrder` ASC [ RunTime:0.051897s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11525920 ORDER BY `unit` DESC [ RunTime:0.103126s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11525920 LIMIT 2 [ RunTime:0.029469s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11525920 ORDER BY `minOrder` ASC [ RunTime:0.033782s ]
select * from pdf where partno='SSM-105-S-DV-LC-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.029000s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11520937 LIMIT 5 [ RunTime:0.064866s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11520937 ORDER BY `minOrder` ASC [ RunTime:0.091847s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11520937 ORDER BY `unit` DESC [ RunTime:0.053367s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11520937 LIMIT 2 [ RunTime:0.020429s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11520937 ORDER BY `minOrder` ASC [ RunTime:0.014464s ]
select * from pdf where partno='SSM-105-S-DV-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.019962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12667933 LIMIT 5 [ RunTime:0.031550s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12667933 ORDER BY `minOrder` ASC [ RunTime:0.074370s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12667933 ORDER BY `unit` DESC [ RunTime:0.049841s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12667933 LIMIT 2 [ RunTime:0.061742s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12667933 ORDER BY `minOrder` ASC [ RunTime:0.006127s ]
select * from pdf where partno='SSM-105-S-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.026800s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12693722 LIMIT 5 [ RunTime:0.039995s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12693722 ORDER BY `minOrder` ASC [ RunTime:0.026536s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12693722 ORDER BY `unit` DESC [ RunTime:0.014976s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12693722 LIMIT 2 [ RunTime:0.011132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12693722 ORDER BY `minOrder` ASC [ RunTime:0.008570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12693721 LIMIT 5 [ RunTime:0.001916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12693721 ORDER BY `minOrder` ASC [ RunTime:0.000523s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12693721 ORDER BY `unit` DESC [ RunTime:0.008409s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12693721 LIMIT 2 [ RunTime:0.000441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12693721 ORDER BY `minOrder` ASC [ RunTime:0.002393s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12692794 LIMIT 5 [ RunTime:0.004189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12692794 ORDER BY `minOrder` ASC [ RunTime:0.001080s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12692794 ORDER BY `unit` DESC [ RunTime:0.000389s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12692794 LIMIT 2 [ RunTime:0.003205s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12692794 ORDER BY `minOrder` ASC [ RunTime:0.001234s ]
select * from pdf where partno='SSM-105-S-DV-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12691753 LIMIT 5 [ RunTime:0.002202s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12691753 ORDER BY `minOrder` ASC [ RunTime:0.000505s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12691753 ORDER BY `unit` DESC [ RunTime:0.000386s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12691753 LIMIT 2 [ RunTime:0.000381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12691753 ORDER BY `minOrder` ASC [ RunTime:0.002667s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12691752 LIMIT 5 [ RunTime:0.007702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12691752 ORDER BY `minOrder` ASC [ RunTime:0.001499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12691752 ORDER BY `unit` DESC [ RunTime:0.000510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12691752 LIMIT 2 [ RunTime:0.008118s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12691752 ORDER BY `minOrder` ASC [ RunTime:0.001951s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12689087 LIMIT 5 [ RunTime:0.004369s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12689087 ORDER BY `minOrder` ASC [ RunTime:0.004944s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12689087 ORDER BY `unit` DESC [ RunTime:0.002562s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12689087 LIMIT 2 [ RunTime:0.009208s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12689087 ORDER BY `minOrder` ASC [ RunTime:0.000337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12688674 LIMIT 5 [ RunTime:0.001833s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12688674 ORDER BY `minOrder` ASC [ RunTime:0.007169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12688674 ORDER BY `unit` DESC [ RunTime:0.010210s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12688674 LIMIT 2 [ RunTime:0.000578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12688674 ORDER BY `minOrder` ASC [ RunTime:0.003852s ]
select * from pdf where partno='SSM-105-S-DV-LC-M-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.014881s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12688505 LIMIT 5 [ RunTime:0.005675s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12688505 ORDER BY `minOrder` ASC [ RunTime:0.003532s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12688505 ORDER BY `unit` DESC [ RunTime:0.015696s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12688505 LIMIT 2 [ RunTime:0.003743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12688505 ORDER BY `minOrder` ASC [ RunTime:0.000843s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12688504 LIMIT 5 [ RunTime:0.001108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12688504 ORDER BY `minOrder` ASC [ RunTime:0.000446s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12688504 ORDER BY `unit` DESC [ RunTime:0.003765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12688504 LIMIT 2 [ RunTime:0.007573s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12688504 ORDER BY `minOrder` ASC [ RunTime:0.002593s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12688368 LIMIT 5 [ RunTime:0.000881s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12688368 ORDER BY `minOrder` ASC [ RunTime:0.009461s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12688368 ORDER BY `unit` DESC [ RunTime:0.011659s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12688368 LIMIT 2 [ RunTime:0.014381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12688368 ORDER BY `minOrder` ASC [ RunTime:0.006282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12686134 LIMIT 5 [ RunTime:0.019846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12686134 ORDER BY `minOrder` ASC [ RunTime:0.003423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12686134 ORDER BY `unit` DESC [ RunTime:0.002483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12686134 LIMIT 2 [ RunTime:0.000477s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12686134 ORDER BY `minOrder` ASC [ RunTime:0.000345s ]
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 'SSM-105-S-DV%' OR `brand` LIKE 'SSM-105-S-DV%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004499s ]
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 'SSM-105-S-DV%' OR `brand` LIKE 'SSM-105-S-DV%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011138s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52889742 LIMIT 5 [ RunTime:0.002522s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52889742 ORDER BY `minOrder` ASC [ RunTime:0.006861s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52889742 ORDER BY `unit` DESC [ RunTime:0.010940s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52889742 LIMIT 2 [ RunTime:0.001195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52889742 ORDER BY `minOrder` ASC [ RunTime:0.000679s ]
select * from pdf where partno='SSM-105-S-DV-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000712s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001223s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-105-S-DV-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000897s ]
SELECT `id` FROM `stock` WHERE `id` <> 52889742 AND `partno` = 'SSM-105-S-DV-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000597s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12683910 [ RunTime:0.000486s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52893826 LIMIT 5 [ RunTime:0.001299s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52893826 ORDER BY `minOrder` ASC [ RunTime:0.001067s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52893826 ORDER BY `unit` DESC [ RunTime:0.000424s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52893826 LIMIT 2 [ RunTime:0.000462s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52893826 ORDER BY `minOrder` ASC [ RunTime:0.000361s ]
select * from pdf where partno='SSM-105-S-DV-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004220s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-105-S-DV-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002671s ]
SELECT `id` FROM `stock` WHERE `id` <> 52893826 AND `partno` = 'SSM-105-S-DV-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001641s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52898632 LIMIT 5 [ RunTime:0.000600s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52898632 ORDER BY `minOrder` ASC [ RunTime:0.001105s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52898632 ORDER BY `unit` DESC [ RunTime:0.000596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52898632 LIMIT 2 [ RunTime:0.000572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52898632 ORDER BY `minOrder` ASC [ RunTime:0.000415s ]
select * from pdf where partno='SSM-105-S-DV-BE-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000995s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-105-S-DV-BE-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000765s ]
SELECT `id` FROM `stock` WHERE `id` <> 52898632 AND `partno` = 'SSM-105-S-DV-BE-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11500389 [ RunTime:0.000716s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52893889 LIMIT 5 [ RunTime:0.001443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52893889 ORDER BY `minOrder` ASC [ RunTime:0.001188s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52893889 ORDER BY `unit` DESC [ RunTime:0.001149s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52893889 LIMIT 2 [ RunTime:0.000577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52893889 ORDER BY `minOrder` ASC [ RunTime:0.000420s ]
select * from pdf where partno='SSM-105-S-DV-A-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000854s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-105-S-DV-A-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000702s ]
SELECT `id` FROM `stock` WHERE `id` <> 52893889 AND `partno` = 'SSM-105-S-DV-A-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000762s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12684431 [ RunTime:0.004515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52892226 LIMIT 5 [ RunTime:0.000688s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52892226 ORDER BY `minOrder` ASC [ RunTime:0.001167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52892226 ORDER BY `unit` DESC [ RunTime:0.000634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52892226 LIMIT 2 [ RunTime:0.000615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52892226 ORDER BY `minOrder` ASC [ RunTime:0.000455s ]
select * from pdf where partno='SSM-105-S-DV-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000766s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-105-S-DV-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000751s ]
SELECT `id` FROM `stock` WHERE `id` <> 52892226 AND `partno` = 'SSM-105-S-DV-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000801s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12684927 [ RunTime:0.000706s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52893468 LIMIT 5 [ RunTime:0.000625s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52893468 ORDER BY `minOrder` ASC [ RunTime:0.001181s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52893468 ORDER BY `unit` DESC [ RunTime:0.008882s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52893468 LIMIT 2 [ RunTime:0.002218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52893468 ORDER BY `minOrder` ASC [ RunTime:0.001489s ]
select * from pdf where partno='SSM-105-S-DV-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000691s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-105-S-DV-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000939s ]
SELECT `id` FROM `stock` WHERE `id` <> 52893468 AND `partno` = 'SSM-105-S-DV-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000891s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12683881 [ RunTime:0.000713s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52898484 LIMIT 5 [ RunTime:0.003404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52898484 ORDER BY `minOrder` ASC [ RunTime:0.009790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52898484 ORDER BY `unit` DESC [ RunTime:0.001469s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52898484 LIMIT 2 [ RunTime:0.000678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52898484 ORDER BY `minOrder` ASC [ RunTime:0.000427s ]
select * from pdf where partno='SSM-105-S-DV-BE-K-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002654s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-105-S-DV-BE-K-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000867s ]
SELECT `id` FROM `stock` WHERE `id` <> 52898484 AND `partno` = 'SSM-105-S-DV-BE-K-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.002218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12637189 [ RunTime:0.005788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52893598 LIMIT 5 [ RunTime:0.003929s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52893598 ORDER BY `minOrder` ASC [ RunTime:0.035057s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52893598 ORDER BY `unit` DESC [ RunTime:0.016488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52893598 LIMIT 2 [ RunTime:0.025349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52893598 ORDER BY `minOrder` ASC [ RunTime:0.016188s ]
select * from pdf where partno='SSM-105-S-DV-LC-K' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000775s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-105-S-DV-LC-K' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000985s ]
SELECT `id` FROM `stock` WHERE `id` <> 52893598 AND `partno` = 'SSM-105-S-DV-LC-K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000908s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11525920 [ RunTime:0.004980s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52914039 LIMIT 5 [ RunTime:0.032119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52914039 ORDER BY `minOrder` ASC [ RunTime:0.026934s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52914039 ORDER BY `unit` DESC [ RunTime:0.010488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52914039 LIMIT 2 [ RunTime:0.020829s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52914039 ORDER BY `minOrder` ASC [ RunTime:0.015352s ]
select * from pdf where partno='SSM-105-S-DV' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.028004s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-105-S-DV' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.028273s ]
SELECT `id` FROM `stock` WHERE `id` <> 52914039 AND `partno` = 'SSM-105-S-DV' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.045725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11547914 [ RunTime:0.034040s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52893545 LIMIT 5 [ RunTime:0.043661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52893545 ORDER BY `minOrder` ASC [ RunTime:0.012724s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52893545 ORDER BY `unit` DESC [ RunTime:0.008009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52893545 LIMIT 2 [ RunTime:0.032761s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52893545 ORDER BY `minOrder` ASC [ RunTime:0.025122s ]
select * from pdf where partno='SSM-105-S-DV-LC' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001991s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-105-S-DV-LC' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002323s ]
SELECT `id` FROM `stock` WHERE `id` <> 52893545 AND `partno` = 'SSM-105-S-DV-LC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.013483s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11520937 [ RunTime:0.003673s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52974217 LIMIT 5 [ RunTime:0.025568s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52974217 ORDER BY `minOrder` ASC [ RunTime:0.035055s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52974217 ORDER BY `unit` DESC [ RunTime:0.024220s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52974217 LIMIT 2 [ RunTime:0.012314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52974217 ORDER BY `minOrder` ASC [ RunTime:0.011190s ]
select * from pdf where partno='SSM-105-S-DV-A-P-007' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.072849s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-105-S-DV-A-P-007' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.017234s ]
SELECT `id` FROM `stock` WHERE `id` <> 52974217 AND `partno` = 'SSM-105-S-DV-A-P-007' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.006948s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52970182 LIMIT 5 [ RunTime:0.012755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52970182 ORDER BY `minOrder` ASC [ RunTime:0.012590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52970182 ORDER BY `unit` DESC [ RunTime:0.014301s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52970182 LIMIT 2 [ RunTime:0.019053s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52970182 ORDER BY `minOrder` ASC [ RunTime:0.013806s ]
select * from pdf where partno='SSM-105-S-DV-K-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.020513s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-105-S-DV-K-A' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.004523s ]
SELECT `id` FROM `stock` WHERE `id` <> 52970182 AND `partno` = 'SSM-105-S-DV-K-A' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.022622s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52964224 LIMIT 5 [ RunTime:0.006199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52964224 ORDER BY `minOrder` ASC [ RunTime:0.005026s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52964224 ORDER BY `unit` DESC [ RunTime:0.000483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52964224 LIMIT 2 [ RunTime:0.002726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52964224 ORDER BY `minOrder` ASC [ RunTime:0.007200s ]
select * from pdf where partno='SSM-105-S-DV-A-007-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004013s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-105-S-DV-A-007-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009703s ]
SELECT `id` FROM `stock` WHERE `id` <> 52964224 AND `partno` = 'SSM-105-S-DV-A-007-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.007697s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12693722 [ RunTime:0.009001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52964223 LIMIT 5 [ RunTime:0.000544s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52964223 ORDER BY `minOrder` ASC [ RunTime:0.002392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52964223 ORDER BY `unit` DESC [ RunTime:0.008287s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52964223 LIMIT 2 [ RunTime:0.010576s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52964223 ORDER BY `minOrder` ASC [ RunTime:0.000373s ]
select * from pdf where partno='SSM-105-S-DV-A-001-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002088s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-105-S-DV-A-001-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.000556s ]
SELECT `id` FROM `stock` WHERE `id` <> 52964223 AND `partno` = 'SSM-105-S-DV-A-001-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.018093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12693721 [ RunTime:0.004626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52963172 LIMIT 5 [ RunTime:0.001592s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52963172 ORDER BY `minOrder` ASC [ RunTime:0.016590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52963172 ORDER BY `unit` DESC [ RunTime:0.007505s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52963172 LIMIT 2 [ RunTime:0.003947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52963172 ORDER BY `minOrder` ASC [ RunTime:0.001023s ]
select * from pdf where partno='SSM-105-S-DV-BE-LC-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004117s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-105-S-DV-BE-LC-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.027023s ]
SELECT `id` FROM `stock` WHERE `id` <> 52963172 AND `partno` = 'SSM-105-S-DV-BE-LC-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.055216s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11535848 [ RunTime:0.012044s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52963171 LIMIT 5 [ RunTime:0.002861s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52963171 ORDER BY `minOrder` ASC [ RunTime:0.005465s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52963171 ORDER BY `unit` DESC [ RunTime:0.008077s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52963171 LIMIT 2 [ RunTime:0.013501s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52963171 ORDER BY `minOrder` ASC [ RunTime:0.005433s ]
select * from pdf where partno='SSM-105-S-DV-BE-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.012535s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-105-S-DV-BE-A-P-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001364s ]
SELECT `id` FROM `stock` WHERE `id` <> 52963171 AND `partno` = 'SSM-105-S-DV-BE-A-P-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001940s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12689087 [ RunTime:0.004722s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52961935 LIMIT 5 [ RunTime:0.000633s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52961935 ORDER BY `minOrder` ASC [ RunTime:0.001166s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52961935 ORDER BY `unit` DESC [ RunTime:0.000601s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52961935 LIMIT 2 [ RunTime:0.000558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52961935 ORDER BY `minOrder` ASC [ RunTime:0.001602s ]
select * from pdf where partno='SSM-105-S-DV-BE-LC-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-105-S-DV-BE-LC-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.002376s ]
SELECT `id` FROM `stock` WHERE `id` <> 52961935 AND `partno` = 'SSM-105-S-DV-BE-LC-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.021386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11538087 [ RunTime:0.006074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52961934 LIMIT 5 [ RunTime:0.005123s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52961934 ORDER BY `minOrder` ASC [ RunTime:0.000659s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52961934 ORDER BY `unit` DESC [ RunTime:0.001380s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52961934 LIMIT 2 [ RunTime:0.002813s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52961934 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
select * from pdf where partno='SSM-105-S-DV-BE-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002007s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-105-S-DV-BE-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.001655s ]
SELECT `id` FROM `stock` WHERE `id` <> 52961934 AND `partno` = 'SSM-105-S-DV-BE-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.000850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11538086 [ RunTime:0.000769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52961933 LIMIT 5 [ RunTime:0.008945s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52961933 ORDER BY `minOrder` ASC [ RunTime:0.027206s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52961933 ORDER BY `unit` DESC [ RunTime:0.034555s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52961933 LIMIT 2 [ RunTime:0.008500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52961933 ORDER BY `minOrder` ASC [ RunTime:0.015898s ]
select * from pdf where partno='SSM-105-S-DV-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.046009s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-105-S-DV-A-P' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.019223s ]
SELECT `id` FROM `stock` WHERE `id` <> 52961933 AND `partno` = 'SSM-105-S-DV-A-P' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.036624s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 52961931 LIMIT 5 [ RunTime:0.050010s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52961931 ORDER BY `minOrder` ASC [ RunTime:0.084058s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 52961931 ORDER BY `unit` DESC [ RunTime:0.092957s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 52961931 LIMIT 2 [ RunTime:0.034766s ]
SELECT * FROM `stock_price` WHERE `stockid` = 52961931 ORDER BY `minOrder` ASC [ RunTime:0.017253s ]
select * from pdf where partno='SSM-105-S-DV-LC-M-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.034832s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'SSM-105-S-DV-LC-M-TR' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.039536s ]
SELECT `id` FROM `stock` WHERE `id` <> 52961931 AND `partno` = 'SSM-105-S-DV-LC-M-TR' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.042003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12688674 [ RunTime:0.037217s ]
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 'SSM-105-S-DV%' OR `brand` LIKE 'SSM-105-S-DV%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.049558s ]
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 'SSM-105-S-DV%' OR `brand` LIKE 'SSM-105-S-DV%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017138s ]
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 'SSM-105-S-DV%' OR `brand` LIKE 'SSM-105-S-DV%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020138s ]
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 'SSM-105-S-DV%' OR `brand` LIKE 'SSM-105-S-DV%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001411s ]
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 'SSM-105-S-DV%' OR `brand` LIKE 'SSM-105-S-DV%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004461s ]
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 'SSM-105-S-DV%' OR `brand` LIKE 'SSM-105-S-DV%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017411s ]
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 'SSM-105-S-DV%' OR `brand` LIKE 'SSM-105-S-DV%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.007635s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'SSM-105-S-DV%' OR `brand` LIKE 'SSM-105-S-DV%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.012558s ]