SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.002659s ]
INSERT INTO `visit_log` SET `ip` = '216.73.217.46' , `useragent` = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' , `reffer` = '' , `host` = 'https://www.ic118.com/stock&page=8&srecordnum=1120&status=4' [ RunTime:0.007073s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.002118s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.009971s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.002319s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.009824s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.003376s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.006448s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002771s ]
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 `s`.`status` = '4' AND `s`.`status` <> '2' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 140,20 [ RunTime:0.030860s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.007218s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16113 LIMIT 4 [ RunTime:0.014359s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.002980s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16113 ORDER BY `minOrder` ASC [ RunTime:0.030901s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.013161s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16113 ORDER BY `unit` DESC [ RunTime:0.018684s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.011155s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16113 LIMIT 2 [ RunTime:0.014026s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16113 ORDER BY `minOrder` ASC [ RunTime:0.017494s ]
select * from pdf where partno='GCM21BR71C475KA73L' and brandshort='MURATA' limit 1 [ RunTime:0.009011s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002231s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GCM21BR71C475KA73L' OR `brand` LIKE 'MURATA%' ) ) LIMIT 1 [ RunTime:0.024157s ]
SELECT `id` FROM `stock` WHERE `id` <> 16113 AND `partno` = 'GCM21BR71C475KA73L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murata%' ) [ RunTime:0.025416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8437 [ RunTime:0.012123s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17131 [ RunTime:0.011052s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14041703 [ RunTime:0.008205s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16112 LIMIT 4 [ RunTime:0.016824s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16112 ORDER BY `minOrder` ASC [ RunTime:0.004068s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16112 ORDER BY `unit` DESC [ RunTime:0.006651s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16112 LIMIT 2 [ RunTime:0.006443s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16112 ORDER BY `minOrder` ASC [ RunTime:0.000497s ]
select * from pdf where partno='192990-0050' and brandshort='ITT CANNON' limit 1 [ RunTime:0.038838s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '192990-0050' OR `brand` LIKE 'ITT CANNON%' ) ) LIMIT 1 [ RunTime:0.043607s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16111 LIMIT 4 [ RunTime:0.037572s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16111 ORDER BY `minOrder` ASC [ RunTime:0.024485s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16111 ORDER BY `unit` DESC [ RunTime:0.053676s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16111 LIMIT 2 [ RunTime:0.030558s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16111 ORDER BY `minOrder` ASC [ RunTime:0.006438s ]
select * from pdf where partno='73138-5033' and brandshort='MOLEX' limit 1 [ RunTime:0.029180s ]
select foldpath,foldpath2,filename from pdf_file where id=1855483 limit 1 [ RunTime:0.009620s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '73138-5033' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.034489s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16110 LIMIT 4 [ RunTime:0.006378s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16110 ORDER BY `minOrder` ASC [ RunTime:0.001347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16110 ORDER BY `unit` DESC [ RunTime:0.011706s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16110 LIMIT 2 [ RunTime:0.013104s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16110 ORDER BY `minOrder` ASC [ RunTime:0.003082s ]
select * from pdf where partno='BC817,215' and brandshort='NEXPERIA' limit 1 [ RunTime:0.009938s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817,215' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.016749s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16109 LIMIT 4 [ RunTime:0.004119s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16109 ORDER BY `minOrder` ASC [ RunTime:0.001595s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16109 ORDER BY `unit` DESC [ RunTime:0.002488s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16109 LIMIT 2 [ RunTime:0.002704s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16109 ORDER BY `minOrder` ASC [ RunTime:0.000962s ]
select * from pdf where partno='FCH47N60NF' and brandshort='ONSEMI' limit 1 [ RunTime:0.004120s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FCH47N60NF' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.002150s ]
SELECT `id` FROM `stock` WHERE `id` <> 16109 AND `partno` = 'FCH47N60NF' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.004016s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5007 [ RunTime:0.001250s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17127 [ RunTime:0.000997s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16108 LIMIT 4 [ RunTime:0.006221s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16108 ORDER BY `minOrder` ASC [ RunTime:0.008215s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16108 ORDER BY `unit` DESC [ RunTime:0.006368s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16108 LIMIT 2 [ RunTime:0.001764s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16108 ORDER BY `minOrder` ASC [ RunTime:0.003597s ]
select * from pdf where partno='801-87-002-10-001101' and brandshort='PRECI-DIP' limit 1 [ RunTime:0.007953s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '801-87-002-10-001101' OR `brand` LIKE 'PRECI-DIP%' ) ) LIMIT 1 [ RunTime:0.009280s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16107 LIMIT 4 [ RunTime:0.001615s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16107 ORDER BY `minOrder` ASC [ RunTime:0.003923s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16107 ORDER BY `unit` DESC [ RunTime:0.003953s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16107 LIMIT 2 [ RunTime:0.002650s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16107 ORDER BY `minOrder` ASC [ RunTime:0.009586s ]
select * from pdf where partno='PA4339.101NLT' and brandshort='PULSE ELECTRONICS' limit 1 [ RunTime:0.003972s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PA4339.101NLT' OR `brand` LIKE 'PULSE ELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.011246s ]
SELECT `id` FROM `stock` WHERE `id` <> 16107 AND `partno` = 'PA4339.101NLT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%pulse electronics%' ) [ RunTime:0.002895s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13283 [ RunTime:0.002048s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17125 [ RunTime:0.005528s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 13204283 [ RunTime:0.009256s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16106 LIMIT 4 [ RunTime:0.009658s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16106 ORDER BY `minOrder` ASC [ RunTime:0.023655s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16106 ORDER BY `unit` DESC [ RunTime:0.018285s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16106 LIMIT 2 [ RunTime:0.013539s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16106 ORDER BY `minOrder` ASC [ RunTime:0.008652s ]
select * from pdf where partno='FDI14-250Q' and brandshort='3M' limit 1 [ RunTime:0.014470s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'FDI14-250Q' OR `brand` LIKE '3M%' ) ) LIMIT 1 [ RunTime:0.035647s ]
SELECT `id` FROM `stock` WHERE `id` <> 16106 AND `partno` = 'FDI14-250Q' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%3m%' ) [ RunTime:0.072719s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5565 [ RunTime:0.010266s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17124 [ RunTime:0.006077s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 12516449 [ RunTime:0.007585s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16105 LIMIT 4 [ RunTime:0.007690s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16105 ORDER BY `minOrder` ASC [ RunTime:0.009741s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16105 ORDER BY `unit` DESC [ RunTime:0.035810s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16105 LIMIT 2 [ RunTime:0.016265s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16105 ORDER BY `minOrder` ASC [ RunTime:0.015126s ]
select * from pdf where partno='CRCW08056K80FKEAHP' and brandshort='VISHAY' limit 1 [ RunTime:0.021263s ]
select foldpath,foldpath2,filename from pdf_file where id=1917807 limit 1 [ RunTime:0.015093s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'CRCW08056K80FKEAHP' OR `brand` LIKE 'VISHAY%' ) ) LIMIT 1 [ RunTime:0.046677s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16104 LIMIT 4 [ RunTime:0.048797s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16104 ORDER BY `minOrder` ASC [ RunTime:0.010909s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16104 ORDER BY `unit` DESC [ RunTime:0.013250s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16104 LIMIT 2 [ RunTime:0.074037s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16104 ORDER BY `minOrder` ASC [ RunTime:0.013142s ]
select * from pdf where partno='1-1827872-7' and brandshort='TE CONNECTIVITY' limit 1 [ RunTime:0.038867s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1-1827872-7' OR `brand` LIKE 'TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.050313s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16103 LIMIT 4 [ RunTime:0.028534s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16103 ORDER BY `minOrder` ASC [ RunTime:0.020978s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16103 ORDER BY `unit` DESC [ RunTime:0.014404s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16103 LIMIT 2 [ RunTime:0.035058s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16103 ORDER BY `minOrder` ASC [ RunTime:0.009373s ]
select * from pdf where partno='1-2201855-1' and brandshort='TE CONNECTIVITY' limit 1 [ RunTime:0.008748s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1-2201855-1' OR `brand` LIKE 'TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.053392s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16102 LIMIT 4 [ RunTime:0.028547s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16102 ORDER BY `minOrder` ASC [ RunTime:0.018347s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16102 ORDER BY `unit` DESC [ RunTime:0.016916s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16102 LIMIT 2 [ RunTime:0.029325s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16102 ORDER BY `minOrder` ASC [ RunTime:0.001864s ]
select * from pdf where partno='ZSC31014KITV2P1' and brandshort='RENESAS' limit 1 [ RunTime:0.010795s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ZSC31014KITV2P1' OR `brand` LIKE 'RENESAS%' ) ) LIMIT 1 [ RunTime:0.014919s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16101 LIMIT 4 [ RunTime:0.023379s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16101 ORDER BY `minOrder` ASC [ RunTime:0.016798s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16101 ORDER BY `unit` DESC [ RunTime:0.012766s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16101 LIMIT 2 [ RunTime:0.031330s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16101 ORDER BY `minOrder` ASC [ RunTime:0.006262s ]
select * from pdf where partno='TAJD107K020RNJ' and brandshort='KYOCERA AVX' limit 1 [ RunTime:0.022202s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TAJD107K020RNJ' OR `brand` LIKE 'KYOCERA AVX%' ) ) LIMIT 1 [ RunTime:0.018101s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16100 LIMIT 4 [ RunTime:0.019755s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16100 ORDER BY `minOrder` ASC [ RunTime:0.034363s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16100 ORDER BY `unit` DESC [ RunTime:0.015596s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16100 LIMIT 2 [ RunTime:0.018578s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16100 ORDER BY `minOrder` ASC [ RunTime:0.001147s ]
select * from pdf where partno='206043-1' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.044123s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '206043-1' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.031000s ]
SELECT `id` FROM `stock` WHERE `id` <> 16100 AND `partno` = '206043-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amp - te connectivity%' ) [ RunTime:0.012137s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 235 [ RunTime:0.070001s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17118 [ RunTime:0.093287s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16099 LIMIT 4 [ RunTime:0.034860s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16099 ORDER BY `minOrder` ASC [ RunTime:0.030348s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16099 ORDER BY `unit` DESC [ RunTime:0.018081s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16099 LIMIT 2 [ RunTime:0.034134s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16099 ORDER BY `minOrder` ASC [ RunTime:0.015484s ]
select * from pdf where partno='GJM1555C1H110GB01D' and brandshort='MURATA' limit 1 [ RunTime:0.013340s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GJM1555C1H110GB01D' OR `brand` LIKE 'MURATA%' ) ) LIMIT 1 [ RunTime:0.033394s ]
SELECT `id` FROM `stock` WHERE `id` <> 16099 AND `partno` = 'GJM1555C1H110GB01D' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murata%' ) [ RunTime:0.034765s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11152 [ RunTime:0.014172s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17117 [ RunTime:0.041125s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14043786 [ RunTime:0.041876s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16098 LIMIT 4 [ RunTime:0.020350s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16098 ORDER BY `minOrder` ASC [ RunTime:0.006559s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16098 ORDER BY `unit` DESC [ RunTime:0.021606s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16098 LIMIT 2 [ RunTime:0.000882s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16098 ORDER BY `minOrder` ASC [ RunTime:0.002084s ]
select * from pdf where partno='LDEED3470MA0N00' and brandshort='KEMET' limit 1 [ RunTime:0.025497s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LDEED3470MA0N00' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.028517s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16097 LIMIT 4 [ RunTime:0.040019s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16097 ORDER BY `minOrder` ASC [ RunTime:0.039278s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16097 ORDER BY `unit` DESC [ RunTime:0.064630s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16097 LIMIT 2 [ RunTime:0.066368s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16097 ORDER BY `minOrder` ASC [ RunTime:0.019736s ]
select * from pdf where partno='76823-0343' and brandshort='MOLEX' limit 1 [ RunTime:0.027577s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '76823-0343' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.054260s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16096 LIMIT 4 [ RunTime:0.058817s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16096 ORDER BY `minOrder` ASC [ RunTime:0.021120s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16096 ORDER BY `unit` DESC [ RunTime:0.039199s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16096 LIMIT 2 [ RunTime:0.037984s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16096 ORDER BY `minOrder` ASC [ RunTime:0.012336s ]
select * from pdf where partno='BZV55-C3V3,115' and brandshort='NEXPERIA' limit 1 [ RunTime:0.021568s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BZV55-C3V3,115' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.033640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16095 LIMIT 4 [ RunTime:0.010441s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16095 ORDER BY `minOrder` ASC [ RunTime:0.006722s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16095 ORDER BY `unit` DESC [ RunTime:0.013784s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16095 LIMIT 2 [ RunTime:0.023189s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16095 ORDER BY `minOrder` ASC [ RunTime:0.011072s ]
select * from pdf where partno='19-09-1029' and brandshort='MOLEX' limit 1 [ RunTime:0.009315s ]
select foldpath,foldpath2,filename from pdf_file where id=680427 limit 1 [ RunTime:0.008784s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19-09-1029' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.014850s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16094 LIMIT 4 [ RunTime:0.015195s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16094 ORDER BY `minOrder` ASC [ RunTime:0.011216s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16094 ORDER BY `unit` DESC [ RunTime:0.049978s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16094 LIMIT 2 [ RunTime:0.010651s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16094 ORDER BY `minOrder` ASC [ RunTime:0.018512s ]
select * from pdf where partno='MP-13-29-7' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.015697s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MP-13-29-7' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.019531s ]
SELECT `id` FROM `stock` WHERE `id` <> 16094 AND `partno` = 'MP-13-29-7' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%multicomp pro%' ) [ RunTime:0.074153s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 908 [ RunTime:0.051511s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17112 [ RunTime:0.020051s ]
SELECT COUNT(*) AS think_count FROM `stock` `s` LEFT JOIN `product_type` `t` ON `t`.`id`=`s`.`categoryid` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`status` = '4' AND `s`.`status` <> '2' ) ORDER BY `s`.`stockNum` DESC,`s`.`id` DESC LIMIT 140,20 [ RunTime:0.038463s ]
SELECT brand, count(*) as count FROM ( SELECT `brand` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`status` = '4' AND `s`.`status` <> '2' ) ) tmp GROUP BY `brand` [ RunTime:0.021713s ]
SELECT DISTINCT `categoryid` FROM `stock` `s` WHERE ( `lockUser` = 0 AND `isDisplay` = 1 AND `s`.`status` = '4' AND `s`.`status` <> '2' ) AND `categoryid` > 0 [ RunTime:0.002063s ]
SELECT `id`,`typeid`,`name` FROM `product_type` WHERE `id` IN (21,17,252,16,29,132,127,117,40,481,541,282,671,615,23,577,20,86,377,313,156,148,204,636,39,643,410,113,186,544,369,516,277,134,601,347,105,482,623,133,121,106,432,512,592,326,35,279,152,309,403,517,376,676,296,287,420,490,621,293) [ RunTime:0.017185s ]