SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.001669s ]
INSERT INTO `visit_log` SET `ip` = '216.73.216.133' , `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=473&search=1' [ RunTime:0.013566s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001169s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.021090s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001647s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.216.133' ) [ RunTime:0.015202s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002527s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.009163s ]
SHOW FULL COLUMNS FROM `stock_search` [ RunTime:0.001189s ]
SELECT * FROM `stock_search` WHERE `partno` = '473' LIMIT 1 [ RunTime:0.034311s ]
UPDATE `stock_search` SET `count` = 4 , `updatetime` = '2026-08-19 00:24:06' WHERE `partno` = '473' [ RunTime:0.054860s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002540s ]
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 '473%' OR `brand` LIKE '473%' ) ) AND ( (s.platform = 1) ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.079875s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.028689s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13965527 LIMIT 5 [ RunTime:0.019390s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.012902s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13965527 ORDER BY `minOrder` ASC [ RunTime:0.020056s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.018090s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13965527 ORDER BY `unit` DESC [ RunTime:0.020423s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.026402s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13965527 LIMIT 2 [ RunTime:0.050865s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13965527 ORDER BY `minOrder` ASC [ RunTime:0.023321s ]
select * from pdf where partno='473MMR630K' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.015788s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610123 LIMIT 5 [ RunTime:0.019721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610123 ORDER BY `minOrder` ASC [ RunTime:0.016600s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 12610123 ORDER BY `unit` DESC [ RunTime:0.021832s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 12610123 LIMIT 2 [ RunTime:0.012948s ]
SELECT * FROM `stock_price` WHERE `stockid` = 12610123 ORDER BY `minOrder` ASC [ RunTime:0.012145s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13968023 LIMIT 5 [ RunTime:0.021019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13968023 ORDER BY `minOrder` ASC [ RunTime:0.009114s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13968023 ORDER BY `unit` DESC [ RunTime:0.014310s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13968023 LIMIT 2 [ RunTime:0.010188s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13968023 ORDER BY `minOrder` ASC [ RunTime:0.001459s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13947926 LIMIT 5 [ RunTime:0.004440s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13947926 ORDER BY `minOrder` ASC [ RunTime:0.000909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13947926 ORDER BY `unit` DESC [ RunTime:0.015187s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13947926 LIMIT 2 [ RunTime:0.032532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13947926 ORDER BY `minOrder` ASC [ RunTime:0.015239s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14884258 LIMIT 5 [ RunTime:0.016952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14884258 ORDER BY `minOrder` ASC [ RunTime:0.034764s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14884258 ORDER BY `unit` DESC [ RunTime:0.018313s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14884258 LIMIT 2 [ RunTime:0.030117s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14884258 ORDER BY `minOrder` ASC [ RunTime:0.007076s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13112116 LIMIT 5 [ RunTime:0.038604s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13112116 ORDER BY `minOrder` ASC [ RunTime:0.005572s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13112116 ORDER BY `unit` DESC [ RunTime:0.038149s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13112116 LIMIT 2 [ RunTime:0.064306s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13112116 ORDER BY `minOrder` ASC [ RunTime:0.025137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14860167 LIMIT 5 [ RunTime:0.041437s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14860167 ORDER BY `minOrder` ASC [ RunTime:0.022722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14860167 ORDER BY `unit` DESC [ RunTime:0.017046s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14860167 LIMIT 2 [ RunTime:0.054578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14860167 ORDER BY `minOrder` ASC [ RunTime:0.005795s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11932457 LIMIT 5 [ RunTime:0.010173s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11932457 ORDER BY `minOrder` ASC [ RunTime:0.011004s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11932457 ORDER BY `unit` DESC [ RunTime:0.013159s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11932457 LIMIT 2 [ RunTime:0.008373s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11932457 ORDER BY `minOrder` ASC [ RunTime:0.013119s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14857368 LIMIT 5 [ RunTime:0.020384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14857368 ORDER BY `minOrder` ASC [ RunTime:0.023933s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14857368 ORDER BY `unit` DESC [ RunTime:0.012707s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14857368 LIMIT 2 [ RunTime:0.056712s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14857368 ORDER BY `minOrder` ASC [ RunTime:0.018282s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14867996 LIMIT 5 [ RunTime:0.035167s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14867996 ORDER BY `minOrder` ASC [ RunTime:0.010150s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14867996 ORDER BY `unit` DESC [ RunTime:0.020865s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14867996 LIMIT 2 [ RunTime:0.013850s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14867996 ORDER BY `minOrder` ASC [ RunTime:0.034915s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13534958 LIMIT 5 [ RunTime:0.005952s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13534958 ORDER BY `minOrder` ASC [ RunTime:0.028904s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13534958 ORDER BY `unit` DESC [ RunTime:0.010581s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13534958 LIMIT 2 [ RunTime:0.010977s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13534958 ORDER BY `minOrder` ASC [ RunTime:0.016272s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13969069 LIMIT 5 [ RunTime:0.003965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13969069 ORDER BY `minOrder` ASC [ RunTime:0.020769s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13969069 ORDER BY `unit` DESC [ RunTime:0.012463s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13969069 LIMIT 2 [ RunTime:0.008337s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13969069 ORDER BY `minOrder` ASC [ RunTime:0.008943s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14867436 LIMIT 5 [ RunTime:0.023931s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14867436 ORDER BY `minOrder` ASC [ RunTime:0.023249s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14867436 ORDER BY `unit` DESC [ RunTime:0.037427s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14867436 LIMIT 2 [ RunTime:0.022410s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14867436 ORDER BY `minOrder` ASC [ RunTime:0.010648s ]
select * from pdf where partno='473MMR250K' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.044732s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13965597 LIMIT 5 [ RunTime:0.026875s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13965597 ORDER BY `minOrder` ASC [ RunTime:0.038494s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13965597 ORDER BY `unit` DESC [ RunTime:0.065258s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13965597 LIMIT 2 [ RunTime:0.030965s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13965597 ORDER BY `minOrder` ASC [ RunTime:0.026857s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14867415 LIMIT 5 [ RunTime:0.015985s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14867415 ORDER BY `minOrder` ASC [ RunTime:0.031034s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14867415 ORDER BY `unit` DESC [ RunTime:0.052596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14867415 LIMIT 2 [ RunTime:0.054953s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14867415 ORDER BY `minOrder` ASC [ RunTime:0.014501s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14880656 LIMIT 5 [ RunTime:0.010060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14880656 ORDER BY `minOrder` ASC [ RunTime:0.014597s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 14880656 ORDER BY `unit` DESC [ RunTime:0.041547s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 14880656 LIMIT 2 [ RunTime:0.072927s ]
SELECT * FROM `stock_price` WHERE `stockid` = 14880656 ORDER BY `minOrder` ASC [ RunTime:0.004967s ]
select * from pdf where partno='473MMR400K' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.006989s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13955680 LIMIT 5 [ RunTime:0.010185s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13955680 ORDER BY `minOrder` ASC [ RunTime:0.014292s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13955680 ORDER BY `unit` DESC [ RunTime:0.025811s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13955680 LIMIT 2 [ RunTime:0.030277s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13955680 ORDER BY `minOrder` ASC [ RunTime:0.046011s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 2708 LIMIT 5 [ RunTime:0.017266s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2708 ORDER BY `minOrder` ASC [ RunTime:0.019909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 2708 ORDER BY `unit` DESC [ RunTime:0.043455s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 2708 LIMIT 2 [ RunTime:0.072482s ]
SELECT * FROM `stock_price` WHERE `stockid` = 2708 ORDER BY `minOrder` ASC [ RunTime:0.031854s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.001204s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47309-2651' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.030419s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13952429 LIMIT 5 [ RunTime:0.035132s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13952429 ORDER BY `minOrder` ASC [ RunTime:0.042480s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 13952429 ORDER BY `unit` DESC [ RunTime:0.013199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 13952429 LIMIT 2 [ RunTime:0.023718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 13952429 ORDER BY `minOrder` ASC [ RunTime:0.022790s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11857256 LIMIT 5 [ RunTime:0.017808s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11857256 ORDER BY `minOrder` ASC [ RunTime:0.007894s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 11857256 ORDER BY `unit` DESC [ RunTime:0.022952s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 11857256 LIMIT 2 [ RunTime:0.019101s ]
SELECT * FROM `stock_price` WHERE `stockid` = 11857256 ORDER BY `minOrder` ASC [ RunTime:0.014298s ]
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 '473%' OR `brand` LIKE '473%' ) ) AND `s`.`platform` = '2' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.011293s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32257635 LIMIT 5 [ RunTime:0.028147s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257635 ORDER BY `minOrder` ASC [ RunTime:0.025186s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32257635 ORDER BY `unit` DESC [ RunTime:0.018425s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32257635 LIMIT 2 [ RunTime:0.029979s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257635 ORDER BY `minOrder` ASC [ RunTime:0.010289s ]
select * from pdf where partno='47346-0001' and brandshort='molex' limit 1 [ RunTime:0.012805s ]
select foldpath,foldpath2,filename from pdf_file where id=773154 limit 1 [ RunTime:0.021472s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47346-0001' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.027941s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32257989 LIMIT 5 [ RunTime:0.006319s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257989 ORDER BY `minOrder` ASC [ RunTime:0.053541s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32257989 ORDER BY `unit` DESC [ RunTime:0.042737s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32257989 LIMIT 2 [ RunTime:0.036525s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32257989 ORDER BY `minOrder` ASC [ RunTime:0.014395s ]
select * from pdf where partno='47346-1001' and brandshort='molex' limit 1 [ RunTime:0.038207s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47346-1001' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.035440s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32264200 LIMIT 5 [ RunTime:0.014534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32264200 ORDER BY `minOrder` ASC [ RunTime:0.011984s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32264200 ORDER BY `unit` DESC [ RunTime:0.022611s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32264200 LIMIT 2 [ RunTime:0.019056s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32264200 ORDER BY `minOrder` ASC [ RunTime:0.007552s ]
select * from pdf where partno='47352-1001' and brandshort='molex' limit 1 [ RunTime:0.011598s ]
select foldpath,foldpath2,filename from pdf_file where id=852586 limit 1 [ RunTime:0.011704s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47352-1001' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.059219s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32264316 LIMIT 5 [ RunTime:0.033467s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32264316 ORDER BY `minOrder` ASC [ RunTime:0.021815s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32264316 ORDER BY `unit` DESC [ RunTime:0.029068s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32264316 LIMIT 2 [ RunTime:0.064644s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32264316 ORDER BY `minOrder` ASC [ RunTime:0.020296s ]
select * from pdf where partno='47388-2001' and brandshort='molex' limit 1 [ RunTime:0.020875s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47388-2001' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.047786s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32264315 LIMIT 5 [ RunTime:0.036363s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32264315 ORDER BY `minOrder` ASC [ RunTime:0.018685s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32264315 ORDER BY `unit` DESC [ RunTime:0.024682s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32264315 LIMIT 2 [ RunTime:0.011846s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32264315 ORDER BY `minOrder` ASC [ RunTime:0.029776s ]
select * from pdf where partno='47309-2651' and brandshort='molex' limit 1 [ RunTime:0.024990s ]
select foldpath,foldpath2,filename from pdf_file where id=852566 limit 1 [ RunTime:0.036665s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47309-2651' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.022858s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32254679 LIMIT 5 [ RunTime:0.017077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254679 ORDER BY `minOrder` ASC [ RunTime:0.028942s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32254679 ORDER BY `unit` DESC [ RunTime:0.013192s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32254679 LIMIT 2 [ RunTime:0.016780s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32254679 ORDER BY `minOrder` ASC [ RunTime:0.008523s ]
select * from pdf where partno='47306-5001' and brandshort='molex' limit 1 [ RunTime:0.015460s ]
select foldpath,foldpath2,filename from pdf_file where id=852559 limit 1 [ RunTime:0.029932s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47306-5001' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.027162s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32255148 LIMIT 5 [ RunTime:0.015317s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32255148 ORDER BY `minOrder` ASC [ RunTime:0.017084s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32255148 ORDER BY `unit` DESC [ RunTime:0.012394s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32255148 LIMIT 2 [ RunTime:0.010218s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32255148 ORDER BY `minOrder` ASC [ RunTime:0.002233s ]
select * from pdf where partno='47306-5005' and brandshort='molex' limit 1 [ RunTime:0.010970s ]
select foldpath,foldpath2,filename from pdf_file where id=852560 limit 1 [ RunTime:0.008416s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47306-5005' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.013370s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32255147 LIMIT 5 [ RunTime:0.012471s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32255147 ORDER BY `minOrder` ASC [ RunTime:0.019068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32255147 ORDER BY `unit` DESC [ RunTime:0.001191s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32255147 LIMIT 2 [ RunTime:0.015651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32255147 ORDER BY `minOrder` ASC [ RunTime:0.009511s ]
select * from pdf where partno='47306-5002' and brandshort='molex' limit 1 [ RunTime:0.003769s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47306-5002' OR `brand` LIKE 'molex%' ) ) LIMIT 1 [ RunTime:0.018467s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51124728 LIMIT 5 [ RunTime:0.002584s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51124728 ORDER BY `minOrder` ASC [ RunTime:0.003873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51124728 ORDER BY `unit` DESC [ RunTime:0.012282s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51124728 LIMIT 2 [ RunTime:0.009236s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51124728 ORDER BY `minOrder` ASC [ RunTime:0.001298s ]
select * from pdf where partno='473ct-4' and brandshort='semitec' limit 1 [ RunTime:0.003032s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '473ct-4' OR `brand` LIKE 'semitec%' ) ) LIMIT 1 [ RunTime:0.010378s ]
SELECT `id` FROM `stock` WHERE `id` <> 51124728 AND `partno` = '473ct-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%semitec%' ) [ RunTime:0.009646s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32249278 [ RunTime:0.001746s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32249278 LIMIT 5 [ RunTime:0.001031s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32249278 ORDER BY `minOrder` ASC [ RunTime:0.002873s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32249278 ORDER BY `unit` DESC [ RunTime:0.005414s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32249278 LIMIT 2 [ RunTime:0.001772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32249278 ORDER BY `minOrder` ASC [ RunTime:0.004010s ]
select * from pdf where partno='473ct-4' and brandshort='semitec' limit 1 [ RunTime:0.008707s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '473ct-4' OR `brand` LIKE 'semitec%' ) ) LIMIT 1 [ RunTime:0.000342s ]
SELECT `id` FROM `stock` WHERE `id` <> 32249278 AND `partno` = '473ct-4' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%semitec%' ) [ RunTime:0.002600s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51124728 [ RunTime:0.001192s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51097065 LIMIT 5 [ RunTime:0.000873s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51097065 ORDER BY `minOrder` ASC [ RunTime:0.002889s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51097065 ORDER BY `unit` DESC [ RunTime:0.000560s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51097065 LIMIT 2 [ RunTime:0.000453s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51097065 ORDER BY `minOrder` ASC [ RunTime:0.000261s ]
select * from pdf where partno='4735' and brandshort='adafruit' limit 1 [ RunTime:0.006021s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4735' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.007273s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51097062 LIMIT 5 [ RunTime:0.003086s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51097062 ORDER BY `minOrder` ASC [ RunTime:0.000550s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51097062 ORDER BY `unit` DESC [ RunTime:0.001599s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51097062 LIMIT 2 [ RunTime:0.013413s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51097062 ORDER BY `minOrder` ASC [ RunTime:0.005619s ]
select * from pdf where partno='473' and brandshort='adafruit' limit 1 [ RunTime:0.005423s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '473' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.001068s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51097064 LIMIT 5 [ RunTime:0.001848s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51097064 ORDER BY `minOrder` ASC [ RunTime:0.008200s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51097064 ORDER BY `unit` DESC [ RunTime:0.002094s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51097064 LIMIT 2 [ RunTime:0.001336s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51097064 ORDER BY `minOrder` ASC [ RunTime:0.000389s ]
select * from pdf where partno='4733' and brandshort='adafruit' limit 1 [ RunTime:0.000600s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4733' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.002214s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51097063 LIMIT 5 [ RunTime:0.004652s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51097063 ORDER BY `minOrder` ASC [ RunTime:0.003803s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51097063 ORDER BY `unit` DESC [ RunTime:0.001497s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51097063 LIMIT 2 [ RunTime:0.001085s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51097063 ORDER BY `minOrder` ASC [ RunTime:0.005426s ]
select * from pdf where partno='4732' and brandshort='adafruit' limit 1 [ RunTime:0.001196s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4732' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.008136s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 51097066 LIMIT 5 [ RunTime:0.010212s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51097066 ORDER BY `minOrder` ASC [ RunTime:0.006435s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 51097066 ORDER BY `unit` DESC [ RunTime:0.000861s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 51097066 LIMIT 2 [ RunTime:0.000585s ]
SELECT * FROM `stock_price` WHERE `stockid` = 51097066 ORDER BY `minOrder` ASC [ RunTime:0.000424s ]
select * from pdf where partno='4736' and brandshort='adafruit' limit 1 [ RunTime:0.002470s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4736' OR `brand` LIKE 'adafruit%' ) ) LIMIT 1 [ RunTime:0.002353s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32270644 LIMIT 5 [ RunTime:0.001961s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270644 ORDER BY `minOrder` ASC [ RunTime:0.001239s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 32270644 ORDER BY `unit` DESC [ RunTime:0.000632s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 32270644 LIMIT 2 [ RunTime:0.000571s ]
SELECT * FROM `stock_price` WHERE `stockid` = 32270644 ORDER BY `minOrder` ASC [ RunTime:0.000754s ]
select * from pdf where partno='473270-e' and brandshort='te connectivity / erni' limit 1 [ RunTime:0.001523s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '473270-e' OR `brand` LIKE 'te connectivity / erni%' ) ) LIMIT 1 [ RunTime:0.000725s ]
SELECT `id` FROM `stock` WHERE `id` <> 32270644 AND `partno` = '473270-e' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%te connectivity / erni%' ) [ RunTime:0.001377s ]
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 '473%' OR `brand` LIKE '473%' ) ) AND `s`.`platform` = '3' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.016775s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40307226 LIMIT 5 [ RunTime:0.000661s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40307226 ORDER BY `minOrder` ASC [ RunTime:0.000957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40307226 ORDER BY `unit` DESC [ RunTime:0.006144s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40307226 LIMIT 2 [ RunTime:0.000718s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40307226 ORDER BY `minOrder` ASC [ RunTime:0.000296s ]
select * from pdf where partno='473MMR630K' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.000738s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '473MMR630K' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.000531s ]
SELECT `id` FROM `stock` WHERE `id` <> 40307226 AND `partno` = '473MMR630K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.007428s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13965527 [ RunTime:0.000485s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40307466 LIMIT 5 [ RunTime:0.002160s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40307466 ORDER BY `minOrder` ASC [ RunTime:0.008014s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40307466 ORDER BY `unit` DESC [ RunTime:0.000839s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40307466 LIMIT 2 [ RunTime:0.000569s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40307466 ORDER BY `minOrder` ASC [ RunTime:0.000283s ]
select * from pdf where partno='473MSR250K' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.004339s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '473MSR250K' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.000686s ]
SELECT `id` FROM `stock` WHERE `id` <> 40307466 AND `partno` = '473MSR250K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.001778s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13947926 [ RunTime:0.005872s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40315880 LIMIT 5 [ RunTime:0.001368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40315880 ORDER BY `minOrder` ASC [ RunTime:0.004394s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40315880 ORDER BY `unit` DESC [ RunTime:0.000582s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40315880 LIMIT 2 [ RunTime:0.001869s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40315880 ORDER BY `minOrder` ASC [ RunTime:0.005202s ]
select * from pdf where partno='473MKP275KCLL' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.009024s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '473MKP275KCLL' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.005094s ]
SELECT `id` FROM `stock` WHERE `id` <> 40315880 AND `partno` = '473MKP275KCLL' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.000705s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17535015 [ RunTime:0.001572s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40312844 LIMIT 5 [ RunTime:0.002521s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40312844 ORDER BY `minOrder` ASC [ RunTime:0.000957s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40312844 ORDER BY `unit` DESC [ RunTime:0.003728s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40312844 LIMIT 2 [ RunTime:0.000557s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40312844 ORDER BY `minOrder` ASC [ RunTime:0.000335s ]
select * from pdf where partno='473MKP275KC' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.002387s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '473MKP275KC' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.000556s ]
SELECT `id` FROM `stock` WHERE `id` <> 40312844 AND `partno` = '473MKP275KC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.000578s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13968023 [ RunTime:0.001317s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62121487 LIMIT 5 [ RunTime:0.000823s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62121487 ORDER BY `minOrder` ASC [ RunTime:0.001602s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62121487 ORDER BY `unit` DESC [ RunTime:0.000390s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62121487 LIMIT 2 [ RunTime:0.000351s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62121487 ORDER BY `minOrder` ASC [ RunTime:0.000301s ]
select * from pdf where partno='47306-5002' and brandshort='Molex' limit 1 [ RunTime:0.000549s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47306-5002' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.008026s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60345729 LIMIT 5 [ RunTime:0.004312s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60345729 ORDER BY `minOrder` ASC [ RunTime:0.005811s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60345729 ORDER BY `unit` DESC [ RunTime:0.004634s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60345729 LIMIT 2 [ RunTime:0.007281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60345729 ORDER BY `minOrder` ASC [ RunTime:0.004596s ]
select * from pdf where partno='47389-000LF' and brandshort='Amphenol ICC FCI' limit 1 [ RunTime:0.001849s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47389-000LF' OR `brand` LIKE 'Amphenol ICC (FCI)%' ) ) LIMIT 1 [ RunTime:0.003917s ]
SELECT `id` FROM `stock` WHERE `id` <> 60345729 AND `partno` = '47389-000LF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amphenol icc%' ) [ RunTime:0.003287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12610123 [ RunTime:0.001320s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 60992339 LIMIT 5 [ RunTime:0.000401s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60992339 ORDER BY `minOrder` ASC [ RunTime:0.006024s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 60992339 ORDER BY `unit` DESC [ RunTime:0.003363s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 60992339 LIMIT 2 [ RunTime:0.002254s ]
SELECT * FROM `stock_price` WHERE `stockid` = 60992339 ORDER BY `minOrder` ASC [ RunTime:0.000548s ]
select * from pdf where partno='47388-2001-TR200' and brandshort='Molex' limit 1 [ RunTime:0.000742s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47388-2001-TR200' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.010083s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 62121483 LIMIT 5 [ RunTime:0.006166s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62121483 ORDER BY `minOrder` ASC [ RunTime:0.006514s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 62121483 ORDER BY `unit` DESC [ RunTime:0.002364s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 62121483 LIMIT 2 [ RunTime:0.003988s ]
SELECT * FROM `stock_price` WHERE `stockid` = 62121483 ORDER BY `minOrder` ASC [ RunTime:0.007057s ]
select * from pdf where partno='47300-1022' and brandshort='Molex' limit 1 [ RunTime:0.000634s ]
select foldpath,foldpath2,filename from pdf_file where id=691148 limit 1 [ RunTime:0.002699s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '47300-1022' OR `brand` LIKE 'Molex%' ) ) LIMIT 1 [ RunTime:0.008030s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58144270 LIMIT 5 [ RunTime:0.000414s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58144270 ORDER BY `minOrder` ASC [ RunTime:0.004590s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58144270 ORDER BY `unit` DESC [ RunTime:0.001243s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58144270 LIMIT 2 [ RunTime:0.002206s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58144270 ORDER BY `minOrder` ASC [ RunTime:0.002844s ]
select * from pdf where partno='473471A.101-BO' and brandshort='BlueOptics by CBO GmbH' limit 1 [ RunTime:0.002688s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '473471A.101-BO' OR `brand` LIKE 'BlueOptics by CBO GmbH%' ) ) LIMIT 1 [ RunTime:0.007169s ]
SELECT `id` FROM `stock` WHERE `id` <> 58144270 AND `partno` = '473471A.101-BO' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%blueoptics by cbo gmbh%' ) [ RunTime:0.003911s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58144252 LIMIT 5 [ RunTime:0.000367s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58144252 ORDER BY `minOrder` ASC [ RunTime:0.000729s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58144252 ORDER BY `unit` DESC [ RunTime:0.000587s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58144252 LIMIT 2 [ RunTime:0.000383s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58144252 ORDER BY `minOrder` ASC [ RunTime:0.000247s ]
select * from pdf where partno='473842A-BO' and brandshort='BlueOptics by CBO GmbH' limit 1 [ RunTime:0.003102s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '473842A-BO' OR `brand` LIKE 'BlueOptics by CBO GmbH%' ) ) LIMIT 1 [ RunTime:0.000638s ]
SELECT `id` FROM `stock` WHERE `id` <> 58144252 AND `partno` = '473842A-BO' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%blueoptics by cbo gmbh%' ) [ RunTime:0.000490s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58146540 LIMIT 5 [ RunTime:0.000360s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58146540 ORDER BY `minOrder` ASC [ RunTime:0.012648s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58146540 ORDER BY `unit` DESC [ RunTime:0.011138s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58146540 LIMIT 2 [ RunTime:0.000428s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58146540 ORDER BY `minOrder` ASC [ RunTime:0.009064s ]
select * from pdf where partno='473472A-BO' and brandshort='BlueOptics by CBO GmbH' limit 1 [ RunTime:0.012298s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '473472A-BO' OR `brand` LIKE 'BlueOptics by CBO GmbH%' ) ) LIMIT 1 [ RunTime:0.012795s ]
SELECT `id` FROM `stock` WHERE `id` <> 58146540 AND `partno` = '473472A-BO' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%blueoptics by cbo gmbh%' ) [ RunTime:0.002933s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40307979 LIMIT 5 [ RunTime:0.017731s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40307979 ORDER BY `minOrder` ASC [ RunTime:0.007862s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40307979 ORDER BY `unit` DESC [ RunTime:0.011055s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40307979 LIMIT 2 [ RunTime:0.002721s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40307979 ORDER BY `minOrder` ASC [ RunTime:0.002018s ]
select * from pdf where partno='473MWR400K' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.013301s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '473MWR400K' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.003659s ]
SELECT `id` FROM `stock` WHERE `id` <> 40307979 AND `partno` = '473MWR400K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.001560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14860167 [ RunTime:0.005779s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40307998 LIMIT 5 [ RunTime:0.000655s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40307998 ORDER BY `minOrder` ASC [ RunTime:0.014822s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40307998 ORDER BY `unit` DESC [ RunTime:0.001071s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40307998 LIMIT 2 [ RunTime:0.000779s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40307998 ORDER BY `minOrder` ASC [ RunTime:0.000330s ]
select * from pdf where partno='473MWR630K' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.008019s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '473MWR630K' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.015998s ]
SELECT `id` FROM `stock` WHERE `id` <> 40307998 AND `partno` = '473MWR630K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.013362s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13955680 [ RunTime:0.011583s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40307921 LIMIT 5 [ RunTime:0.021659s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40307921 ORDER BY `minOrder` ASC [ RunTime:0.010725s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40307921 ORDER BY `unit` DESC [ RunTime:0.026912s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40307921 LIMIT 2 [ RunTime:0.021090s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40307921 ORDER BY `minOrder` ASC [ RunTime:0.006751s ]
select * from pdf where partno='473MWR250K' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.027911s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '473MWR250K' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.002849s ]
SELECT `id` FROM `stock` WHERE `id` <> 40307921 AND `partno` = '473MWR250K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.006414s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14857368 [ RunTime:0.014962s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40316583 LIMIT 5 [ RunTime:0.041384s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40316583 ORDER BY `minOrder` ASC [ RunTime:0.030790s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40316583 ORDER BY `unit` DESC [ RunTime:0.002483s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40316583 LIMIT 2 [ RunTime:0.000370s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40316583 ORDER BY `minOrder` ASC [ RunTime:0.000262s ]
select * from pdf where partno='473PPB162KB' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.036185s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '473PPB162KB' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.021987s ]
SELECT `id` FROM `stock` WHERE `id` <> 40316583 AND `partno` = '473PPB162KB' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.037502s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13969069 [ RunTime:0.051234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40309229 LIMIT 5 [ RunTime:0.033281s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40309229 ORDER BY `minOrder` ASC [ RunTime:0.036632s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40309229 ORDER BY `unit` DESC [ RunTime:0.031441s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40309229 LIMIT 2 [ RunTime:0.031108s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40309229 ORDER BY `minOrder` ASC [ RunTime:0.042033s ]
select * from pdf where partno='473MMR250K' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.022120s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '473MMR250K' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.017003s ]
SELECT `id` FROM `stock` WHERE `id` <> 40309229 AND `partno` = '473MMR250K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.068257s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14867436 [ RunTime:0.034719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58726304 LIMIT 5 [ RunTime:0.030335s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58726304 ORDER BY `minOrder` ASC [ RunTime:0.017362s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58726304 ORDER BY `unit` DESC [ RunTime:0.003910s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58726304 LIMIT 2 [ RunTime:0.035819s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58726304 ORDER BY `minOrder` ASC [ RunTime:0.009444s ]
select * from pdf where partno='4735.0000' and brandshort='SCHURTER Inc.' limit 1 [ RunTime:0.016450s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4735.0000' OR `brand` LIKE 'SCHURTER Inc.%' ) ) LIMIT 1 [ RunTime:0.012200s ]
SELECT `id` FROM `stock` WHERE `id` <> 58726304 AND `partno` = '4735.0000' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%schurter inc.%' ) [ RunTime:0.005303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13112116 [ RunTime:0.003086s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 63109049 LIMIT 5 [ RunTime:0.010648s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63109049 ORDER BY `minOrder` ASC [ RunTime:0.006744s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 63109049 ORDER BY `unit` DESC [ RunTime:0.003206s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 63109049 LIMIT 2 [ RunTime:0.003013s ]
SELECT * FROM `stock_price` WHERE `stockid` = 63109049 ORDER BY `minOrder` ASC [ RunTime:0.012147s ]
select * from pdf where partno='4733050001' and brandshort='TE Connectivity' limit 1 [ RunTime:0.003267s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '4733050001' OR `brand` LIKE 'TE Connectivity%' ) ) LIMIT 1 [ RunTime:0.027905s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40309519 LIMIT 5 [ RunTime:0.005639s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40309519 ORDER BY `minOrder` ASC [ RunTime:0.018392s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40309519 ORDER BY `unit` DESC [ RunTime:0.003949s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40309519 LIMIT 2 [ RunTime:0.016049s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40309519 ORDER BY `minOrder` ASC [ RunTime:0.002241s ]
select * from pdf where partno='473MKP275KD' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.012316s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '473MKP275KD' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.007018s ]
SELECT `id` FROM `stock` WHERE `id` <> 40309519 AND `partno` = '473MKP275KD' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.001183s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14867996 [ RunTime:0.003043s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 40313953 LIMIT 5 [ RunTime:0.007617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40313953 ORDER BY `minOrder` ASC [ RunTime:0.042719s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 40313953 ORDER BY `unit` DESC [ RunTime:0.006212s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 40313953 LIMIT 2 [ RunTime:0.000916s ]
SELECT * FROM `stock_price` WHERE `stockid` = 40313953 ORDER BY `minOrder` ASC [ RunTime:0.000530s ]
select * from pdf where partno='473PPB102K' and brandshort='Cornell Dubilier Knowles' limit 1 [ RunTime:0.002222s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '473PPB102K' OR `brand` LIKE 'Cornell Dubilier Knowles%' ) ) LIMIT 1 [ RunTime:0.008756s ]
SELECT `id` FROM `stock` WHERE `id` <> 40313953 AND `partno` = '473PPB102K' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%cornell dubilier knowles%' ) [ RunTime:0.002621s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13965597 [ RunTime:0.005267s ]
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 '473%' OR `brand` LIKE '473%' ) ) AND `s`.`platform` = '4' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.005764s ]
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 '473%' OR `brand` LIKE '473%' ) ) AND `s`.`platform` = '5' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008694s ]
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 '473%' OR `brand` LIKE '473%' ) ) AND `s`.`platform` = '6' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002693s ]
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 '473%' OR `brand` LIKE '473%' ) ) AND `s`.`platform` = '7' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.008137s ]
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 '473%' OR `brand` LIKE '473%' ) ) AND `s`.`platform` = '8' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.002142s ]
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 '473%' OR `brand` LIKE '473%' ) ) AND `s`.`platform` = '9' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.004282s ]
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 '473%' OR `brand` LIKE '473%' ) ) AND `s`.`platform` = '10' ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 0,20 [ RunTime:0.017796s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 58019308 LIMIT 5 [ RunTime:0.072481s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019308 ORDER BY `minOrder` ASC [ RunTime:0.064515s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 58019308 ORDER BY `unit` DESC [ RunTime:0.028269s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 58019308 LIMIT 2 [ RunTime:0.013187s ]
SELECT * FROM `stock_price` WHERE `stockid` = 58019308 ORDER BY `minOrder` ASC [ RunTime:0.005757s ]
select * from pdf where partno='473092651' and brandshort='MOLEX' limit 1 [ RunTime:0.004255s ]
select foldpath,foldpath2,filename from pdf_file where id=852565 limit 1 [ RunTime:0.038546s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '473092651' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.060183s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND ( `partno` LIKE '473%' OR `brand` LIKE '473%' ) ) AND ( (s.platform = 1) ) [ RunTime:0.004981s ]