SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001815s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.146' , `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=171&search=1' [ RunTime:0.002895s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002607s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.000651s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001959s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.146' ) [ RunTime:0.015033s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002197s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000834s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.002303s ]
SELECT * FROM `stock_search` WHERE `partno` = '171' LIMIT 1 [ RunTime:0.035514s ]
UPDATE `stock_search` SET `count` = 2 , `updatetime` = '2026-08-10 19:30:03' WHERE `partno` = '171' [ RunTime:0.009869s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.003124s ]
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 '171%' OR `brand` LIKE '171%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.249833s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.001723s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481018 LIMIT 5 [ RunTime:0.017021s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.001212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481018 ORDER BY `minOrder` ASC [ RunTime:0.006622s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.001804s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481018 ORDER BY `unit` DESC [ RunTime:0.011650s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.001459s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481018 LIMIT 2 [ RunTime:0.036879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481018 ORDER BY `minOrder` ASC [ RunTime:0.005638s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609181 LIMIT 5 [ RunTime:0.021997s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609181 ORDER BY `minOrder` ASC [ RunTime:0.008730s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609181 ORDER BY `unit` DESC [ RunTime:0.020882s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609181 LIMIT 2 [ RunTime:0.022584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609181 ORDER BY `minOrder` ASC [ RunTime:0.010523s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11484100 LIMIT 5 [ RunTime:0.019966s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484100 ORDER BY `minOrder` ASC [ RunTime:0.024883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11484100 ORDER BY `unit` DESC [ RunTime:0.020516s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11484100 LIMIT 2 [ RunTime:0.006874s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11484100 ORDER BY `minOrder` ASC [ RunTime:0.000431s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609090 LIMIT 5 [ RunTime:0.002399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609090 ORDER BY `minOrder` ASC [ RunTime:0.000564s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609090 ORDER BY `unit` DESC [ RunTime:0.010480s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609090 LIMIT 2 [ RunTime:0.013313s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609090 ORDER BY `minOrder` ASC [ RunTime:0.004711s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16221837 LIMIT 5 [ RunTime:0.003404s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16221837 ORDER BY `minOrder` ASC [ RunTime:0.000541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16221837 ORDER BY `unit` DESC [ RunTime:0.000652s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16221837 LIMIT 2 [ RunTime:0.000545s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16221837 ORDER BY `minOrder` ASC [ RunTime:0.006582s ]
select * from pdf where partno='1718571002' and brandshort='Molex' limit 1 [ RunTime:0.004236s ]
select foldpath,foldpath2,filename from pdf_file where id=1521880 limit 1 [ RunTime:0.004041s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609134 LIMIT 5 [ RunTime:0.006645s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609134 ORDER BY `minOrder` ASC [ RunTime:0.001513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12609134 ORDER BY `unit` DESC [ RunTime:0.003706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12609134 LIMIT 2 [ RunTime:0.003834s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12609134 ORDER BY `minOrder` ASC [ RunTime:0.002218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19816404 LIMIT 5 [ RunTime:0.001110s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19816404 ORDER BY `minOrder` ASC [ RunTime:0.003341s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19816404 ORDER BY `unit` DESC [ RunTime:0.002873s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19816404 LIMIT 2 [ RunTime:0.007969s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19816404 ORDER BY `minOrder` ASC [ RunTime:0.000389s ]
select * from pdf where partno='1718561002' and brandshort='Molex' limit 1 [ RunTime:0.001362s ]
select foldpath,foldpath2,filename from pdf_file where id=1991746 limit 1 [ RunTime:0.001477s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19821684 LIMIT 5 [ RunTime:0.001046s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19821684 ORDER BY `minOrder` ASC [ RunTime:0.003093s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19821684 ORDER BY `unit` DESC [ RunTime:0.003945s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19821684 LIMIT 2 [ RunTime:0.000446s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19821684 ORDER BY `minOrder` ASC [ RunTime:0.000258s ]
select * from pdf where partno='1719740003' and brandshort='Molex' limit 1 [ RunTime:0.001522s ]
select foldpath,foldpath2,filename from pdf_file where id=1673915 limit 1 [ RunTime:0.002465s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12618443 LIMIT 5 [ RunTime:0.004754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12618443 ORDER BY `minOrder` ASC [ RunTime:0.001335s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12618443 ORDER BY `unit` DESC [ RunTime:0.014887s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12618443 LIMIT 2 [ RunTime:0.008174s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12618443 ORDER BY `minOrder` ASC [ RunTime:0.001657s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481166 LIMIT 5 [ RunTime:0.000970s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481166 ORDER BY `minOrder` ASC [ RunTime:0.000584s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481166 ORDER BY `unit` DESC [ RunTime:0.003618s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481166 LIMIT 2 [ RunTime:0.000520s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481166 ORDER BY `minOrder` ASC [ RunTime:0.000386s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481774 LIMIT 5 [ RunTime:0.001024s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481774 ORDER BY `minOrder` ASC [ RunTime:0.000541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481774 ORDER BY `unit` DESC [ RunTime:0.007627s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481774 LIMIT 2 [ RunTime:0.000552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481774 ORDER BY `minOrder` ASC [ RunTime:0.001034s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481444 LIMIT 5 [ RunTime:0.000849s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481444 ORDER BY `minOrder` ASC [ RunTime:0.006929s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481444 ORDER BY `unit` DESC [ RunTime:0.000640s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481444 LIMIT 2 [ RunTime:0.000553s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481444 ORDER BY `minOrder` ASC [ RunTime:0.000286s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481831 LIMIT 5 [ RunTime:0.000523s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481831 ORDER BY `minOrder` ASC [ RunTime:0.001299s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481831 ORDER BY `unit` DESC [ RunTime:0.001474s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481831 LIMIT 2 [ RunTime:0.004821s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481831 ORDER BY `minOrder` ASC [ RunTime:0.000356s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19815713 LIMIT 5 [ RunTime:0.002149s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19815713 ORDER BY `minOrder` ASC [ RunTime:0.001916s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19815713 ORDER BY `unit` DESC [ RunTime:0.001896s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19815713 LIMIT 2 [ RunTime:0.002611s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19815713 ORDER BY `minOrder` ASC [ RunTime:0.005813s ]
select * from pdf where partno='1718560003' and brandshort='Molex' limit 1 [ RunTime:0.001961s ]
select foldpath,foldpath2,filename from pdf_file where id=1609958 limit 1 [ RunTime:0.000866s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12613073 LIMIT 5 [ RunTime:0.003224s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613073 ORDER BY `minOrder` ASC [ RunTime:0.001513s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12613073 ORDER BY `unit` DESC [ RunTime:0.003977s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12613073 LIMIT 2 [ RunTime:0.001578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12613073 ORDER BY `minOrder` ASC [ RunTime:0.000542s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11862193 LIMIT 5 [ RunTime:0.007475s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11862193 ORDER BY `minOrder` ASC [ RunTime:0.006142s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11862193 ORDER BY `unit` DESC [ RunTime:0.000370s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11862193 LIMIT 2 [ RunTime:0.000452s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11862193 ORDER BY `minOrder` ASC [ RunTime:0.000278s ]
select * from pdf where partno='171-015-103L001' and brandshort='NorComp Inc.' limit 1 [ RunTime:0.007210s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481463 LIMIT 5 [ RunTime:0.000707s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481463 ORDER BY `minOrder` ASC [ RunTime:0.003209s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481463 ORDER BY `unit` DESC [ RunTime:0.000579s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481463 LIMIT 2 [ RunTime:0.000400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481463 ORDER BY `minOrder` ASC [ RunTime:0.000269s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19825413 LIMIT 5 [ RunTime:0.000630s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19825413 ORDER BY `minOrder` ASC [ RunTime:0.000995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 19825413 ORDER BY `unit` DESC [ RunTime:0.003811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 19825413 LIMIT 2 [ RunTime:0.002985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 19825413 ORDER BY `minOrder` ASC [ RunTime:0.000305s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16217842 LIMIT 5 [ RunTime:0.003316s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16217842 ORDER BY `minOrder` ASC [ RunTime:0.001871s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16217842 ORDER BY `unit` DESC [ RunTime:0.000385s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16217842 LIMIT 2 [ RunTime:0.000339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16217842 ORDER BY `minOrder` ASC [ RunTime:0.000272s ]
select * from pdf where partno='1718570002' and brandshort='Molex' limit 1 [ RunTime:0.001039s ]
select foldpath,foldpath2,filename from pdf_file where id=1657571 limit 1 [ RunTime:0.000883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481489 LIMIT 5 [ RunTime:0.000476s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481489 ORDER BY `minOrder` ASC [ RunTime:0.003266s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11481489 ORDER BY `unit` DESC [ RunTime:0.004519s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11481489 LIMIT 2 [ RunTime:0.003729s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11481489 ORDER BY `minOrder` ASC [ RunTime:0.000734s ]
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 '171%' OR `brand` LIKE '171%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.026737s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267695 LIMIT 5 [ RunTime:0.011039s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267695 ORDER BY `minOrder` ASC [ RunTime:0.004111s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267695 ORDER BY `unit` DESC [ RunTime:0.000894s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267695 LIMIT 2 [ RunTime:0.000812s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267695 ORDER BY `minOrder` ASC [ RunTime:0.002514s ]
select * from pdf where partno='1719532-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.004510s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002676s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1719532-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.004596s ]
SELECT `id` FROM `stock` WHERE `id` <> 32267695 AND `partno` = '1719532-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.008219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281082 LIMIT 5 [ RunTime:0.000776s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281082 ORDER BY `minOrder` ASC [ RunTime:0.001199s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281082 ORDER BY `unit` DESC [ RunTime:0.000739s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281082 LIMIT 2 [ RunTime:0.004327s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281082 ORDER BY `minOrder` ASC [ RunTime:0.006968s ]
select * from pdf where partno='171637-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.006882s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '171637-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.004552s ]
SELECT `id` FROM `stock` WHERE `id` <> 32281082 AND `partno` = '171637-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.009196s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267924 LIMIT 5 [ RunTime:0.000665s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267924 ORDER BY `minOrder` ASC [ RunTime:0.002112s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267924 ORDER BY `unit` DESC [ RunTime:0.001342s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267924 LIMIT 2 [ RunTime:0.000637s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267924 ORDER BY `minOrder` ASC [ RunTime:0.002656s ]
select * from pdf where partno='1718348-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.001023s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1718348-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.002163s ]
SELECT `id` FROM `stock` WHERE `id` <> 32267924 AND `partno` = '1718348-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.004003s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276471 LIMIT 5 [ RunTime:0.009539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276471 ORDER BY `minOrder` ASC [ RunTime:0.012201s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276471 ORDER BY `unit` DESC [ RunTime:0.011796s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276471 LIMIT 2 [ RunTime:0.011691s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276471 ORDER BY `minOrder` ASC [ RunTime:0.000414s ]
select * from pdf where partno='171857-1002' and brandshort='molex' limit 1 [ RunTime:0.000574s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '171857-1002' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.006071s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32281800 LIMIT 5 [ RunTime:0.000552s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281800 ORDER BY `minOrder` ASC [ RunTime:0.000995s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32281800 ORDER BY `unit` DESC [ RunTime:0.003959s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32281800 LIMIT 2 [ RunTime:0.006500s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32281800 ORDER BY `minOrder` ASC [ RunTime:0.004289s ]
select * from pdf where partno='171706-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.001227s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '171706-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000520s ]
SELECT `id` FROM `stock` WHERE `id` <> 32281800 AND `partno` = '171706-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.003476s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267188 LIMIT 5 [ RunTime:0.000399s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267188 ORDER BY `minOrder` ASC [ RunTime:0.001175s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267188 ORDER BY `unit` DESC [ RunTime:0.006174s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267188 LIMIT 2 [ RunTime:0.004156s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267188 ORDER BY `minOrder` ASC [ RunTime:0.000821s ]
select * from pdf where partno='1718348-2' and brandshort='te connectivity' limit 1 [ RunTime:0.001698s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1718348-2' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.025351s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32264489 LIMIT 5 [ RunTime:0.000968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32264489 ORDER BY `minOrder` ASC [ RunTime:0.009506s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32264489 ORDER BY `unit` DESC [ RunTime:0.000873s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32264489 LIMIT 2 [ RunTime:0.002662s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32264489 ORDER BY `minOrder` ASC [ RunTime:0.005896s ]
select * from pdf where partno='1717832-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.004013s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1717832-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.007678s ]
SELECT `id` FROM `stock` WHERE `id` <> 32264489 AND `partno` = '1717832-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.004946s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32209474 LIMIT 5 [ RunTime:0.001206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32209474 ORDER BY `minOrder` ASC [ RunTime:0.006416s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32209474 ORDER BY `unit` DESC [ RunTime:0.001009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32209474 LIMIT 2 [ RunTime:0.000674s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32209474 ORDER BY `minOrder` ASC [ RunTime:0.000422s ]
select * from pdf where partno='171-3215-ex' and brandshort='kobiconn' limit 1 [ RunTime:0.001388s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '171-3215-ex' OR `brand` LIKE 'kobiconn%' ) ) LIMIT 1 [ RunTime:0.002224s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267926 LIMIT 5 [ RunTime:0.005980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267926 ORDER BY `minOrder` ASC [ RunTime:0.008590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267926 ORDER BY `unit` DESC [ RunTime:0.006422s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267926 LIMIT 2 [ RunTime:0.012067s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267926 ORDER BY `minOrder` ASC [ RunTime:0.004239s ]
select * from pdf where partno='1719840-1' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.006578s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1719840-1' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.001258s ]
SELECT `id` FROM `stock` WHERE `id` <> 32267926 AND `partno` = '1719840-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000924s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51095564 LIMIT 5 [ RunTime:0.002773s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51095564 ORDER BY `minOrder` ASC [ RunTime:0.002354s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51095564 ORDER BY `unit` DESC [ RunTime:0.001654s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51095564 LIMIT 2 [ RunTime:0.015392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51095564 ORDER BY `minOrder` ASC [ RunTime:0.005781s ]
select * from pdf where partno='1718077-2' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.001813s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1718077-2' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.000707s ]
SELECT `id` FROM `stock` WHERE `id` <> 51095564 AND `partno` = '1718077-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000834s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32277288 LIMIT 5 [ RunTime:0.002272s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277288 ORDER BY `minOrder` ASC [ RunTime:0.003048s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32277288 ORDER BY `unit` DESC [ RunTime:0.000536s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32277288 LIMIT 2 [ RunTime:0.003004s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32277288 ORDER BY `minOrder` ASC [ RunTime:0.000419s ]
select * from pdf where partno='171822-9' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000742s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '171822-9' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.002239s ]
SELECT `id` FROM `stock` WHERE `id` <> 32277288 AND `partno` = '171822-9' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.008570s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276853 LIMIT 5 [ RunTime:0.003682s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276853 ORDER BY `minOrder` ASC [ RunTime:0.002223s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276853 ORDER BY `unit` DESC [ RunTime:0.000444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276853 LIMIT 2 [ RunTime:0.004584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276853 ORDER BY `minOrder` ASC [ RunTime:0.002146s ]
select * from pdf where partno='171822-6' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.000854s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '171822-6' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.002583s ]
SELECT `id` FROM `stock` WHERE `id` <> 32276853 AND `partno` = '171822-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.000653s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32272019 LIMIT 5 [ RunTime:0.002741s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32272019 ORDER BY `minOrder` ASC [ RunTime:0.003241s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32272019 ORDER BY `unit` DESC [ RunTime:0.001299s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32272019 LIMIT 2 [ RunTime:0.000358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32272019 ORDER BY `minOrder` ASC [ RunTime:0.000563s ]
select * from pdf where partno='171-pa62111-1-e' and brandshort='kobiconn' limit 1 [ RunTime:0.001698s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '171-pa62111-1-e' OR `brand` LIKE 'kobiconn%' ) ) LIMIT 1 [ RunTime:0.000627s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32276623 LIMIT 5 [ RunTime:0.000362s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276623 ORDER BY `minOrder` ASC [ RunTime:0.002499s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32276623 ORDER BY `unit` DESC [ RunTime:0.012394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32276623 LIMIT 2 [ RunTime:0.001055s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32276623 ORDER BY `minOrder` ASC [ RunTime:0.002694s ]
select * from pdf where partno='171822-7' and brandshort='te connectivity' limit 1 [ RunTime:0.001091s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '171822-7' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.028522s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51047716 LIMIT 5 [ RunTime:0.010694s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51047716 ORDER BY `minOrder` ASC [ RunTime:0.001811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51047716 ORDER BY `unit` DESC [ RunTime:0.000695s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51047716 LIMIT 2 [ RunTime:0.000858s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51047716 ORDER BY `minOrder` ASC [ RunTime:0.002225s ]
select * from pdf where partno='171031801' and brandshort='wurth elektronik' limit 1 [ RunTime:0.001051s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '171031801' OR `brand` LIKE 'wurth elektronik%' ) ) LIMIT 1 [ RunTime:0.002399s ]
SELECT `id` FROM `stock` WHERE `id` <> 51047716 AND `partno` = '171031801' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%wurth elektronik%' ) [ RunTime:0.003395s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13868609 [ RunTime:0.001155s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32275134 LIMIT 5 [ RunTime:0.000754s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275134 ORDER BY `minOrder` ASC [ RunTime:0.001227s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32275134 ORDER BY `unit` DESC [ RunTime:0.007416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32275134 LIMIT 2 [ RunTime:0.004431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32275134 ORDER BY `minOrder` ASC [ RunTime:0.002863s ]
select * from pdf where partno='1716120000' and brandshort='weidmuller' limit 1 [ RunTime:0.002046s ]
select foldpath,foldpath2,filename from pdf_file where id=1208903 limit 1 [ RunTime:0.000827s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1716120000' OR `brand` LIKE 'weidmuller%' ) ) LIMIT 1 [ RunTime:0.001284s ]
SELECT `id` FROM `stock` WHERE `id` <> 32275134 AND `partno` = '1716120000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%weidmuller%' ) [ RunTime:0.007133s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11442888 [ RunTime:0.014475s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32252150 LIMIT 5 [ RunTime:0.000629s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32252150 ORDER BY `minOrder` ASC [ RunTime:0.001076s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32252150 ORDER BY `unit` DESC [ RunTime:0.004646s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32252150 LIMIT 2 [ RunTime:0.025927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32252150 ORDER BY `minOrder` ASC [ RunTime:0.002140s ]
select * from pdf where partno='171-037-113r911' and brandshort='norcomp' limit 1 [ RunTime:0.006255s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '171-037-113r911' OR `brand` LIKE 'norcomp%' ) ) LIMIT 1 [ RunTime:0.003265s ]
SELECT `id` FROM `stock` WHERE `id` <> 32252150 AND `partno` = '171-037-113r911' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%norcomp%' ) [ RunTime:0.015421s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61935848 [ RunTime:0.017626s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32267598 LIMIT 5 [ RunTime:0.004354s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267598 ORDER BY `minOrder` ASC [ RunTime:0.006349s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32267598 ORDER BY `unit` DESC [ RunTime:0.021444s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32267598 LIMIT 2 [ RunTime:0.008927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32267598 ORDER BY `minOrder` ASC [ RunTime:0.007077s ]
select * from pdf where partno='171662-5 (cut strip)' and brandshort='te connectivity / amp' limit 1 [ RunTime:0.005989s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '171662-5 (cut strip)' OR `brand` LIKE 'te connectivity / amp%' ) ) LIMIT 1 [ RunTime:0.007033s ]
SELECT `id` FROM `stock` WHERE `id` <> 32267598 AND `partno` = '171662-5 (cut strip)' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / amp%' ) [ RunTime:0.008979s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32272024 LIMIT 5 [ RunTime:0.003349s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32272024 ORDER BY `minOrder` ASC [ RunTime:0.000781s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32272024 ORDER BY `unit` DESC [ RunTime:0.008354s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32272024 LIMIT 2 [ RunTime:0.004083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32272024 ORDER BY `minOrder` ASC [ RunTime:0.002893s ]
select * from pdf where partno='171-105ac-ex' and brandshort='kobiconn' limit 1 [ RunTime:0.001060s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '171-105ac-ex' OR `brand` LIKE 'kobiconn%' ) ) LIMIT 1 [ RunTime:0.002313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270566 LIMIT 5 [ RunTime:0.008619s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270566 ORDER BY `minOrder` ASC [ RunTime:0.001451s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270566 ORDER BY `unit` DESC [ RunTime:0.002376s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270566 LIMIT 2 [ RunTime:0.010635s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270566 ORDER BY `minOrder` ASC [ RunTime:0.009625s ]
select * from pdf where partno='171082-1' and brandshort='te connectivity' limit 1 [ RunTime:0.005029s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '171082-1' OR `brand` LIKE 'te connectivity%' ) ) LIMIT 1 [ RunTime:0.019943s ]
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 '171%' OR `brand` LIKE '171%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.186515s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59946713 LIMIT 5 [ RunTime:0.005265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59946713 ORDER BY `minOrder` ASC [ RunTime:0.004919s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59946713 ORDER BY `unit` DESC [ RunTime:0.002103s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59946713 LIMIT 2 [ RunTime:0.001296s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59946713 ORDER BY `minOrder` ASC [ RunTime:0.000559s ]
select * from pdf where partno='1719545-5' and brandshort='TE Connectivity' limit 1 [ RunTime:0.000727s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1719545-5' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.011153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60342755 LIMIT 5 [ RunTime:0.004527s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60342755 ORDER BY `minOrder` ASC [ RunTime:0.001811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60342755 ORDER BY `unit` DESC [ RunTime:0.001284s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60342755 LIMIT 2 [ RunTime:0.010264s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60342755 ORDER BY `minOrder` ASC [ RunTime:0.000350s ]
select * from pdf where partno='171637-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001439s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '171637-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.004493s ]
SELECT `id` FROM `stock` WHERE `id` <> 60342755 AND `partno` = '171637-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.005265s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11481018 [ RunTime:0.000660s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63088846 LIMIT 5 [ RunTime:0.001250s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63088846 ORDER BY `minOrder` ASC [ RunTime:0.002568s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63088846 ORDER BY `unit` DESC [ RunTime:0.003154s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63088846 LIMIT 2 [ RunTime:0.001534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63088846 ORDER BY `minOrder` ASC [ RunTime:0.001675s ]
select * from pdf where partno='171353-2' and brandshort='TE Connectivity Raychem Cable Protection' limit 1 [ RunTime:0.002462s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '171353-2' OR `brand` LIKE 'TE Connectivity Raychem Cable Protection%' ) ) LIMIT 1 [ RunTime:0.005828s ]
SELECT `id` FROM `stock` WHERE `id` <> 63088846 AND `partno` = '171353-2' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity raychem cable protection%' ) [ RunTime:0.000740s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16420814 [ RunTime:0.001053s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60344019 LIMIT 5 [ RunTime:0.004230s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60344019 ORDER BY `minOrder` ASC [ RunTime:0.007848s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60344019 ORDER BY `unit` DESC [ RunTime:0.001847s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60344019 LIMIT 2 [ RunTime:0.000964s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60344019 ORDER BY `minOrder` ASC [ RunTime:0.000378s ]
select * from pdf where partno='1718348-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001064s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1718348-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.006681s ]
SELECT `id` FROM `stock` WHERE `id` <> 60344019 AND `partno` = '1718348-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609170 [ RunTime:0.001103s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60344234 LIMIT 5 [ RunTime:0.002405s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60344234 ORDER BY `minOrder` ASC [ RunTime:0.002764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60344234 ORDER BY `unit` DESC [ RunTime:0.004511s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60344234 LIMIT 2 [ RunTime:0.003340s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60344234 ORDER BY `minOrder` ASC [ RunTime:0.000381s ]
select * from pdf where partno='1718758-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001946s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1718758-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000956s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59438601 LIMIT 5 [ RunTime:0.000435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59438601 ORDER BY `minOrder` ASC [ RunTime:0.000821s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59438601 ORDER BY `unit` DESC [ RunTime:0.000416s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59438601 LIMIT 2 [ RunTime:0.006443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59438601 ORDER BY `minOrder` ASC [ RunTime:0.000339s ]
select * from pdf where partno='1719740003' and brandshort='Molex' limit 1 [ RunTime:0.000525s ]
select foldpath,foldpath2,filename from pdf_file where id=1673915 limit 1 [ RunTime:0.000326s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1719740003' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.004976s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60342778 LIMIT 5 [ RunTime:0.000431s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60342778 ORDER BY `minOrder` ASC [ RunTime:0.000437s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60342778 ORDER BY `unit` DESC [ RunTime:0.002170s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60342778 LIMIT 2 [ RunTime:0.000594s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60342778 ORDER BY `minOrder` ASC [ RunTime:0.000281s ]
select * from pdf where partno='171636-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001796s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '171636-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000618s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59438334 LIMIT 5 [ RunTime:0.000351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59438334 ORDER BY `minOrder` ASC [ RunTime:0.003820s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59438334 ORDER BY `unit` DESC [ RunTime:0.004530s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59438334 LIMIT 2 [ RunTime:0.000440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59438334 ORDER BY `minOrder` ASC [ RunTime:0.000993s ]
select * from pdf where partno='1718563002' and brandshort='Molex' limit 1 [ RunTime:0.001057s ]
select foldpath,foldpath2,filename from pdf_file where id=1654092 limit 1 [ RunTime:0.002437s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1718563002' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.008427s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60342843 LIMIT 5 [ RunTime:0.001968s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60342843 ORDER BY `minOrder` ASC [ RunTime:0.001244s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60342843 ORDER BY `unit` DESC [ RunTime:0.000441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60342843 LIMIT 2 [ RunTime:0.000358s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60342843 ORDER BY `minOrder` ASC [ RunTime:0.001534s ]
select * from pdf where partno='171639-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001004s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '171639-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001301s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60994565 LIMIT 5 [ RunTime:0.000378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60994565 ORDER BY `minOrder` ASC [ RunTime:0.000725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60994565 ORDER BY `unit` DESC [ RunTime:0.000423s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60994565 LIMIT 2 [ RunTime:0.001621s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60994565 ORDER BY `minOrder` ASC [ RunTime:0.002928s ]
select * from pdf where partno='1718250100' and brandshort='Molex' limit 1 [ RunTime:0.008467s ]
select foldpath,foldpath2,filename from pdf_file where id=1590555 limit 1 [ RunTime:0.001995s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1718250100' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.012435s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60342949 LIMIT 5 [ RunTime:0.013762s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60342949 ORDER BY `minOrder` ASC [ RunTime:0.013941s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60342949 ORDER BY `unit` DESC [ RunTime:0.002520s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60342949 LIMIT 2 [ RunTime:0.003339s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60342949 ORDER BY `minOrder` ASC [ RunTime:0.002705s ]
select * from pdf where partno='1718760-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003614s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1718760-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002534s ]
SELECT `id` FROM `stock` WHERE `id` <> 60342949 AND `partno` = '1718760-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.001503s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610802 [ RunTime:0.003020s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60343106 LIMIT 5 [ RunTime:0.000653s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60343106 ORDER BY `minOrder` ASC [ RunTime:0.001883s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60343106 ORDER BY `unit` DESC [ RunTime:0.023236s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60343106 LIMIT 2 [ RunTime:0.019744s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60343106 ORDER BY `minOrder` ASC [ RunTime:0.002908s ]
select * from pdf where partno='1718758-3' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001033s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1718758-3' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.007688s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59935731 LIMIT 5 [ RunTime:0.005336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935731 ORDER BY `minOrder` ASC [ RunTime:0.006066s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59935731 ORDER BY `unit` DESC [ RunTime:0.010966s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59935731 LIMIT 2 [ RunTime:0.007735s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59935731 ORDER BY `minOrder` ASC [ RunTime:0.005503s ]
select * from pdf where partno='171822-6' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003827s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '171822-6' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000906s ]
SELECT `id` FROM `stock` WHERE `id` <> 59935731 AND `partno` = '171822-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.010087s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12618443 [ RunTime:0.005383s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60343936 LIMIT 5 [ RunTime:0.002427s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60343936 ORDER BY `minOrder` ASC [ RunTime:0.001251s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60343936 ORDER BY `unit` DESC [ RunTime:0.000941s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60343936 LIMIT 2 [ RunTime:0.004562s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60343936 ORDER BY `minOrder` ASC [ RunTime:0.000542s ]
select * from pdf where partno='1719958-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.001755s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1719958-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.001061s ]
SELECT `id` FROM `stock` WHERE `id` <> 60343936 AND `partno` = '1719958-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.002884s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12609090 [ RunTime:0.009578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 61934659 LIMIT 5 [ RunTime:0.000943s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61934659 ORDER BY `minOrder` ASC [ RunTime:0.004943s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 61934659 ORDER BY `unit` DESC [ RunTime:0.002094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 61934659 LIMIT 2 [ RunTime:0.005079s ]
SELECT * FROM `stock_price` WHERE `stockid` = 61934659 ORDER BY `minOrder` ASC [ RunTime:0.000650s ]
select * from pdf where partno='171-009-203L001' and brandshort='NorComp Inc.' limit 1 [ RunTime:0.003231s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '171-009-203L001' OR `brand` LIKE 'NorComp Inc.%' ) ) LIMIT 1 [ RunTime:0.000807s ]
SELECT `id` FROM `stock` WHERE `id` <> 61934659 AND `partno` = '171-009-203L001' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%norcomp inc.%' ) [ RunTime:0.000966s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11862190 [ RunTime:0.000960s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59437569 LIMIT 5 [ RunTime:0.001768s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59437569 ORDER BY `minOrder` ASC [ RunTime:0.001173s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59437569 ORDER BY `unit` DESC [ RunTime:0.002741s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59437569 LIMIT 2 [ RunTime:0.000731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59437569 ORDER BY `minOrder` ASC [ RunTime:0.000482s ]
select * from pdf where partno='1718571002' and brandshort='Molex' limit 1 [ RunTime:0.000597s ]
select foldpath,foldpath2,filename from pdf_file where id=1521880 limit 1 [ RunTime:0.000440s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1718571002' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.014720s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60343939 LIMIT 5 [ RunTime:0.000678s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60343939 ORDER BY `minOrder` ASC [ RunTime:0.008842s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60343939 ORDER BY `unit` DESC [ RunTime:0.000674s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60343939 LIMIT 2 [ RunTime:0.012085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60343939 ORDER BY `minOrder` ASC [ RunTime:0.005641s ]
select * from pdf where partno='171662-1' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003635s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '171662-1' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.000911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59936301 LIMIT 5 [ RunTime:0.000690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59936301 ORDER BY `minOrder` ASC [ RunTime:0.001110s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59936301 ORDER BY `unit` DESC [ RunTime:0.002387s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59936301 LIMIT 2 [ RunTime:0.000570s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59936301 ORDER BY `minOrder` ASC [ RunTime:0.000744s ]
select * from pdf where partno='1718500400' and brandshort='Molex' limit 1 [ RunTime:0.009029s ]
select foldpath,foldpath2,filename from pdf_file where id=1825559 limit 1 [ RunTime:0.011945s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1718500400' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.011097s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59436114 LIMIT 5 [ RunTime:0.004656s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59436114 ORDER BY `minOrder` ASC [ RunTime:0.002176s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59436114 ORDER BY `unit` DESC [ RunTime:0.000842s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59436114 LIMIT 2 [ RunTime:0.000641s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59436114 ORDER BY `minOrder` ASC [ RunTime:0.002360s ]
select * from pdf where partno='1718560002' and brandshort='Molex' limit 1 [ RunTime:0.001007s ]
select foldpath,foldpath2,filename from pdf_file where id=1609958 limit 1 [ RunTime:0.000527s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1718560002' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.019290s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 59443893 LIMIT 5 [ RunTime:0.001252s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59443893 ORDER BY `minOrder` ASC [ RunTime:0.001052s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 59443893 ORDER BY `unit` DESC [ RunTime:0.008101s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 59443893 LIMIT 2 [ RunTime:0.002547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 59443893 ORDER BY `minOrder` ASC [ RunTime:0.000491s ]
select * from pdf where partno='171825-7' and brandshort='TE Connectivity AMP Connectors' limit 1 [ RunTime:0.003511s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '171825-7' OR `brand` LIKE 'TE Connectivity AMP Connectors%' ) ) LIMIT 1 [ RunTime:0.002777s ]
SELECT `id` FROM `stock` WHERE `id` <> 59443893 AND `partno` = '171825-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity amp connectors%' ) [ RunTime:0.005845s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 19825413 [ RunTime:0.006557s ]
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 '171%' OR `brand` LIKE '171%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.003591s ]
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 '171%' OR `brand` LIKE '171%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.006681s ]
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 '171%' OR `brand` LIKE '171%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001783s ]
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 '171%' OR `brand` LIKE '171%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.009220s ]
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 '171%' OR `brand` LIKE '171%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.010170s ]
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 '171%' OR `brand` LIKE '171%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.001476s ]
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 '171%' OR `brand` LIKE '171%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.000747s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '171%' OR `brand` LIKE '171%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.018595s ]