SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001817s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.064728s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001982s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.138' ) [ RunTime:0.024536s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001304s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.020591s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001076s ]
SELECT * FROM `stock_search` WHERE `partno` = 'TMM-110-01-L-D-SM' LIMIT 1 [ RunTime:0.015852s ]
UPDATE `stock_search` SET `count` = 641 , `updatetime` = '2026-03-09 11:51:50' WHERE `partno` = 'TMM-110-01-L-D-SM' [ RunTime:0.069878s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 0 LIMIT 1 [ RunTime:0.014611s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` = 0 [ RunTime:0.039077s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `typeid` IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,800,1068,1296,1456,1822,1929,2017,2101,2342,2393,2475,2518,2568) [ RunTime:0.050266s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003292s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE ( `partno` LIKE 'TMM-110-01-L-D-SM%' AND `status` <> 2 ) AND `u`.`lockUser` = '0' [ RunTime:0.123054s ]
SELECT `s`.`id` FROM `stock` `s` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND ( `partno` LIKE 'TMM-110-01-L-D-SM%' AND `status` <> 2 ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.055876s ]
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` INNER JOIN `user` `u` ON `s`.`userid`=`u`.`stockuserid` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE `u`.`lockUser` = '0' AND ( (s.isDisplay = 1) ) AND `s`.`id` IN ('16197715','15475804','8385','19851579','19851651','19830795','19830235','19801161','19786774','19786773','19776720','19755176','16187351','16186795','15481210','15480063','15479767','11596482') ORDER BY FIELD(s.id, 16197715,15475804,8385,19851579,19851651,19830795,19830235,19801161,19786774,19786773,19776720,19755176,16187351,16186795,15481210,15480063,15479767,11596482) [ RunTime:0.112055s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.016971s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16197715 LIMIT 4 [ RunTime:0.044713s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.007821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16197715 ORDER BY `minOrder` ASC [ RunTime:0.048582s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.018502s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16197715 ORDER BY `unit` DESC [ RunTime:0.031813s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.014186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16197715 LIMIT 2 [ RunTime:0.024485s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16197715 ORDER BY `minOrder` ASC [ RunTime:0.028664s ]
select * from pdf where partno='TMM-110-01-L-D-SM-A-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.032983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15475804 LIMIT 4 [ RunTime:0.030483s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15475804 ORDER BY `minOrder` ASC [ RunTime:0.019371s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15475804 ORDER BY `unit` DESC [ RunTime:0.011314s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15475804 LIMIT 2 [ RunTime:0.009313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15475804 ORDER BY `minOrder` ASC [ RunTime:0.008030s ]
select * from pdf where partno='TMM-110-01-L-D-SM-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.024009s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8385 LIMIT 4 [ RunTime:0.020583s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8385 ORDER BY `minOrder` ASC [ RunTime:0.010925s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 8385 ORDER BY `unit` DESC [ RunTime:0.013502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 8385 LIMIT 2 [ RunTime:0.009642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 8385 ORDER BY `minOrder` ASC [ RunTime:0.003346s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001428s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TMM-110-01-L-D-SM' OR `brand` LIKE 'SAMTEC%' ) ) LIMIT 1 [ RunTime:0.001620s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19851579 LIMIT 4 [ RunTime:0.015330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19851579 ORDER BY `minOrder` ASC [ RunTime:0.003008s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19851579 ORDER BY `unit` DESC [ RunTime:0.001026s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19851579 LIMIT 2 [ RunTime:0.016194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19851579 ORDER BY `minOrder` ASC [ RunTime:0.004352s ]
select * from pdf where partno='TMM-110-01-L-D-SM' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.039046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19851651 LIMIT 4 [ RunTime:0.004045s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19851651 ORDER BY `minOrder` ASC [ RunTime:0.009329s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19851651 ORDER BY `unit` DESC [ RunTime:0.006122s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19851651 LIMIT 2 [ RunTime:0.006370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19851651 ORDER BY `minOrder` ASC [ RunTime:0.001522s ]
select * from pdf where partno='TMM-110-01-L-D-SM-A' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.007674s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19830795 LIMIT 4 [ RunTime:0.024269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19830795 ORDER BY `minOrder` ASC [ RunTime:0.007352s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19830795 ORDER BY `unit` DESC [ RunTime:0.003852s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19830795 LIMIT 2 [ RunTime:0.029855s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19830795 ORDER BY `minOrder` ASC [ RunTime:0.011168s ]
select * from pdf where partno='TMM-110-01-L-D-SM-020-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.006223s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19830235 LIMIT 4 [ RunTime:0.015026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19830235 ORDER BY `minOrder` ASC [ RunTime:0.005759s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19830235 ORDER BY `unit` DESC [ RunTime:0.000836s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19830235 LIMIT 2 [ RunTime:0.006482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19830235 ORDER BY `minOrder` ASC [ RunTime:0.003559s ]
select * from pdf where partno='TMM-110-01-L-D-SM-004' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.016470s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19801161 LIMIT 4 [ RunTime:0.022682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19801161 ORDER BY `minOrder` ASC [ RunTime:0.030610s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19801161 ORDER BY `unit` DESC [ RunTime:0.020364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19801161 LIMIT 2 [ RunTime:0.012513s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19801161 ORDER BY `minOrder` ASC [ RunTime:0.003867s ]
select * from pdf where partno='TMM-110-01-L-D-SM-A-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004021s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19786774 LIMIT 4 [ RunTime:0.009726s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19786774 ORDER BY `minOrder` ASC [ RunTime:0.018949s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19786774 ORDER BY `unit` DESC [ RunTime:0.010948s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19786774 LIMIT 2 [ RunTime:0.002976s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19786774 ORDER BY `minOrder` ASC [ RunTime:0.004682s ]
select * from pdf where partno='TMM-110-01-L-D-SM-020-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19786773 LIMIT 4 [ RunTime:0.005535s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19786773 ORDER BY `minOrder` ASC [ RunTime:0.005701s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19786773 ORDER BY `unit` DESC [ RunTime:0.018377s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19786773 LIMIT 2 [ RunTime:0.007294s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19786773 ORDER BY `minOrder` ASC [ RunTime:0.005866s ]
select * from pdf where partno='TMM-110-01-L-D-SM-010-P-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004075s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19776720 LIMIT 4 [ RunTime:0.019974s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19776720 ORDER BY `minOrder` ASC [ RunTime:0.009248s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19776720 ORDER BY `unit` DESC [ RunTime:0.008879s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19776720 LIMIT 2 [ RunTime:0.001665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19776720 ORDER BY `minOrder` ASC [ RunTime:0.000408s ]
select * from pdf where partno='TMM-110-01-L-D-SM-M-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.003242s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19755176 LIMIT 4 [ RunTime:0.005168s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19755176 ORDER BY `minOrder` ASC [ RunTime:0.004011s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19755176 ORDER BY `unit` DESC [ RunTime:0.005704s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19755176 LIMIT 2 [ RunTime:0.018005s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19755176 ORDER BY `minOrder` ASC [ RunTime:0.030725s ]
select * from pdf where partno='TMM-110-01-L-D-SM-P' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.011112s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16187351 LIMIT 4 [ RunTime:0.017774s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16187351 ORDER BY `minOrder` ASC [ RunTime:0.045627s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16187351 ORDER BY `unit` DESC [ RunTime:0.011960s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16187351 LIMIT 2 [ RunTime:0.044581s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16187351 ORDER BY `minOrder` ASC [ RunTime:0.000502s ]
select * from pdf where partno='TMM-110-01-L-D-SM-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.034771s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16186795 LIMIT 4 [ RunTime:0.003008s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16186795 ORDER BY `minOrder` ASC [ RunTime:0.046165s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16186795 ORDER BY `unit` DESC [ RunTime:0.004708s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16186795 LIMIT 2 [ RunTime:0.008456s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16186795 ORDER BY `minOrder` ASC [ RunTime:0.003855s ]
select * from pdf where partno='TMM-110-01-L-D-SM-007' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.016693s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15481210 LIMIT 4 [ RunTime:0.013931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15481210 ORDER BY `minOrder` ASC [ RunTime:0.022549s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15481210 ORDER BY `unit` DESC [ RunTime:0.005331s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15481210 LIMIT 2 [ RunTime:0.008316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15481210 ORDER BY `minOrder` ASC [ RunTime:0.004471s ]
select * from pdf where partno='TMM-110-01-L-D-SM-M' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.013573s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15480063 LIMIT 4 [ RunTime:0.007214s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15480063 ORDER BY `minOrder` ASC [ RunTime:0.003260s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15480063 ORDER BY `unit` DESC [ RunTime:0.000640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15480063 LIMIT 2 [ RunTime:0.000626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15480063 ORDER BY `minOrder` ASC [ RunTime:0.000407s ]
select * from pdf where partno='TMM-110-01-L-D-SM-A-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.004900s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 15479767 LIMIT 4 [ RunTime:0.004730s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15479767 ORDER BY `minOrder` ASC [ RunTime:0.001621s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 15479767 ORDER BY `unit` DESC [ RunTime:0.000536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 15479767 LIMIT 2 [ RunTime:0.000527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 15479767 ORDER BY `minOrder` ASC [ RunTime:0.000276s ]
select * from pdf where partno='TMM-110-01-L-D-SM-A-M-TR' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.000935s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11596482 LIMIT 4 [ RunTime:0.008126s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11596482 ORDER BY `minOrder` ASC [ RunTime:0.000494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11596482 ORDER BY `unit` DESC [ RunTime:0.006283s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11596482 LIMIT 2 [ RunTime:0.000391s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11596482 ORDER BY `minOrder` ASC [ RunTime:0.001985s ]
select * from pdf where partno='TMM-110-01-L-D-SM-A-M' and brandshort='Samtec Inc.' limit 1 [ RunTime:0.001659s ]
SELECT brand, count(*) as count FROM `stock` WHERE ( `partno` LIKE 'TMM-110-01-L-D-SM%' AND `status` <> 2 ) AND `brand` IS NOT NULL AND `brand` <> '' GROUP BY `brand` ORDER BY `count` DESC LIMIT 10000 [ RunTime:0.001245s ]