SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002542s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.80' , `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=23102&search=1' [ RunTime:0.007096s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002049s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000607s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002284s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.80' ) [ RunTime:0.001905s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.001995s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.002785s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.003148s ]
SELECT * FROM `stock_search` WHERE `partno` = '23102' LIMIT 1 [ RunTime:0.009276s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-07-31 07:44:57' WHERE `partno` = '23102' [ RunTime:0.007112s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002143s ]
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 '23102%' OR `brand` LIKE '23102%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010206s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11484295 LIMIT 5 [ RunTime:0.021711s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.009131s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484295 ORDER BY `minOrder` ASC [ RunTime:0.012344s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.007025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11484295 ORDER BY `unit` DESC [ RunTime:0.027223s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.009500s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11484295 LIMIT 2 [ RunTime:0.012932s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484295 ORDER BY `minOrder` ASC [ RunTime:0.020886s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12616898 LIMIT 5 [ RunTime:0.037338s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12616898 ORDER BY `minOrder` ASC [ RunTime:0.028962s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12616898 ORDER BY `unit` DESC [ RunTime:0.066219s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12616898 LIMIT 2 [ RunTime:0.006012s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12616898 ORDER BY `minOrder` ASC [ RunTime:0.004167s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12613474 LIMIT 5 [ RunTime:0.034944s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613474 ORDER BY `minOrder` ASC [ RunTime:0.016425s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12613474 ORDER BY `unit` DESC [ RunTime:0.064243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12613474 LIMIT 2 [ RunTime:0.115269s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613474 ORDER BY `minOrder` ASC [ RunTime:0.014792s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12616131 LIMIT 5 [ RunTime:0.025789s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12616131 ORDER BY `minOrder` ASC [ RunTime:0.034293s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12616131 ORDER BY `unit` DESC [ RunTime:0.093783s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12616131 LIMIT 2 [ RunTime:0.064603s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12616131 ORDER BY `minOrder` ASC [ RunTime:0.020344s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12616526 LIMIT 5 [ RunTime:0.023851s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12616526 ORDER BY `minOrder` ASC [ RunTime:0.076256s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12616526 ORDER BY `unit` DESC [ RunTime:0.040899s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12616526 LIMIT 2 [ RunTime:0.035248s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12616526 ORDER BY `minOrder` ASC [ RunTime:0.027986s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14419808 LIMIT 5 [ RunTime:0.049891s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14419808 ORDER BY `minOrder` ASC [ RunTime:0.076076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14419808 ORDER BY `unit` DESC [ RunTime:0.042073s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14419808 LIMIT 2 [ RunTime:0.044133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14419808 ORDER BY `minOrder` ASC [ RunTime:0.037807s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13130456 LIMIT 5 [ RunTime:0.084381s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13130456 ORDER BY `minOrder` ASC [ RunTime:0.055115s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13130456 ORDER BY `unit` DESC [ RunTime:0.096795s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13130456 LIMIT 2 [ RunTime:0.057094s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13130456 ORDER BY `minOrder` ASC [ RunTime:0.013742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12796635 LIMIT 5 [ RunTime:0.025488s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12796635 ORDER BY `minOrder` ASC [ RunTime:0.011658s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12796635 ORDER BY `unit` DESC [ RunTime:0.103636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12796635 LIMIT 2 [ RunTime:0.088672s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12796635 ORDER BY `minOrder` ASC [ RunTime:0.057817s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12626275 LIMIT 5 [ RunTime:0.053454s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12626275 ORDER BY `minOrder` ASC [ RunTime:0.190738s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12626275 ORDER BY `unit` DESC [ RunTime:0.061816s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12626275 LIMIT 2 [ RunTime:0.094502s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12626275 ORDER BY `minOrder` ASC [ RunTime:0.014721s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12541677 LIMIT 5 [ RunTime:0.044740s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12541677 ORDER BY `minOrder` ASC [ RunTime:0.073716s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12541677 ORDER BY `unit` DESC [ RunTime:0.020100s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12541677 LIMIT 2 [ RunTime:0.043964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12541677 ORDER BY `minOrder` ASC [ RunTime:0.013163s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12541674 LIMIT 5 [ RunTime:0.045745s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12541674 ORDER BY `minOrder` ASC [ RunTime:0.064423s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12541674 ORDER BY `unit` DESC [ RunTime:0.006788s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12541674 LIMIT 2 [ RunTime:0.019088s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12541674 ORDER BY `minOrder` ASC [ RunTime:0.000491s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11613535 LIMIT 5 [ RunTime:0.013361s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11613535 ORDER BY `minOrder` ASC [ RunTime:0.029103s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11613535 ORDER BY `unit` DESC [ RunTime:0.021281s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11613535 LIMIT 2 [ RunTime:0.027960s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11613535 ORDER BY `minOrder` ASC [ RunTime:0.007642s ]
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 '23102%' OR `brand` LIKE '23102%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.012121s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267634 LIMIT 5 [ RunTime:0.040634s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267634 ORDER BY `minOrder` ASC [ RunTime:0.047167s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267634 ORDER BY `unit` DESC [ RunTime:0.013750s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267634 LIMIT 2 [ RunTime:0.020596s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267634 ORDER BY `minOrder` ASC [ RunTime:0.010423s ]
select * from pdf where partno='2310213-1' and brandshort='te connectivity' limit 1 [ RunTime:0.063680s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001562s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2310213-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.036626s ]
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 '23102%' OR `brand` LIKE '23102%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.048061s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53546728 LIMIT 5 [ RunTime:0.014303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53546728 ORDER BY `minOrder` ASC [ RunTime:0.044746s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53546728 ORDER BY `unit` DESC [ RunTime:0.063493s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53546728 LIMIT 2 [ RunTime:0.038128s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53546728 ORDER BY `minOrder` ASC [ RunTime:0.034890s ]
select * from pdf where partno='2310222-1' and brandshort='TE Connectivity' limit 1 [ RunTime:0.014856s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2310222-1' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.059056s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53085495 LIMIT 5 [ RunTime:0.012440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53085495 ORDER BY `minOrder` ASC [ RunTime:0.029453s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53085495 ORDER BY `unit` DESC [ RunTime:0.048433s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53085495 LIMIT 2 [ RunTime:0.045493s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53085495 ORDER BY `minOrder` ASC [ RunTime:0.039325s ]
select * from pdf where partno='2310223-1' and brandshort='TE Connectivity' limit 1 [ RunTime:0.081006s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2310223-1' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.064646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54171235 LIMIT 5 [ RunTime:0.034067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54171235 ORDER BY `minOrder` ASC [ RunTime:0.060404s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54171235 ORDER BY `unit` DESC [ RunTime:0.101223s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54171235 LIMIT 2 [ RunTime:0.011257s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54171235 ORDER BY `minOrder` ASC [ RunTime:0.030216s ]
select * from pdf where partno='2310223-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.038184s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2310223-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.101892s ]
SELECT `id` FROM `stock` WHERE `id` <> 54171235 AND `partno` = '2310223-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.074888s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53544592 LIMIT 5 [ RunTime:0.032467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53544592 ORDER BY `minOrder` ASC [ RunTime:0.040005s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53544592 ORDER BY `unit` DESC [ RunTime:0.102904s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53544592 LIMIT 2 [ RunTime:0.034082s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53544592 ORDER BY `minOrder` ASC [ RunTime:0.014547s ]
select * from pdf where partno='2310222-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.047804s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2310222-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.028586s ]
SELECT `id` FROM `stock` WHERE `id` <> 53544592 AND `partno` = '2310222-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.073037s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12613474 [ RunTime:0.054046s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53544637 LIMIT 5 [ RunTime:0.014271s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53544637 ORDER BY `minOrder` ASC [ RunTime:0.070416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53544637 ORDER BY `unit` DESC [ RunTime:0.067353s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53544637 LIMIT 2 [ RunTime:0.068782s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53544637 ORDER BY `minOrder` ASC [ RunTime:0.032252s ]
select * from pdf where partno='2310221-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.030835s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2310221-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.029824s ]
SELECT `id` FROM `stock` WHERE `id` <> 53544637 AND `partno` = '2310221-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.019507s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12616131 [ RunTime:0.076230s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53079189 LIMIT 5 [ RunTime:0.042293s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53079189 ORDER BY `minOrder` ASC [ RunTime:0.041025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53079189 ORDER BY `unit` DESC [ RunTime:0.065112s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53079189 LIMIT 2 [ RunTime:0.095467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53079189 ORDER BY `minOrder` ASC [ RunTime:0.036430s ]
select * from pdf where partno='2310213-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.035029s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2310213-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.062247s ]
SELECT `id` FROM `stock` WHERE `id` <> 53079189 AND `partno` = '2310213-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.029586s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12616526 [ RunTime:0.078670s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56276070 LIMIT 5 [ RunTime:0.102001s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56276070 ORDER BY `minOrder` ASC [ RunTime:0.038769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56276070 ORDER BY `unit` DESC [ RunTime:0.027114s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56276070 LIMIT 2 [ RunTime:0.032597s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56276070 ORDER BY `minOrder` ASC [ RunTime:0.041185s ]
select * from pdf where partno='23102B' and brandshort='Heyco Products Corporation' limit 1 [ RunTime:0.028159s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '23102B' OR `brand` LIKE 'Heyco Products Corporation%' ) ) LIMIT 1 [ RunTime:0.048695s ]
SELECT `id` FROM `stock` WHERE `id` <> 56276070 AND `partno` = '23102B' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%heyco products corporation%' ) [ RunTime:0.058050s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 56262050 LIMIT 5 [ RunTime:0.067642s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56262050 ORDER BY `minOrder` ASC [ RunTime:0.034982s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 56262050 ORDER BY `unit` DESC [ RunTime:0.081348s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 56262050 LIMIT 2 [ RunTime:0.101412s ]
SELECT * FROM `stock_price` WHERE `stockid` = 56262050 ORDER BY `minOrder` ASC [ RunTime:0.020065s ]
select * from pdf where partno='23102.9' and brandshort='Pflitsch' limit 1 [ RunTime:0.041606s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '23102.9' OR `brand` LIKE 'Pflitsch%' ) ) LIMIT 1 [ RunTime:0.044924s ]
SELECT `id` FROM `stock` WHERE `id` <> 56262050 AND `partno` = '23102.9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pflitsch%' ) [ RunTime:0.038873s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14419808 [ RunTime:0.083311s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54181392 LIMIT 5 [ RunTime:0.057939s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54181392 ORDER BY `minOrder` ASC [ RunTime:0.079025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54181392 ORDER BY `unit` DESC [ RunTime:0.025763s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54181392 LIMIT 2 [ RunTime:0.055204s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54181392 ORDER BY `minOrder` ASC [ RunTime:0.041572s ]
select * from pdf where partno='2310235' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.057429s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2310235' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.044504s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 54181387 LIMIT 5 [ RunTime:0.035941s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54181387 ORDER BY `minOrder` ASC [ RunTime:0.021614s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 54181387 ORDER BY `unit` DESC [ RunTime:0.004765s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 54181387 LIMIT 2 [ RunTime:0.106212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 54181387 ORDER BY `minOrder` ASC [ RunTime:0.129666s ]
select * from pdf where partno='2310222' and brandshort='Phoenix Contact' limit 1 [ RunTime:0.047436s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2310222' OR `brand` LIKE 'Phoenix Contact%' ) ) LIMIT 1 [ RunTime:0.060258s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53106756 LIMIT 5 [ RunTime:0.022470s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53106756 ORDER BY `minOrder` ASC [ RunTime:0.026948s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53106756 ORDER BY `unit` DESC [ RunTime:0.017558s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53106756 LIMIT 2 [ RunTime:0.087255s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53106756 ORDER BY `minOrder` ASC [ RunTime:0.018310s ]
select * from pdf where partno='2310213-2' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.031789s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2310213-2' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.023227s ]
SELECT `id` FROM `stock` WHERE `id` <> 53106756 AND `partno` = '2310213-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.012327s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12626275 [ RunTime:0.100286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53060439 LIMIT 5 [ RunTime:0.005942s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53060439 ORDER BY `minOrder` ASC [ RunTime:0.033735s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53060439 ORDER BY `unit` DESC [ RunTime:0.024001s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53060439 LIMIT 2 [ RunTime:0.012743s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53060439 ORDER BY `minOrder` ASC [ RunTime:0.011980s ]
select * from pdf where partno='2310225-1' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.065711s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2310225-1' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.029234s ]
SELECT `id` FROM `stock` WHERE `id` <> 53060439 AND `partno` = '2310225-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.024663s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11613535 [ RunTime:0.037122s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 53060094 LIMIT 5 [ RunTime:0.027367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53060094 ORDER BY `minOrder` ASC [ RunTime:0.022760s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 53060094 ORDER BY `unit` DESC [ RunTime:0.042604s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 53060094 LIMIT 2 [ RunTime:0.025819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 53060094 ORDER BY `minOrder` ASC [ RunTime:0.025583s ]
select * from pdf where partno='2310225-2' and brandshort='TE Connectivity Deutsch Connectors' limit 1 [ RunTime:0.013237s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2310225-2' OR `brand` LIKE 'TE Connectivity Deutsch Connectors%' ) ) LIMIT 1 [ RunTime:0.001840s ]
SELECT `id` FROM `stock` WHERE `id` <> 53060094 AND `partno` = '2310225-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity deutsch connectors%' ) [ RunTime:0.021737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12796635 [ RunTime:0.023563s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51685568 LIMIT 5 [ RunTime:0.009080s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51685568 ORDER BY `minOrder` ASC [ RunTime:0.007844s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51685568 ORDER BY `unit` DESC [ RunTime:0.012807s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51685568 LIMIT 2 [ RunTime:0.047667s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51685568 ORDER BY `minOrder` ASC [ RunTime:0.016623s ]
select * from pdf where partno='23102' and brandshort='Dremel' limit 1 [ RunTime:0.018327s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '23102' OR `brand` LIKE 'Dremel%' ) ) LIMIT 1 [ RunTime:0.028453s ]
SELECT `id` FROM `stock` WHERE `id` <> 51685568 AND `partno` = '23102' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%dremel%' ) [ RunTime:0.029545s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32479611 LIMIT 5 [ RunTime:0.040975s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32479611 ORDER BY `minOrder` ASC [ RunTime:0.011144s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32479611 ORDER BY `unit` DESC [ RunTime:0.051681s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32479611 LIMIT 2 [ RunTime:0.047823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32479611 ORDER BY `minOrder` ASC [ RunTime:0.027724s ]
select * from pdf where partno='23102' and brandshort='Murrelektronik, Inc' limit 1 [ RunTime:0.029821s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '23102' OR `brand` LIKE 'Murrelektronik, Inc%' ) ) LIMIT 1 [ RunTime:0.008430s ]
SELECT `id` FROM `stock` WHERE `id` <> 32479611 AND `partno` = '23102' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murrelektronik, inc%' ) [ RunTime:0.077053s ]
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 '23102%' OR `brand` LIKE '23102%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.020293s ]
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 '23102%' OR `brand` LIKE '23102%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.041789s ]
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 '23102%' OR `brand` LIKE '23102%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.080046s ]
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 '23102%' OR `brand` LIKE '23102%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.021047s ]
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 '23102%' OR `brand` LIKE '23102%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.039527s ]
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 '23102%' OR `brand` LIKE '23102%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.042583s ]
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 '23102%' OR `brand` LIKE '23102%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.040297s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '23102%' OR `brand` LIKE '23102%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.115593s ]