SHOW FULL COLUMNS FROM `visit_log` [ RunTime:0.003621s ]
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=7&srecordnum=1120&status=4' [ RunTime:0.021916s ]
SHOW FULL COLUMNS FROM `product_type` [ RunTime:0.001597s ]
SELECT `id`,`typeid`,`name`,`typestr` FROM `product_type` WHERE `id` NOT IN (11,12,13,14,15) AND `id` <= 750 [ RunTime:0.003616s ]
SHOW FULL COLUMNS FROM `o_cart` [ RunTime:0.001284s ]
SELECT COUNT(*) AS think_count FROM `o_cart` WHERE ( `userId` = 0 AND `visitIP` = '216.73.217.46' ) [ RunTime:0.027691s ]
SHOW FULL COLUMNS FROM `ad` [ RunTime:0.002443s ]
SELECT * FROM `ad` WHERE `isDisplay` = 1 [ RunTime:0.000428s ]
SHOW FULL COLUMNS FROM `stock` [ RunTime:0.002730s ]
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 120,20 [ RunTime:0.135790s ]
SHOW FULL COLUMNS FROM `stock_pra` [ RunTime:0.099640s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16133 LIMIT 4 [ RunTime:0.088870s ]
SHOW FULL COLUMNS FROM `stock_price` [ RunTime:0.004749s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16133 ORDER BY `minOrder` ASC [ RunTime:0.038390s ]
SHOW FULL COLUMNS FROM `stock_unitquantity` [ RunTime:0.017061s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16133 ORDER BY `unit` DESC [ RunTime:0.039400s ]
SHOW FULL COLUMNS FROM `stock_warehousequantity` [ RunTime:0.027003s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16133 LIMIT 2 [ RunTime:0.069532s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16133 ORDER BY `minOrder` ASC [ RunTime:0.008867s ]
select * from pdf where partno='LNK3604P' and brandshort='POWER INTEGRATIONS' limit 1 [ RunTime:0.054893s ]
SHOW FULL COLUMNS FROM `stock_pra_lib` [ RunTime:0.002702s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'LNK3604P' OR `brand` LIKE 'POWER INTEGRATIONS%' ) ) LIMIT 1 [ RunTime:0.049748s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16132 LIMIT 4 [ RunTime:0.042303s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16132 ORDER BY `minOrder` ASC [ RunTime:0.030464s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16132 ORDER BY `unit` DESC [ RunTime:0.050686s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16132 LIMIT 2 [ RunTime:0.032920s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16132 ORDER BY `minOrder` ASC [ RunTime:0.028840s ]
select * from pdf where partno='99 0406 70 03' and brandshort='BINDER' limit 1 [ RunTime:0.029502s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '99 0406 70 03' OR `brand` LIKE 'BINDER%' ) ) LIMIT 1 [ RunTime:0.045392s ]
SELECT `id` FROM `stock` WHERE `id` <> 16132 AND `partno` = '99 0406 70 03' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%binder%' ) [ RunTime:0.055109s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 651 [ RunTime:0.031234s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17150 [ RunTime:0.051560s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16131 LIMIT 4 [ RunTime:0.046133s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16131 ORDER BY `minOrder` ASC [ RunTime:0.092009s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16131 ORDER BY `unit` DESC [ RunTime:0.025999s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16131 LIMIT 2 [ RunTime:0.037517s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16131 ORDER BY `minOrder` ASC [ RunTime:0.033760s ]
select * from pdf where partno='ERJ3GEYJ101V' and brandshort='PANASONIC' limit 1 [ RunTime:0.065624s ]
select foldpath,foldpath2,filename from pdf_file where id=1493493 limit 1 [ RunTime:0.082297s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ERJ3GEYJ101V' OR `brand` LIKE 'PANASONIC%' ) ) LIMIT 1 [ RunTime:0.060686s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16130 LIMIT 4 [ RunTime:0.048622s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16130 ORDER BY `minOrder` ASC [ RunTime:0.068309s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16130 ORDER BY `unit` DESC [ RunTime:0.162876s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16130 LIMIT 2 [ RunTime:0.044751s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16130 ORDER BY `minOrder` ASC [ RunTime:0.043863s ]
select * from pdf where partno='GRM219R61C226ME15L' and brandshort='MURATA' limit 1 [ RunTime:0.101778s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'GRM219R61C226ME15L' OR `brand` LIKE 'MURATA%' ) ) LIMIT 1 [ RunTime:0.064303s ]
SELECT `id` FROM `stock` WHERE `id` <> 16130 AND `partno` = 'GRM219R61C226ME15L' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%murata%' ) [ RunTime:0.131226s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8439 [ RunTime:0.028098s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17148 [ RunTime:0.042644s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 22013 [ RunTime:0.079717s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 14001012 [ RunTime:0.154471s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16129 LIMIT 4 [ RunTime:0.090617s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16129 ORDER BY `minOrder` ASC [ RunTime:0.075885s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16129 ORDER BY `unit` DESC [ RunTime:0.095191s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16129 LIMIT 2 [ RunTime:0.023392s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16129 ORDER BY `minOrder` ASC [ RunTime:0.017890s ]
select * from pdf where partno='MC32594' and brandshort='MULTICOMP PRO' limit 1 [ RunTime:0.071783s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC32594' OR `brand` LIKE 'MULTICOMP PRO%' ) ) LIMIT 1 [ RunTime:0.072452s ]
SELECT `id` FROM `stock` WHERE `id` <> 16129 AND `partno` = 'MC32594' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%multicomp pro%' ) [ RunTime:0.071865s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 3513 [ RunTime:0.059983s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17147 [ RunTime:0.051345s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16128 LIMIT 4 [ RunTime:0.029301s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16128 ORDER BY `minOrder` ASC [ RunTime:0.048226s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16128 ORDER BY `unit` DESC [ RunTime:0.030858s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16128 LIMIT 2 [ RunTime:0.020772s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16128 ORDER BY `minOrder` ASC [ RunTime:0.088427s ]
select * from pdf where partno='787610-1' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.049679s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '787610-1' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.054207s ]
SELECT `id` FROM `stock` WHERE `id` <> 16128 AND `partno` = '787610-1' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amp - te connectivity%' ) [ RunTime:0.084613s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 7442 [ RunTime:0.046365s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17146 [ RunTime:0.065639s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16127 LIMIT 4 [ RunTime:0.019417s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16127 ORDER BY `minOrder` ASC [ RunTime:0.012920s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16127 ORDER BY `unit` DESC [ RunTime:0.074636s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16127 LIMIT 2 [ RunTime:0.030599s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16127 ORDER BY `minOrder` ASC [ RunTime:0.051116s ]
select * from pdf where partno='L-1384AD/1GD' and brandshort='KINGBRIGHT' limit 1 [ RunTime:0.044737s ]
select foldpath,foldpath2,filename from pdf_file where id=1387251 limit 1 [ RunTime:0.051222s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'L-1384AD/1GD' OR `brand` LIKE 'KINGBRIGHT%' ) ) LIMIT 1 [ RunTime:0.095089s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16126 LIMIT 4 [ RunTime:0.046843s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16126 ORDER BY `minOrder` ASC [ RunTime:0.023888s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16126 ORDER BY `unit` DESC [ RunTime:0.080591s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16126 LIMIT 2 [ RunTime:0.111060s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16126 ORDER BY `minOrder` ASC [ RunTime:0.023901s ]
select * from pdf where partno='74HC138D,653' and brandshort='NEXPERIA' limit 1 [ RunTime:0.049310s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '74HC138D,653' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.050769s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16125 LIMIT 4 [ RunTime:0.128879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16125 ORDER BY `minOrder` ASC [ RunTime:0.029542s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16125 ORDER BY `unit` DESC [ RunTime:0.065443s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16125 LIMIT 2 [ RunTime:0.036566s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16125 ORDER BY `minOrder` ASC [ RunTime:0.009815s ]
select * from pdf where partno='19131-0045' and brandshort='MOLEX' limit 1 [ RunTime:0.052945s ]
select foldpath,foldpath2,filename from pdf_file where id=1551108 limit 1 [ RunTime:0.055004s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '19131-0045' OR `brand` LIKE 'MOLEX%' ) ) LIMIT 1 [ RunTime:0.048360s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16124 LIMIT 4 [ RunTime:0.040701s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16124 ORDER BY `minOrder` ASC [ RunTime:0.058637s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16124 ORDER BY `unit` DESC [ RunTime:0.027451s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16124 LIMIT 2 [ RunTime:0.052461s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16124 ORDER BY `minOrder` ASC [ RunTime:0.025029s ]
select * from pdf where partno='MCP1700T-3302E/MB' and brandshort='MICROCHIP' limit 1 [ RunTime:0.053340s ]
select foldpath,foldpath2,filename from pdf_file where id=1993739 limit 1 [ RunTime:0.068633s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MCP1700T-3302E/MB' OR `brand` LIKE 'MICROCHIP%' ) ) LIMIT 1 [ RunTime:0.090468s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16123 LIMIT 4 [ RunTime:0.012947s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16123 ORDER BY `minOrder` ASC [ RunTime:0.031473s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16123 ORDER BY `unit` DESC [ RunTime:0.083009s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16123 LIMIT 2 [ RunTime:0.031150s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16123 ORDER BY `minOrder` ASC [ RunTime:0.018749s ]
select * from pdf where partno='BC817-16,215' and brandshort='NEXPERIA' limit 1 [ RunTime:0.049291s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'BC817-16,215' OR `brand` LIKE 'NEXPERIA%' ) ) LIMIT 1 [ RunTime:0.033342s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16122 LIMIT 4 [ RunTime:0.034647s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16122 ORDER BY `minOrder` ASC [ RunTime:0.010025s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16122 ORDER BY `unit` DESC [ RunTime:0.007233s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16122 LIMIT 2 [ RunTime:0.031577s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16122 ORDER BY `minOrder` ASC [ RunTime:0.012305s ]
select * from pdf where partno='1586019-6' and brandshort='AMP - TE CONNECTIVITY' limit 1 [ RunTime:0.011080s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1586019-6' OR `brand` LIKE 'AMP - TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.028263s ]
SELECT `id` FROM `stock` WHERE `id` <> 16122 AND `partno` = '1586019-6' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%amp - te connectivity%' ) [ RunTime:0.031396s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 10920 [ RunTime:0.023883s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16121 LIMIT 4 [ RunTime:0.040353s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16121 ORDER BY `minOrder` ASC [ RunTime:0.013788s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16121 ORDER BY `unit` DESC [ RunTime:0.024324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16121 LIMIT 2 [ RunTime:0.003400s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16121 ORDER BY `minOrder` ASC [ RunTime:0.006679s ]
select * from pdf where partno='1-2069682-5' and brandshort='TE CONNECTIVITY' limit 1 [ RunTime:0.006858s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '1-2069682-5' OR `brand` LIKE 'TE CONNECTIVITY%' ) ) LIMIT 1 [ RunTime:0.029742s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16120 LIMIT 4 [ RunTime:0.022626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16120 ORDER BY `minOrder` ASC [ RunTime:0.038742s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16120 ORDER BY `unit` DESC [ RunTime:0.025309s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16120 LIMIT 2 [ RunTime:0.078011s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16120 ORDER BY `minOrder` ASC [ RunTime:0.028249s ]
select * from pdf where partno='ESD7371XV2T1G' and brandshort='ONSEMI' limit 1 [ RunTime:0.024510s ]
select foldpath,foldpath2,filename from pdf_file where id=1999858 limit 1 [ RunTime:0.072924s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'ESD7371XV2T1G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.115772s ]
SELECT `id` FROM `stock` WHERE `id` <> 16120 AND `partno` = 'ESD7371XV2T1G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.064932s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 11446 [ RunTime:0.077416s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17138 [ RunTime:0.021160s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16675732 [ RunTime:0.041798s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16119 LIMIT 4 [ RunTime:0.073083s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16119 ORDER BY `minOrder` ASC [ RunTime:0.161302s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16119 ORDER BY `unit` DESC [ RunTime:0.050753s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16119 LIMIT 2 [ RunTime:0.032077s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16119 ORDER BY `minOrder` ASC [ RunTime:0.016774s ]
select * from pdf where partno='MC14504BDR2G' and brandshort='ONSEMI' limit 1 [ RunTime:0.107542s ]
select foldpath,foldpath2,filename from pdf_file where id=647866 limit 1 [ RunTime:0.042142s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'MC14504BDR2G' OR `brand` LIKE 'ONSEMI%' ) ) LIMIT 1 [ RunTime:0.040328s ]
SELECT `id` FROM `stock` WHERE `id` <> 16119 AND `partno` = 'MC14504BDR2G' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%onsemi%' ) [ RunTime:0.074675s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 8247 [ RunTime:0.018815s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17137 [ RunTime:0.004391s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17111153 [ RunTime:0.062255s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16118 LIMIT 4 [ RunTime:0.120925s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16118 ORDER BY `minOrder` ASC [ RunTime:0.020643s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16118 ORDER BY `unit` DESC [ RunTime:0.019183s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16118 LIMIT 2 [ RunTime:0.024781s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16118 ORDER BY `minOrder` ASC [ RunTime:0.013242s ]
select * from pdf where partno='2ED21824S06JXUMA1' and brandshort='INFINEON' limit 1 [ RunTime:0.017428s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = '2ED21824S06JXUMA1' OR `brand` LIKE 'INFINEON%' ) ) LIMIT 1 [ RunTime:0.009116s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16117 LIMIT 4 [ RunTime:0.033213s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16117 ORDER BY `minOrder` ASC [ RunTime:0.022413s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16117 ORDER BY `unit` DESC [ RunTime:0.053324s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16117 LIMIT 2 [ RunTime:0.027200s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16117 ORDER BY `minOrder` ASC [ RunTime:0.022003s ]
select * from pdf where partno='TS27L2CDT' and brandshort='STMICROELECTRONICS' limit 1 [ RunTime:0.095507s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'TS27L2CDT' OR `brand` LIKE 'STMICROELECTRONICS%' ) ) LIMIT 1 [ RunTime:0.035056s ]
SELECT `id` FROM `stock` WHERE `id` <> 16117 AND `partno` = 'TS27L2CDT' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%stmicroelectronics%' ) [ RunTime:0.093337s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 9729 [ RunTime:0.018494s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17135 [ RunTime:0.041901s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 32148819 [ RunTime:0.013540s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 36988287 [ RunTime:0.020303s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16116 LIMIT 4 [ RunTime:0.008435s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16116 ORDER BY `minOrder` ASC [ RunTime:0.009965s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16116 ORDER BY `unit` DESC [ RunTime:0.032805s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16116 LIMIT 2 [ RunTime:0.044497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16116 ORDER BY `minOrder` ASC [ RunTime:0.009431s ]
select * from pdf where partno='C0805C475K8PACTU' and brandshort='KEMET' limit 1 [ RunTime:0.017605s ]
select foldpath,foldpath2,filename from pdf_file where id=2027364 limit 1 [ RunTime:0.025154s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'C0805C475K8PACTU' OR `brand` LIKE 'KEMET%' ) ) LIMIT 1 [ RunTime:0.015846s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16115 LIMIT 4 [ RunTime:0.020497s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16115 ORDER BY `minOrder` ASC [ RunTime:0.030190s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16115 ORDER BY `unit` DESC [ RunTime:0.006470s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16115 LIMIT 2 [ RunTime:0.009626s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16115 ORDER BY `minOrder` ASC [ RunTime:0.008997s ]
select * from pdf where partno='RJU002N06FRAT106' and brandshort='ROHM' limit 1 [ RunTime:0.004440s ]
select foldpath,foldpath2,filename from pdf_file where id=1457866 limit 1 [ RunTime:0.001465s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'RJU002N06FRAT106' OR `brand` LIKE 'ROHM%' ) ) LIMIT 1 [ RunTime:0.007648s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 16114 LIMIT 4 [ RunTime:0.008815s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16114 ORDER BY `minOrder` ASC [ RunTime:0.031670s ]
SELECT * FROM `stock_unitquantity` WHERE `stockid` = 16114 ORDER BY `unit` DESC [ RunTime:0.011950s ]
SELECT * FROM `stock_warehousequantity` WHERE `stockid` = 16114 LIMIT 2 [ RunTime:0.007879s ]
SELECT * FROM `stock_price` WHERE `stockid` = 16114 ORDER BY `minOrder` ASC [ RunTime:0.006413s ]
select * from pdf where partno='PFL2015-682MEC' and brandshort='COILCRAFT' limit 1 [ RunTime:0.000719s ]
select foldpath,foldpath2,filename from pdf_file where id=1990932 limit 1 [ RunTime:0.000350s ]
SELECT `pra` FROM `stock_pra_lib` WHERE ( ( `partno` = 'PFL2015-682MEC' OR `brand` LIKE 'COILCRAFT%' ) ) LIMIT 1 [ RunTime:0.000439s ]
SELECT `id` FROM `stock` WHERE `id` <> 16114 AND `partno` = 'PFL2015-682MEC' AND `lockUser` = 0 AND ( LOWER(brand) LIKE '%coilcraft%' ) [ RunTime:0.006182s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 5963 [ RunTime:0.001816s ]
SELECT * FROM `stock_pra` WHERE `stockid` = 17132 [ RunTime:0.001741s ]
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 120,20 [ RunTime:0.010874s ]
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.016086s ]
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.000582s ]
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.004550s ]