SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001538s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `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=724&page=4&srecordnum=1068' [ RunTime:0.001755s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001250s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000530s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001456s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.001896s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001088s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.008867s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001493s ]
SELECT * FROM `stock_search` WHERE `partno` = '724' LIMIT 1 [ RunTime:0.000438s ]
UPDATE `stock_search` SET `count` = 1325 , `updatetime` = '2026-06-13 10:33:58' WHERE `partno` = '724' [ RunTime:0.001571s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.001269s ]
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 '724%' OR `brand` LIKE '724%' ) AND `s`.`status` <> '2' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 60,20 [ RunTime:0.057928s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.011099s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38146978 LIMIT 4 [ RunTime:0.043855s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.008536s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38146978 ORDER BY `minOrder` ASC [ RunTime:0.013626s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.002218s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38146978 ORDER BY `unit` DESC [ RunTime:0.039154s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.003502s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38146978 LIMIT 2 [ RunTime:0.031406s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38146978 ORDER BY `minOrder` ASC [ RunTime:0.054058s ]
select * from pdf where partno='72446CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.046302s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.003801s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72446CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.043170s ]
SELECT `id` FROM `stock` WHERE `id` <> 38146978 AND `partno` = '72446CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.059477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065105 [ RunTime:0.030417s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38147012 LIMIT 4 [ RunTime:0.031017s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147012 ORDER BY `minOrder` ASC [ RunTime:0.053137s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38147012 ORDER BY `unit` DESC [ RunTime:0.065797s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38147012 LIMIT 2 [ RunTime:0.058746s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147012 ORDER BY `minOrder` ASC [ RunTime:0.023540s ]
select * from pdf where partno='72419CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.030501s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72419CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.018292s ]
SELECT `id` FROM `stock` WHERE `id` <> 38147012 AND `partno` = '72419CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.091759s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346012 [ RunTime:0.041795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 42368899 LIMIT 4 [ RunTime:0.047854s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42368899 ORDER BY `minOrder` ASC [ RunTime:0.028179s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 42368899 ORDER BY `unit` DESC [ RunTime:0.037818s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 42368899 LIMIT 2 [ RunTime:0.037687s ]
SELECT * FROM `stock_price` WHERE `stockid` = 42368899 ORDER BY `minOrder` ASC [ RunTime:0.034247s ]
select * from pdf where partno='72454-010VLF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.028055s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72454-010VLF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.024501s ]
SELECT `id` FROM `stock` WHERE `id` <> 42368899 AND `partno` = '72454-010VLF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.032132s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19850509 [ RunTime:0.126413s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13352354 LIMIT 4 [ RunTime:0.067719s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13352354 ORDER BY `minOrder` ASC [ RunTime:0.011048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13352354 ORDER BY `unit` DESC [ RunTime:0.035264s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13352354 LIMIT 2 [ RunTime:0.061428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13352354 ORDER BY `minOrder` ASC [ RunTime:0.029163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38147207 LIMIT 4 [ RunTime:0.016418s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147207 ORDER BY `minOrder` ASC [ RunTime:0.046123s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38147207 ORDER BY `unit` DESC [ RunTime:0.026352s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38147207 LIMIT 2 [ RunTime:0.064384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147207 ORDER BY `minOrder` ASC [ RunTime:0.004469s ]
select * from pdf where partno='72402SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.035298s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72402SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.029294s ]
SELECT `id` FROM `stock` WHERE `id` <> 38147207 AND `partno` = '72402SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.043968s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065147 [ RunTime:0.012064s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38147208 LIMIT 4 [ RunTime:0.039753s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147208 ORDER BY `minOrder` ASC [ RunTime:0.029816s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38147208 ORDER BY `unit` DESC [ RunTime:0.033089s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38147208 LIMIT 2 [ RunTime:0.016686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147208 ORDER BY `minOrder` ASC [ RunTime:0.014781s ]
select * from pdf where partno='72404SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.016821s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72404SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.017659s ]
SELECT `id` FROM `stock` WHERE `id` <> 38147208 AND `partno` = '72404SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.018079s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065142 [ RunTime:0.039725s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35485253 LIMIT 4 [ RunTime:0.035478s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35485253 ORDER BY `minOrder` ASC [ RunTime:0.044766s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35485253 ORDER BY `unit` DESC [ RunTime:0.030510s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35485253 LIMIT 2 [ RunTime:0.032702s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35485253 ORDER BY `minOrder` ASC [ RunTime:0.005364s ]
select * from pdf where partno='7243-5' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.051889s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7243-5' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.031592s ]
SELECT `id` FROM `stock` WHERE `id` <> 35485253 AND `partno` = '7243-5' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.038830s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37554390 LIMIT 4 [ RunTime:0.026514s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37554390 ORDER BY `minOrder` ASC [ RunTime:0.038169s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37554390 ORDER BY `unit` DESC [ RunTime:0.014072s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37554390 LIMIT 2 [ RunTime:0.018569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37554390 ORDER BY `minOrder` ASC [ RunTime:0.013198s ]
select * from pdf where partno='7240BP15B2000001E' and brandshort='Johanson Technology Inc.' limit 1 [ RunTime:0.033245s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7240BP15B2000001E' OR `brand` LIKE 'Johanson Technology Inc.%' ) ) LIMIT 1 [ RunTime:0.025747s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38147616 LIMIT 4 [ RunTime:0.013160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147616 ORDER BY `minOrder` ASC [ RunTime:0.027844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38147616 ORDER BY `unit` DESC [ RunTime:0.033164s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38147616 LIMIT 2 [ RunTime:0.039081s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147616 ORDER BY `minOrder` ASC [ RunTime:0.023800s ]
select * from pdf where partno='72424SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.037456s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72424SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.022833s ]
SELECT `id` FROM `stock` WHERE `id` <> 38147616 AND `partno` = '72424SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.046696s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38147225 LIMIT 4 [ RunTime:0.016749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147225 ORDER BY `minOrder` ASC [ RunTime:0.041787s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38147225 ORDER BY `unit` DESC [ RunTime:0.037170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38147225 LIMIT 2 [ RunTime:0.055605s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147225 ORDER BY `minOrder` ASC [ RunTime:0.020024s ]
select * from pdf where partno='72445SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.062866s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72445SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.017258s ]
SELECT `id` FROM `stock` WHERE `id` <> 38147225 AND `partno` = '72445SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.024185s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13346075 [ RunTime:0.029492s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 35485263 LIMIT 4 [ RunTime:0.046788s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35485263 ORDER BY `minOrder` ASC [ RunTime:0.018027s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 35485263 ORDER BY `unit` DESC [ RunTime:0.025720s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 35485263 LIMIT 2 [ RunTime:0.049716s ]
SELECT * FROM `stock_price` WHERE `stockid` = 35485263 ORDER BY `minOrder` ASC [ RunTime:0.051618s ]
select * from pdf where partno='7244' and brandshort='Keystone Electronics' limit 1 [ RunTime:0.019783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7244' OR `brand` LIKE 'Keystone Electronics%' ) ) LIMIT 1 [ RunTime:0.032303s ]
SELECT `id` FROM `stock` WHERE `id` <> 35485263 AND `partno` = '7244' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%keystone electronics%' ) [ RunTime:0.051637s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38146413 LIMIT 4 [ RunTime:0.025644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38146413 ORDER BY `minOrder` ASC [ RunTime:0.027299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38146413 ORDER BY `unit` DESC [ RunTime:0.070014s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38146413 LIMIT 2 [ RunTime:0.058203s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38146413 ORDER BY `minOrder` ASC [ RunTime:0.031913s ]
select * from pdf where partno='72411CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.042179s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72411CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.079914s ]
SELECT `id` FROM `stock` WHERE `id` <> 38146413 AND `partno` = '72411CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.009603s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13345965 LIMIT 4 [ RunTime:0.045591s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13345965 ORDER BY `minOrder` ASC [ RunTime:0.037480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13345965 ORDER BY `unit` DESC [ RunTime:0.058994s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13345965 LIMIT 2 [ RunTime:0.013551s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13345965 ORDER BY `minOrder` ASC [ RunTime:0.020777s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36874627 LIMIT 4 [ RunTime:0.035942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36874627 ORDER BY `minOrder` ASC [ RunTime:0.048655s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 36874627 ORDER BY `unit` DESC [ RunTime:0.030432s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 36874627 LIMIT 2 [ RunTime:0.051194s ]
SELECT * FROM `stock_price` WHERE `stockid` = 36874627 ORDER BY `minOrder` ASC [ RunTime:0.024480s ]
select * from pdf where partno='724' and brandshort='SCS' limit 1 [ RunTime:0.035948s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '724' OR `brand` LIKE 'SCS%' ) ) LIMIT 1 [ RunTime:0.036292s ]
SELECT `id` FROM `stock` WHERE `id` <> 36874627 AND `partno` = '724' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%scs%' ) [ RunTime:0.034680s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10088 [ RunTime:0.009578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16237 [ RunTime:0.044397s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19507664 [ RunTime:0.049688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065224 LIMIT 4 [ RunTime:0.029677s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065224 ORDER BY `minOrder` ASC [ RunTime:0.048666s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12065224 ORDER BY `unit` DESC [ RunTime:0.032165s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12065224 LIMIT 2 [ RunTime:0.048200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12065224 ORDER BY `minOrder` ASC [ RunTime:0.057059s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38147578 LIMIT 4 [ RunTime:0.050345s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147578 ORDER BY `minOrder` ASC [ RunTime:0.042979s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38147578 ORDER BY `unit` DESC [ RunTime:0.056822s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38147578 LIMIT 2 [ RunTime:0.022921s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147578 ORDER BY `minOrder` ASC [ RunTime:0.033634s ]
select * from pdf where partno='72499SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.039784s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72499SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.013541s ]
SELECT `id` FROM `stock` WHERE `id` <> 38147578 AND `partno` = '72499SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.017267s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38146524 LIMIT 4 [ RunTime:0.032686s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38146524 ORDER BY `minOrder` ASC [ RunTime:0.043176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38146524 ORDER BY `unit` DESC [ RunTime:0.041186s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38146524 LIMIT 2 [ RunTime:0.038841s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38146524 ORDER BY `minOrder` ASC [ RunTime:0.009798s ]
select * from pdf where partno='72449SCS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.023736s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72449SCS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.013853s ]
SELECT `id` FROM `stock` WHERE `id` <> 38146524 AND `partno` = '72449SCS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.026742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 38147459 LIMIT 4 [ RunTime:0.003906s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147459 ORDER BY `minOrder` ASC [ RunTime:0.015516s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 38147459 ORDER BY `unit` DESC [ RunTime:0.014501s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 38147459 LIMIT 2 [ RunTime:0.034879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 38147459 ORDER BY `minOrder` ASC [ RunTime:0.010285s ]
select * from pdf where partno='72475CS' and brandshort='Century Spring Corp' limit 1 [ RunTime:0.020471s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '72475CS' OR `brand` LIKE 'Century Spring Corp%' ) ) LIMIT 1 [ RunTime:0.014355s ]
SELECT `id` FROM `stock` WHERE `id` <> 38147459 AND `partno` = '72475CS' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%century spring corp%' ) [ RunTime:0.033780s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12065189 [ RunTime:0.023879s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 37294790 LIMIT 4 [ RunTime:0.010662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37294790 ORDER BY `minOrder` ASC [ RunTime:0.013226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 37294790 ORDER BY `unit` DESC [ RunTime:0.012991s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 37294790 LIMIT 2 [ RunTime:0.019745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 37294790 ORDER BY `minOrder` ASC [ RunTime:0.011397s ]
select * from pdf where partno='7241CPKFEBA01' and brandshort='Flip Electronics' limit 1 [ RunTime:0.007731s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '7241CPKFEBA01' OR `brand` LIKE 'Flip Electronics%' ) ) LIMIT 1 [ RunTime:0.024301s ]
SELECT `id` FROM `stock` WHERE `id` <> 37294790 AND `partno` = '7241CPKFEBA01' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%flip electronics%' ) [ RunTime:0.032104s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19196844 [ RunTime:0.013148s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19196844 LIMIT 4 [ RunTime:0.006108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19196844 ORDER BY `minOrder` ASC [ RunTime:0.005421s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19196844 ORDER BY `unit` DESC [ RunTime:0.021924s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19196844 LIMIT 2 [ RunTime:0.006541s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19196844 ORDER BY `minOrder` ASC [ RunTime:0.005470s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '724%' OR `brand` LIKE '724%' ) AND `s`.`status` <> '2' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 60,20 [ RunTime:0.015946s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '724%' OR `brand` LIKE '724%' ) AND `s`.`status` <> '2' ) ) tmp GROUP BY `brand` [ RunTime:0.004760s ]
SELECT DISTINCT `categoryid` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '724%' OR `brand` LIKE '724%' ) AND `s`.`status` <> '2' ) AND `categoryid` > 0 [ RunTime:0.000590s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` = 127 [ RunTime:0.000477s ]