SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003236s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.37' , `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=IDMD-07-T-08.00&search=1' [ RunTime:0.002889s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.003778s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000858s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002859s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.37' ) [ RunTime:0.000522s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001391s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.001451s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001225s ]
SELECT * FROM `stock_search` WHERE `partno` = 'IDMD-07-T-08.00' LIMIT 1 [ RunTime:0.003539s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-31 13:50:26' WHERE `partno` = 'IDMD-07-T-08.00' [ RunTime:0.002664s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001577s ]
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 'IDMD-07-T-08.00%' OR `brand` LIKE 'IDMD-07-T-08.00%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003297s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001093s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16465990 LIMIT 5 [ RunTime:0.001544s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.003335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16465990 ORDER BY `minOrder` ASC [ RunTime:0.000461s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002437s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16465990 ORDER BY `unit` DESC [ RunTime:0.000568s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.000930s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16465990 LIMIT 2 [ RunTime:0.003127s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16465990 ORDER BY `minOrder` ASC [ RunTime:0.003074s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16465184 LIMIT 5 [ RunTime:0.004607s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16465184 ORDER BY `minOrder` ASC [ RunTime:0.011502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16465184 ORDER BY `unit` DESC [ RunTime:0.001187s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16465184 LIMIT 2 [ RunTime:0.009582s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16465184 ORDER BY `minOrder` ASC [ RunTime:0.003620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14471567 LIMIT 5 [ RunTime:0.006197s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14471567 ORDER BY `minOrder` ASC [ RunTime:0.002583s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14471567 ORDER BY `unit` DESC [ RunTime:0.004194s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14471567 LIMIT 2 [ RunTime:0.001744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14471567 ORDER BY `minOrder` ASC [ RunTime:0.004835s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14470668 LIMIT 5 [ RunTime:0.008824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14470668 ORDER BY `minOrder` ASC [ RunTime:0.002308s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14470668 ORDER BY `unit` DESC [ RunTime:0.011662s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14470668 LIMIT 2 [ RunTime:0.005352s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14470668 ORDER BY `minOrder` ASC [ RunTime:0.003037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14466650 LIMIT 5 [ RunTime:0.003167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14466650 ORDER BY `minOrder` ASC [ RunTime:0.005668s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14466650 ORDER BY `unit` DESC [ RunTime:0.016360s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14466650 LIMIT 2 [ RunTime:0.000910s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14466650 ORDER BY `minOrder` ASC [ RunTime:0.011410s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13610285 LIMIT 5 [ RunTime:0.010482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13610285 ORDER BY `minOrder` ASC [ RunTime:0.008825s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13610285 ORDER BY `unit` DESC [ RunTime:0.008133s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13610285 LIMIT 2 [ RunTime:0.015403s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13610285 ORDER BY `minOrder` ASC [ RunTime:0.002241s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13609588 LIMIT 5 [ RunTime:0.009689s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13609588 ORDER BY `minOrder` ASC [ RunTime:0.006334s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13609588 ORDER BY `unit` DESC [ RunTime:0.009384s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13609588 LIMIT 2 [ RunTime:0.014871s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13609588 ORDER BY `minOrder` ASC [ RunTime:0.009062s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13609586 LIMIT 5 [ RunTime:0.020047s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13609586 ORDER BY `minOrder` ASC [ RunTime:0.016103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13609586 ORDER BY `unit` DESC [ RunTime:0.018585s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13609586 LIMIT 2 [ RunTime:0.007828s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13609586 ORDER BY `minOrder` ASC [ RunTime:0.001296s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13607484 LIMIT 5 [ RunTime:0.001773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13607484 ORDER BY `minOrder` ASC [ RunTime:0.023471s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13607484 ORDER BY `unit` DESC [ RunTime:0.015991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13607484 LIMIT 2 [ RunTime:0.006195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13607484 ORDER BY `minOrder` ASC [ RunTime:0.005060s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13607482 LIMIT 5 [ RunTime:0.017254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13607482 ORDER BY `minOrder` ASC [ RunTime:0.007540s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13607482 ORDER BY `unit` DESC [ RunTime:0.011164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13607482 LIMIT 2 [ RunTime:0.008070s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13607482 ORDER BY `minOrder` ASC [ RunTime:0.005382s ]
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 'IDMD-07-T-08.00%' OR `brand` LIKE 'IDMD-07-T-08.00%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.037229s ]
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 'IDMD-07-T-08.00%' OR `brand` LIKE 'IDMD-07-T-08.00%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.018885s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55473570 LIMIT 5 [ RunTime:0.002639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55473570 ORDER BY `minOrder` ASC [ RunTime:0.007434s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55473570 ORDER BY `unit` DESC [ RunTime:0.019374s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55473570 LIMIT 2 [ RunTime:0.012851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55473570 ORDER BY `minOrder` ASC [ RunTime:0.008679s ]
select * from pdf where partno='IDMD-07-T-08.00-C-G-RW-R' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.015660s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002460s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IDMD-07-T-08.00-C-G-RW-R' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.014365s ]
SELECT `id` FROM `stock` WHERE `id` <> 55473570 AND `partno` = 'IDMD-07-T-08.00-C-G-RW-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.011238s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14471567 [ RunTime:0.015173s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55473568 LIMIT 5 [ RunTime:0.016542s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55473568 ORDER BY `minOrder` ASC [ RunTime:0.019545s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55473568 ORDER BY `unit` DESC [ RunTime:0.021868s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55473568 LIMIT 2 [ RunTime:0.007868s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55473568 ORDER BY `minOrder` ASC [ RunTime:0.019766s ]
select * from pdf where partno='IDMD-07-T-08.00-C-G' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.020892s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IDMD-07-T-08.00-C-G' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006718s ]
SELECT `id` FROM `stock` WHERE `id` <> 55473568 AND `partno` = 'IDMD-07-T-08.00-C-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.014351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16465990 [ RunTime:0.016745s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55471226 LIMIT 5 [ RunTime:0.020314s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55471226 ORDER BY `minOrder` ASC [ RunTime:0.006015s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55471226 ORDER BY `unit` DESC [ RunTime:0.006179s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55471226 LIMIT 2 [ RunTime:0.009661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55471226 ORDER BY `minOrder` ASC [ RunTime:0.003928s ]
select * from pdf where partno='IDMD-07-T-08.00' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011846s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IDMD-07-T-08.00' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.009257s ]
SELECT `id` FROM `stock` WHERE `id` <> 55471226 AND `partno` = 'IDMD-07-T-08.00' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.009897s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14470668 [ RunTime:0.021104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55471216 LIMIT 5 [ RunTime:0.012514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55471216 ORDER BY `minOrder` ASC [ RunTime:0.017567s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55471216 ORDER BY `unit` DESC [ RunTime:0.005605s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55471216 LIMIT 2 [ RunTime:0.014135s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55471216 ORDER BY `minOrder` ASC [ RunTime:0.002223s ]
select * from pdf where partno='IDMD-07-T-08.00-R' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002019s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IDMD-07-T-08.00-R' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.014810s ]
SELECT `id` FROM `stock` WHERE `id` <> 55471216 AND `partno` = 'IDMD-07-T-08.00-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.001219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16465184 [ RunTime:0.005978s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55471019 LIMIT 5 [ RunTime:0.011340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55471019 ORDER BY `minOrder` ASC [ RunTime:0.012479s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55471019 ORDER BY `unit` DESC [ RunTime:0.012130s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55471019 LIMIT 2 [ RunTime:0.006112s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55471019 ORDER BY `minOrder` ASC [ RunTime:0.019064s ]
select * from pdf where partno='IDMD-07-T-08.00-A-G' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.002213s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IDMD-07-T-08.00-A-G' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.020629s ]
SELECT `id` FROM `stock` WHERE `id` <> 55471019 AND `partno` = 'IDMD-07-T-08.00-A-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.006121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13610285 [ RunTime:0.006632s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55468721 LIMIT 5 [ RunTime:0.004456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55468721 ORDER BY `minOrder` ASC [ RunTime:0.004941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55468721 ORDER BY `unit` DESC [ RunTime:0.008291s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55468721 LIMIT 2 [ RunTime:0.007149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55468721 ORDER BY `minOrder` ASC [ RunTime:0.006941s ]
select * from pdf where partno='IDMD-07-T-08.00-G' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010677s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IDMD-07-T-08.00-G' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005516s ]
SELECT `id` FROM `stock` WHERE `id` <> 55468721 AND `partno` = 'IDMD-07-T-08.00-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.005015s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13609588 [ RunTime:0.010661s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55468710 LIMIT 5 [ RunTime:0.002199s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55468710 ORDER BY `minOrder` ASC [ RunTime:0.006975s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55468710 ORDER BY `unit` DESC [ RunTime:0.001532s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55468710 LIMIT 2 [ RunTime:0.005056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55468710 ORDER BY `minOrder` ASC [ RunTime:0.003567s ]
select * from pdf where partno='IDMD-07-T-08.00-G-R' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003540s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IDMD-07-T-08.00-G-R' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.012429s ]
SELECT `id` FROM `stock` WHERE `id` <> 55468710 AND `partno` = 'IDMD-07-T-08.00-G-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.020695s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13609586 [ RunTime:0.006986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55461693 LIMIT 5 [ RunTime:0.001168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55461693 ORDER BY `minOrder` ASC [ RunTime:0.007946s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55461693 ORDER BY `unit` DESC [ RunTime:0.005961s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55461693 LIMIT 2 [ RunTime:0.000733s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55461693 ORDER BY `minOrder` ASC [ RunTime:0.004247s ]
select * from pdf where partno='IDMD-07-T-08.00-T-G-RW-R' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.010005s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IDMD-07-T-08.00-T-G-RW-R' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.006723s ]
SELECT `id` FROM `stock` WHERE `id` <> 55461693 AND `partno` = 'IDMD-07-T-08.00-T-G-RW-R' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.014749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13607484 [ RunTime:0.005782s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55461676 LIMIT 5 [ RunTime:0.001383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55461676 ORDER BY `minOrder` ASC [ RunTime:0.008762s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55461676 ORDER BY `unit` DESC [ RunTime:0.005253s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55461676 LIMIT 2 [ RunTime:0.005827s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55461676 ORDER BY `minOrder` ASC [ RunTime:0.003795s ]
select * from pdf where partno='IDMD-07-T-08.00-T-G' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.009449s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IDMD-07-T-08.00-T-G' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.005064s ]
SELECT `id` FROM `stock` WHERE `id` <> 55461676 AND `partno` = 'IDMD-07-T-08.00-T-G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.013021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13607482 [ RunTime:0.003182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 55461341 LIMIT 5 [ RunTime:0.001631s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55461341 ORDER BY `minOrder` ASC [ RunTime:0.013506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 55461341 ORDER BY `unit` DESC [ RunTime:0.005081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 55461341 LIMIT 2 [ RunTime:0.013849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 55461341 ORDER BY `minOrder` ASC [ RunTime:0.011726s ]
select * from pdf where partno='IDMD-07-T-08.00-T' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.015206s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'IDMD-07-T-08.00-T' OR `brand` LIKE 'Samtec Inc.%' ) ) LIMIT 1 [ RunTime:0.012002s ]
SELECT `id` FROM `stock` WHERE `id` <> 55461341 AND `partno` = 'IDMD-07-T-08.00-T' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%samtec inc.%' ) [ RunTime:0.013536s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14466650 [ RunTime:0.008875s ]
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 'IDMD-07-T-08.00%' OR `brand` LIKE 'IDMD-07-T-08.00%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006864s ]
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 'IDMD-07-T-08.00%' OR `brand` LIKE 'IDMD-07-T-08.00%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005348s ]
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 'IDMD-07-T-08.00%' OR `brand` LIKE 'IDMD-07-T-08.00%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.019304s ]
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 'IDMD-07-T-08.00%' OR `brand` LIKE 'IDMD-07-T-08.00%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012620s ]
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 'IDMD-07-T-08.00%' OR `brand` LIKE 'IDMD-07-T-08.00%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.023260s ]
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 'IDMD-07-T-08.00%' OR `brand` LIKE 'IDMD-07-T-08.00%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005238s ]
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 'IDMD-07-T-08.00%' OR `brand` LIKE 'IDMD-07-T-08.00%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016620s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE 'IDMD-07-T-08.00%' OR `brand` LIKE 'IDMD-07-T-08.00%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.016702s ]