微信掃碼打開小程序
基本
文件
流程
錯誤
SQL
調(diào)試
請求信息 : 2025-11-26 13:23:13 HTTP/1.1 GET : http://www.hqbet6385.com/mputaojiu/100075/p37/ 運行時間 : 0.228680s [ 吞吐率：4.37req/s ] 內(nèi)存消耗：1,247.68kb 文件加載：201 查詢信息 : 0 queries 緩存信息 : 0 reads,0 writes 會話信息 : SESSION_ID=1ed4943318d2f6cf31fab3497a954f9c
CONNECT:[ UseTime:0.000642s ] mysql:host=127.0.0.1;port=3306;dbname=meijiu_cms;charset=utf8mb4 SHOW FULL COLUMNS FROM `cms_product_categories` [ RunTime:0.000930s ] SELECT * FROM `cms_product_categories` WHERE `pinyin` = 'mputaojiu' LIMIT 1 [ RunTime:0.000384s ] SHOW FULL COLUMNS FROM `cms_brand_to_category` [ RunTime:0.000790s ] SELECT * FROM `cms_brand_to_category` WHERE ( `category_id` = 2 ) [ RunTime:0.000343s ] SHOW FULL COLUMNS FROM `cms_brand` [ RunTime:0.000952s ] SELECT `id`,`pinyin`,`brandname`,`product_num`,`exchange_num`,`logoname`,`website`,`visits`,`description`,`issearch`,`update_time` FROM `cms_brand` WHERE `id` IN (1,69,70,71,72,73,74,75,76,77,78,79,82,128,148,150,151,152,153,155,157,158,159,160,162,163,165,169,170,171,172,173,175) ORDER BY `id` ASC [ RunTime:0.000585s ] SHOW FULL COLUMNS FROM `cms_product_attribute` [ RunTime:0.000959s ] SELECT * FROM `cms_product_attribute` WHERE `category_id` = 2 AND `isshow` = 1 ORDER BY `sort` ASC [ RunTime:0.000368s ] SHOW FULL COLUMNS FROM `cms_product_attribute_value` [ RunTime:0.000917s ] SELECT * FROM `cms_product_attribute_value` WHERE `isshow` = 1 AND ( `attribute_id` IN (10060,10005,10006,10007,10008,10009,10054) ) [ RunTime:0.000510s ] SELECT `t1`.`product_id` FROM cms_product_attribute_value_to_product AS t1 USE INDEX(idx_attr_value_product) WHERE `t1`.`attr_value_id` = '100075' GROUP BY `t1`.`product_id` HAVING COUNT(DISTINCT t1.attr_value_id) = 1 LIMIT 0,1000 [ RunTime:0.000911s ] SELECT `t1`.`product_id` FROM cms_product_attribute_value_to_product AS t1 USE INDEX(idx_attr_value_product) WHERE `t1`.`attr_value_id` = '100075' GROUP BY `t1`.`product_id` HAVING COUNT(DISTINCT t1.attr_value_id) = 1 LIMIT 1000,1000 [ RunTime:0.000698s ] SELECT `t1`.`product_id` FROM cms_product_attribute_value_to_product AS t1 USE INDEX(idx_attr_value_product) WHERE `t1`.`attr_value_id` = '100075' GROUP BY `t1`.`product_id` HAVING COUNT(DISTINCT t1.attr_value_id) = 1 LIMIT 2000,1000 [ RunTime:0.000369s ] SHOW FULL COLUMNS FROM `cms_product` [ RunTime:0.001093s ] CREATE TEMPORARY TABLE cms_temp_product_ids_69268ec1add15 (prodid INT PRIMARY KEY) ENGINE=MEMORY [ RunTime:0.003086s ] SHOW FULL COLUMNS FROM `cms_temp_product_ids_69268ec1add15` [ RunTime:0.000816s ] INSERT INTO `cms_temp_product_ids_69268ec1add15` (`prodid`) VALUES ( 41924 ) , ( 41925 ) , ( 41926 ) , ( 146813 ) , ( 146814 ) , ( 146815 ) , ( 146816 ) , ( 146817 ) , ( 146818 ) , ( 146819 ) , ( 146820 ) , ( 146821 ) , ( 146822 ) , ( 146823 ) , ( 146824 ) , ( 146825 ) , ( 146826 ) , ( 146827 ) , ( 146828 ) , ( 146829 ) , ( 146830 ) , ( 146831 ) , ( 146832 ) , ( 146833 ) , ( 146834 ) , ( 146835 ) , ( 146836 ) , ( 146837 ) , ( 146838 ) , ( 146839 ) , ( 146840 ) , ( 146841 ) , ( 146842 ) , ( 146843 ) , ( 146844 ) , ( 146845 ) , ( 146846 ) , ( 146847 ) , ( 146848 ) , ( 146849 ) , ( 146850 ) , ( 146851 ) , ( 146852 ) , ( 146853 ) , ( 146854 ) , ( 146855 ) , ( 146856 ) , ( 146857 ) , ( 146858 ) , ( 146859 ) , ( 146860 ) , ( 146861 ) , ( 146862 ) , ( 146863 ) , ( 146864 ) , ( 146865 ) , ( 146866 ) , ( 146867 ) , ( 146868 ) , ( 146869 ) , ( 146870 ) , ( 146871 ) , ( 146872 ) , ( 146873 ) , ( 146874 ) , ( 146875 ) , ( 146876 ) , ( 146877 ) , ( 146878 ) , ( 146879 ) , ( 146880 ) , ( 146881 ) , ( 146882 ) , ( 146883 ) , ( 146884 ) , ( 146885 ) , ( 146886 ) , ( 146887 ) , ( 146888 ) , ( 146889 ) , ( 146890 ) , ( 146891 ) , ( 146892 ) , ( 146893 ) , ( 146894 ) , ( 146895 ) , ( 146896 ) , ( 146897 ) , ( 146898 ) , ( 146899 ) , ( 146900 ) , ( 146901 ) , ( 146902 ) , ( 146903 ) , ( 146904 ) , ( 146905 ) , ( 146906 ) , ( 146907 ) , ( 146908 ) , ( 146909 ) , ( 146910 ) , ( 146911 ) , ( 146912 ) , ( 146913 ) , ( 146914 ) , ( 146915 ) , ( 146916 ) , ( 146917 ) , ( 146918 ) , ( 146919 ) , ( 146920 ) , ( 146921 ) , ( 146922 ) , ( 146923 ) , ( 146924 ) , ( 146925 ) , ( 146926 ) , ( 146927 ) , ( 146928 ) , ( 146929 ) , ( 146930 ) , ( 146931 ) , ( 146932 ) , ( 146933 ) , ( 146934 ) , ( 146935 ) , ( 146936 ) , ( 146937 ) , ( 146938 ) , ( 146939 ) , ( 146940 ) , ( 146941 ) , ( 146942 ) , ( 146943 ) , ( 146944 ) , ( 146945 ) , ( 146946 ) , ( 146947 ) , ( 146948 ) , ( 146949 ) , ( 146950 ) , ( 146951 ) , ( 146952 ) , ( 146953 ) , ( 146954 ) , ( 146955 ) , ( 146956 ) , ( 146957 ) , ( 146958 ) , ( 146959 ) , ( 146960 ) , ( 146961 ) , ( 146962 ) , ( 146963 ) , ( 146964 ) , ( 146965 ) , ( 146966 ) , ( 146967 ) , ( 146968 ) , ( 146969 ) , ( 146970 ) , ( 146971 ) , ( 146972 ) , ( 146973 ) , ( 146974 ) , ( 146975 ) , ( 146976 ) , ( 146977 ) , ( 146978 ) , ( 146979 ) , ( 146980 ) , ( 146981 ) , ( 146982 ) , ( 146983 ) , ( 146984 ) , ( 146985 ) , ( 146986 ) , ( 146987 ) , ( 146988 ) , ( 146989 ) , ( 146990 ) , ( 146991 ) , ( 146992 ) , ( 146993 ) , ( 146994 ) , ( 146995 ) , ( 146996 ) , ( 146997 ) , ( 146998 ) , ( 146999 ) , ( 147000 ) , ( 147001 ) , ( 147002 ) , ( 147003 ) , ( 147004 ) , ( 147005 ) , ( 147006 ) , ( 147007 ) , ( 147008 ) , ( 147009 ) , ( 147010 ) , ( 147011 ) , ( 147012 ) , ( 147013 ) , ( 147014 ) , ( 147015 ) , ( 147016 ) , ( 147017 ) , ( 147018 ) , ( 147019 ) , ( 147020 ) , ( 147021 ) , ( 147022 ) , ( 147023 ) , ( 147024 ) , ( 147025 ) , ( 147026 ) , ( 147027 ) , ( 147028 ) , ( 147029 ) , ( 147030 ) , ( 147031 ) , ( 147032 ) , ( 147033 ) , ( 147034 ) , ( 147035 ) , ( 147036 ) , ( 147037 ) , ( 147038 ) , ( 147039 ) , ( 147040 ) , ( 147041 ) , ( 147042 ) , ( 147043 ) , ( 147044 ) , ( 147045 ) , ( 147046 ) , ( 147047 ) , ( 147048 ) , ( 147049 ) , ( 147050 ) , ( 147051 ) , ( 147052 ) , ( 147053 ) , ( 147054 ) , ( 147055 ) , ( 147056 ) , ( 147057 ) , ( 147058 ) , ( 147059 ) , ( 147060 ) , ( 147061 ) , ( 147062 ) , ( 147063 ) , ( 147064 ) , ( 147065 ) , ( 147066 ) , ( 147067 ) , ( 147068 ) , ( 147069 ) , ( 147070 ) , ( 147071 ) , ( 147072 ) , ( 147073 ) , ( 147074 ) , ( 147075 ) , ( 147076 ) , ( 147077 ) , ( 147078 ) , ( 147079 ) , ( 147080 ) , ( 147081 ) , ( 147082 ) , ( 147083 ) , ( 147084 ) , ( 147085 ) , ( 147086 ) , ( 147087 ) , ( 147088 ) , ( 147089 ) , ( 147090 ) , ( 147091 ) , ( 147092 ) , ( 147093 ) , ( 147094 ) , ( 147095 ) , ( 147096 ) , ( 147097 ) , ( 147098 ) , ( 147099 ) , ( 147100 ) , ( 147101 ) , ( 147102 ) , ( 147103 ) , ( 147104 ) , ( 147105 ) , ( 147106 ) , ( 147107 ) , ( 147108 ) , ( 147109 ) , ( 147110 ) , ( 147111 ) , ( 147112 ) , ( 147113 ) , ( 147114 ) , ( 147115 ) , ( 147116 ) , ( 147117 ) , ( 147118 ) , ( 147119 ) , ( 147120 ) , ( 147121 ) , ( 147122 ) , ( 147123 ) , ( 147124 ) , ( 147125 ) , ( 147126 ) , ( 147127 ) , ( 147128 ) , ( 147129 ) , ( 147130 ) , ( 147131 ) , ( 147132 ) , ( 147133 ) , ( 147134 ) , ( 147135 ) , ( 147136 ) , ( 147137 ) , ( 147138 ) , ( 147139 ) , ( 147140 ) , ( 147141 ) , ( 147142 ) , ( 147143 ) , ( 147144 ) , ( 147145 ) , ( 147146 ) , ( 147147 ) , ( 147148 ) , ( 147149 ) , ( 147150 ) , ( 147151 ) , ( 147152 ) , ( 147153 ) , ( 147154 ) , ( 147155 ) , ( 147156 ) , ( 147157 ) , ( 147158 ) , ( 147159 ) , ( 147160 ) , ( 147161 ) , ( 147162 ) , ( 147163 ) , ( 147164 ) , ( 147165 ) , ( 147166 ) , ( 147167 ) , ( 147168 ) , ( 147169 ) , ( 147170 ) , ( 147171 ) , ( 147172 ) , ( 147173 ) , ( 147174 ) , ( 147175 ) , ( 147176 ) , ( 147177 ) , ( 147178 ) , ( 147179 ) , ( 147180 ) , ( 147181 ) , ( 147182 ) , ( 147183 ) , ( 147184 ) , ( 147185 ) , ( 147186 ) , ( 147187 ) , ( 147188 ) , ( 147189 ) , ( 147190 ) , ( 147191 ) , ( 147192 ) , ( 147193 ) , ( 147194 ) , ( 147195 ) , ( 147196 ) , ( 147197 ) , ( 147198 ) , ( 147199 ) , ( 147200 ) , ( 147201 ) , ( 147202 ) , ( 147203 ) , ( 147204 ) , ( 147205 ) , ( 147206 ) , ( 147207 ) , ( 147208 ) , ( 147209 ) , ( 147210 ) , ( 147211 ) , ( 147212 ) , ( 147213 ) , ( 147214 ) , ( 147215 ) , ( 147216 ) , ( 147217 ) , ( 147218 ) , ( 147219 ) , ( 147220 ) , ( 147221 ) , ( 147222 ) , ( 147223 ) , ( 147224 ) , ( 147225 ) , ( 147226 ) , ( 147227 ) , ( 147228 ) , ( 147229 ) , ( 147230 ) , ( 147231 ) , ( 147232 ) , ( 147233 ) , ( 147234 ) , ( 147235 ) , ( 147236 ) , ( 147237 ) , ( 147238 ) , ( 147239 ) , ( 147240 ) , ( 147241 ) , ( 147242 ) , ( 147243 ) , ( 147244 ) , ( 147245 ) , ( 147246 ) , ( 147247 ) , ( 147248 ) , ( 147249 ) , ( 147250 ) , ( 147251 ) , ( 147252 ) , ( 147253 ) , ( 147254 ) , ( 147255 ) , ( 147256 ) , ( 147257 ) , ( 147258 ) , ( 147259 ) , ( 147260 ) , ( 147261 ) , ( 147262 ) , ( 147263 ) , ( 147264 ) , ( 147265 ) , ( 147266 ) , ( 147267 ) , ( 147268 ) , ( 147269 ) , ( 147270 ) , ( 147271 ) , ( 147272 ) , ( 147273 ) , ( 147274 ) , ( 147275 ) , ( 147276 ) , ( 147277 ) , ( 147278 ) , ( 147279 ) , ( 147280 ) , ( 147281 ) , ( 147282 ) , ( 147283 ) , ( 147284 ) , ( 147285 ) , ( 147286 ) , ( 147999 ) , ( 148000 ) , ( 148001 ) , ( 148002 ) , ( 148003 ) , ( 148004 ) , ( 148005 ) , ( 148006 ) , ( 148007 ) , ( 148008 ) , ( 148009 ) , ( 148010 ) , ( 148011 ) , ( 148012 ) , ( 148013 ) , ( 148014 ) , ( 148015 ) , ( 148016 ) , ( 148017 ) , ( 148018 ) , ( 148019 ) , ( 148020 ) , ( 148021 ) [ RunTime:0.007837s ] INSERT INTO `cms_temp_product_ids_69268ec1add15` (`prodid`) VALUES ( 148022 ) , ( 148023 ) , ( 148024 ) , ( 148025 ) , ( 148026 ) , ( 148027 ) , ( 148028 ) , ( 148029 ) , ( 148030 ) , ( 148031 ) , ( 148032 ) , ( 148033 ) , ( 148034 ) , ( 148035 ) , ( 148036 ) , ( 148037 ) , ( 148038 ) , ( 148039 ) , ( 148040 ) , ( 148041 ) , ( 148042 ) , ( 148043 ) , ( 148044 ) , ( 148045 ) , ( 148046 ) , ( 148047 ) , ( 148048 ) , ( 148049 ) , ( 148050 ) , ( 148051 ) , ( 148052 ) , ( 148053 ) , ( 148054 ) , ( 148055 ) , ( 148056 ) , ( 148057 ) , ( 148058 ) , ( 148059 ) , ( 148060 ) , ( 148061 ) , ( 148062 ) , ( 148063 ) , ( 148064 ) , ( 148065 ) , ( 148066 ) , ( 148067 ) , ( 148068 ) , ( 148069 ) , ( 148070 ) , ( 148071 ) , ( 148072 ) , ( 148073 ) , ( 148149 ) , ( 148150 ) , ( 148151 ) , ( 148152 ) , ( 148153 ) , ( 148154 ) , ( 148155 ) , ( 148156 ) , ( 148157 ) , ( 148158 ) , ( 148159 ) , ( 148160 ) , ( 148161 ) , ( 148162 ) , ( 148163 ) , ( 148164 ) , ( 148165 ) , ( 148166 ) , ( 148167 ) , ( 148168 ) , ( 148169 ) , ( 148170 ) , ( 148171 ) , ( 148172 ) , ( 148173 ) , ( 148174 ) , ( 148175 ) , ( 148176 ) , ( 148177 ) , ( 148178 ) , ( 148179 ) , ( 148180 ) , ( 148181 ) , ( 148182 ) , ( 148183 ) , ( 148184 ) , ( 148185 ) , ( 148186 ) , ( 148187 ) , ( 148188 ) , ( 148189 ) , ( 148190 ) , ( 148191 ) , ( 148192 ) , ( 148193 ) , ( 148194 ) , ( 148195 ) , ( 148196 ) , ( 148197 ) , ( 148198 ) , ( 148199 ) , ( 148200 ) , ( 148201 ) , ( 148202 ) , ( 148203 ) , ( 148204 ) , ( 148205 ) , ( 148206 ) , ( 148207 ) , ( 148208 ) , ( 148209 ) , ( 148210 ) , ( 148211 ) , ( 148212 ) , ( 148213 ) , ( 148214 ) , ( 148215 ) , ( 148216 ) , ( 148217 ) , ( 148218 ) , ( 148219 ) , ( 148220 ) , ( 148221 ) , ( 148222 ) , ( 148223 ) , ( 148224 ) , ( 148225 ) , ( 148226 ) , ( 148227 ) , ( 148228 ) , ( 148229 ) , ( 148230 ) , ( 148231 ) , ( 148232 ) , ( 148233 ) , ( 148234 ) , ( 148235 ) , ( 148236 ) , ( 148237 ) , ( 148238 ) , ( 148239 ) , ( 148240 ) , ( 148241 ) , ( 148242 ) , ( 148243 ) , ( 148244 ) , ( 148245 ) , ( 148246 ) , ( 148247 ) , ( 148248 ) , ( 148249 ) , ( 148250 ) , ( 148251 ) , ( 148252 ) , ( 148253 ) , ( 148254 ) , ( 148255 ) , ( 148256 ) , ( 148257 ) , ( 148258 ) , ( 148259 ) , ( 148260 ) , ( 148261 ) , ( 148262 ) , ( 148263 ) , ( 148264 ) , ( 148265 ) , ( 148266 ) , ( 148267 ) , ( 148268 ) , ( 148269 ) , ( 148270 ) , ( 148271 ) , ( 148272 ) , ( 148273 ) , ( 148274 ) , ( 148275 ) , ( 148276 ) , ( 148277 ) , ( 148278 ) , ( 148279 ) , ( 148280 ) , ( 148281 ) , ( 148282 ) , ( 148283 ) , ( 148284 ) , ( 148285 ) , ( 148286 ) , ( 148287 ) , ( 148288 ) , ( 148289 ) , ( 148290 ) , ( 148291 ) , ( 148292 ) , ( 148293 ) , ( 148294 ) , ( 148295 ) , ( 148296 ) , ( 148297 ) , ( 148298 ) , ( 148299 ) , ( 148300 ) , ( 148301 ) , ( 148302 ) , ( 148303 ) , ( 148304 ) , ( 148305 ) , ( 148306 ) , ( 148307 ) , ( 148308 ) , ( 148309 ) , ( 148310 ) , ( 148311 ) , ( 148312 ) , ( 148313 ) , ( 148314 ) , ( 148315 ) , ( 148316 ) , ( 148317 ) , ( 148318 ) , ( 148319 ) , ( 148320 ) , ( 148321 ) , ( 148322 ) , ( 148323 ) , ( 148324 ) , ( 148325 ) , ( 148326 ) , ( 148327 ) , ( 148328 ) , ( 148329 ) , ( 148330 ) , ( 148331 ) , ( 148332 ) , ( 148333 ) , ( 148334 ) , ( 148335 ) , ( 148336 ) , ( 148337 ) , ( 148338 ) , ( 148339 ) , ( 148340 ) , ( 148341 ) , ( 148342 ) , ( 148343 ) , ( 148344 ) , ( 148345 ) , ( 148346 ) , ( 148347 ) , ( 148348 ) , ( 148349 ) , ( 148350 ) , ( 148351 ) , ( 148352 ) , ( 148353 ) , ( 148354 ) , ( 148355 ) , ( 148356 ) , ( 148357 ) , ( 148358 ) , ( 148359 ) , ( 148360 ) , ( 148361 ) , ( 148362 ) , ( 148363 ) , ( 148364 ) , ( 148365 ) , ( 148366 ) , ( 148367 ) , ( 148368 ) , ( 148369 ) , ( 148370 ) , ( 148371 ) , ( 148372 ) , ( 148373 ) , ( 148537 ) , ( 148538 ) , ( 148539 ) , ( 148540 ) , ( 148541 ) , ( 148542 ) , ( 148543 ) , ( 148544 ) , ( 148545 ) , ( 148546 ) , ( 148547 ) , ( 148548 ) , ( 148549 ) , ( 148550 ) , ( 148551 ) , ( 148552 ) , ( 148553 ) , ( 148554 ) , ( 148555 ) , ( 148556 ) , ( 148557 ) , ( 148558 ) , ( 148559 ) , ( 148560 ) , ( 148561 ) , ( 148562 ) , ( 148563 ) , ( 148564 ) , ( 148565 ) , ( 148566 ) , ( 148567 ) , ( 148568 ) , ( 148569 ) , ( 148570 ) , ( 148571 ) , ( 148572 ) , ( 148573 ) , ( 148574 ) , ( 148575 ) , ( 148576 ) , ( 148577 ) , ( 148578 ) , ( 148579 ) , ( 148580 ) , ( 148581 ) , ( 148582 ) , ( 148583 ) , ( 148584 ) , ( 148585 ) , ( 148586 ) , ( 148587 ) , ( 148588 ) , ( 148589 ) , ( 148590 ) , ( 148591 ) , ( 148592 ) , ( 148593 ) , ( 148594 ) , ( 148595 ) , ( 148596 ) , ( 148597 ) , ( 148598 ) , ( 148599 ) , ( 148600 ) , ( 148601 ) , ( 148602 ) , ( 148603 ) , ( 148604 ) , ( 148605 ) , ( 148606 ) , ( 148607 ) , ( 148608 ) , ( 148609 ) , ( 148610 ) , ( 148611 ) , ( 148612 ) , ( 148613 ) , ( 148614 ) , ( 148615 ) , ( 148616 ) , ( 148617 ) , ( 148618 ) , ( 148619 ) , ( 148620 ) , ( 148621 ) , ( 148622 ) , ( 148623 ) , ( 148624 ) , ( 148625 ) , ( 148626 ) , ( 148627 ) , ( 148628 ) , ( 148629 ) , ( 148630 ) , ( 148631 ) , ( 148632 ) , ( 148633 ) , ( 148634 ) , ( 148635 ) , ( 148636 ) , ( 148637 ) , ( 148638 ) , ( 148639 ) , ( 148640 ) , ( 148641 ) , ( 148642 ) , ( 148643 ) , ( 148644 ) , ( 148645 ) , ( 148646 ) , ( 148647 ) , ( 148648 ) , ( 148649 ) , ( 148650 ) , ( 148651 ) , ( 148652 ) , ( 148653 ) , ( 148654 ) , ( 148655 ) , ( 148656 ) , ( 148657 ) , ( 148658 ) , ( 148659 ) , ( 148660 ) , ( 148661 ) , ( 148662 ) , ( 148663 ) , ( 148664 ) , ( 148665 ) , ( 148666 ) , ( 148667 ) , ( 148668 ) , ( 148669 ) , ( 148670 ) , ( 148671 ) , ( 148672 ) , ( 148673 ) , ( 148674 ) , ( 148675 ) , ( 148676 ) , ( 148677 ) , ( 148678 ) , ( 148679 ) , ( 148680 ) , ( 148681 ) , ( 148682 ) , ( 148683 ) , ( 148684 ) , ( 148685 ) , ( 148686 ) , ( 148687 ) , ( 148688 ) , ( 148689 ) , ( 148690 ) , ( 148691 ) , ( 148692 ) , ( 148693 ) , ( 148694 ) , ( 148695 ) , ( 148696 ) , ( 148697 ) , ( 148698 ) , ( 148699 ) , ( 148700 ) , ( 148701 ) , ( 148702 ) , ( 148703 ) , ( 148704 ) , ( 148705 ) , ( 148706 ) , ( 148707 ) , ( 148708 ) , ( 148709 ) , ( 148710 ) , ( 148711 ) , ( 148712 ) , ( 148713 ) , ( 148714 ) , ( 148715 ) , ( 148716 ) , ( 148717 ) , ( 148718 ) , ( 148719 ) , ( 148720 ) , ( 148721 ) , ( 148722 ) , ( 148723 ) , ( 148724 ) , ( 148725 ) , ( 148726 ) , ( 148727 ) , ( 148728 ) , ( 148729 ) , ( 148730 ) , ( 148731 ) , ( 148732 ) , ( 148733 ) , ( 148734 ) , ( 148735 ) , ( 148736 ) , ( 148737 ) , ( 148738 ) , ( 148739 ) , ( 148740 ) , ( 148741 ) , ( 148742 ) , ( 148743 ) , ( 148744 ) , ( 148745 ) , ( 148746 ) , ( 148747 ) , ( 148748 ) , ( 148749 ) , ( 148750 ) , ( 148751 ) , ( 148752 ) , ( 148753 ) , ( 148754 ) , ( 148755 ) , ( 148756 ) , ( 148757 ) , ( 148758 ) , ( 148759 ) [ RunTime:0.005657s ] INSERT INTO `cms_temp_product_ids_69268ec1add15` (`prodid`) VALUES ( 148760 ) , ( 148761 ) , ( 148762 ) , ( 148763 ) , ( 148764 ) , ( 148765 ) , ( 148766 ) , ( 148767 ) , ( 148768 ) , ( 148769 ) , ( 148770 ) , ( 148771 ) , ( 148772 ) , ( 148773 ) , ( 148774 ) , ( 148775 ) , ( 148776 ) , ( 148777 ) , ( 148778 ) , ( 148779 ) , ( 148780 ) , ( 148781 ) , ( 148782 ) , ( 148783 ) , ( 148784 ) , ( 148785 ) , ( 148786 ) , ( 148787 ) , ( 148788 ) , ( 148789 ) , ( 148790 ) , ( 148791 ) , ( 148792 ) , ( 148793 ) , ( 148794 ) , ( 148795 ) , ( 148796 ) , ( 148797 ) , ( 148798 ) , ( 148799 ) , ( 148800 ) , ( 148801 ) , ( 148802 ) , ( 148803 ) , ( 148804 ) , ( 148805 ) , ( 148806 ) , ( 148807 ) , ( 148808 ) , ( 148809 ) , ( 148810 ) , ( 148811 ) , ( 148812 ) , ( 148813 ) , ( 148814 ) , ( 148815 ) , ( 148816 ) , ( 148817 ) , ( 148818 ) , ( 148819 ) , ( 148820 ) , ( 148821 ) , ( 148822 ) , ( 148823 ) , ( 148824 ) , ( 148825 ) , ( 148826 ) , ( 148827 ) , ( 148828 ) , ( 148829 ) , ( 148830 ) , ( 148831 ) , ( 148832 ) , ( 148833 ) , ( 148834 ) , ( 148835 ) , ( 148836 ) , ( 148837 ) , ( 148838 ) , ( 148839 ) , ( 148840 ) , ( 148841 ) , ( 148842 ) , ( 148843 ) , ( 148844 ) , ( 148845 ) , ( 148846 ) , ( 148847 ) , ( 148848 ) , ( 148849 ) , ( 148850 ) , ( 148851 ) , ( 148852 ) , ( 148853 ) , ( 148854 ) , ( 148855 ) , ( 148856 ) , ( 148857 ) , ( 148858 ) , ( 148859 ) , ( 148861 ) , ( 148862 ) , ( 148863 ) , ( 148864 ) , ( 148865 ) , ( 148866 ) , ( 148867 ) , ( 148868 ) , ( 148869 ) , ( 148870 ) , ( 148871 ) , ( 148872 ) , ( 148873 ) , ( 148874 ) , ( 148875 ) , ( 148876 ) , ( 148877 ) , ( 148878 ) , ( 148879 ) , ( 148880 ) , ( 148881 ) , ( 148882 ) , ( 148883 ) , ( 148885 ) , ( 148886 ) , ( 148887 ) , ( 148888 ) , ( 148889 ) , ( 148890 ) , ( 148891 ) , ( 148892 ) , ( 148893 ) , ( 148894 ) , ( 148895 ) , ( 148896 ) , ( 148897 ) , ( 148898 ) , ( 148899 ) , ( 148900 ) , ( 148901 ) , ( 148902 ) , ( 148903 ) , ( 148904 ) , ( 148905 ) , ( 148906 ) , ( 148907 ) , ( 148984 ) , ( 148985 ) , ( 148986 ) , ( 148987 ) , ( 148988 ) , ( 148989 ) , ( 148990 ) , ( 148991 ) , ( 148992 ) , ( 148993 ) , ( 148994 ) , ( 148995 ) , ( 148996 ) , ( 148997 ) , ( 148998 ) , ( 148999 ) , ( 149000 ) , ( 149001 ) , ( 149002 ) , ( 149003 ) , ( 149004 ) , ( 149005 ) , ( 149006 ) , ( 149007 ) , ( 149008 ) , ( 149009 ) , ( 149010 ) , ( 149011 ) , ( 149012 ) , ( 149013 ) , ( 149014 ) , ( 149015 ) , ( 149016 ) , ( 149017 ) , ( 149018 ) , ( 149019 ) , ( 149020 ) , ( 149021 ) , ( 149022 ) , ( 149023 ) , ( 149024 ) , ( 149025 ) , ( 149026 ) , ( 149027 ) , ( 149028 ) , ( 149029 ) , ( 149030 ) , ( 149031 ) , ( 149032 ) , ( 149033 ) , ( 149034 ) , ( 149035 ) , ( 149036 ) , ( 149037 ) , ( 149038 ) , ( 149039 ) , ( 149040 ) , ( 149041 ) , ( 149042 ) , ( 149043 ) , ( 149044 ) , ( 149045 ) , ( 149046 ) , ( 149047 ) , ( 149048 ) , ( 149049 ) , ( 149050 ) , ( 149051 ) , ( 149052 ) , ( 149053 ) , ( 149054 ) , ( 149055 ) , ( 149056 ) , ( 149057 ) , ( 149058 ) , ( 166861 ) , ( 166862 ) , ( 166863 ) , ( 166864 ) , ( 166865 ) , ( 166866 ) , ( 166867 ) , ( 166868 ) , ( 166869 ) , ( 166870 ) , ( 166871 ) , ( 166872 ) , ( 166873 ) , ( 166874 ) , ( 166875 ) , ( 166876 ) , ( 166877 ) , ( 166878 ) , ( 166879 ) , ( 166880 ) , ( 166881 ) , ( 166882 ) , ( 166883 ) , ( 166884 ) , ( 166885 ) , ( 166886 ) , ( 166887 ) , ( 166888 ) , ( 166889 ) , ( 166890 ) , ( 166891 ) , ( 166892 ) , ( 166893 ) , ( 166894 ) , ( 166895 ) , ( 166896 ) , ( 166897 ) , ( 166898 ) , ( 166899 ) , ( 166900 ) , ( 166901 ) , ( 166902 ) , ( 166903 ) , ( 166904 ) , ( 166905 ) , ( 166906 ) , ( 166907 ) , ( 166908 ) , ( 166909 ) , ( 166910 ) , ( 166911 ) , ( 166912 ) , ( 166913 ) , ( 166914 ) , ( 166915 ) , ( 166916 ) , ( 166917 ) , ( 166918 ) , ( 166919 ) , ( 166920 ) , ( 166921 ) , ( 166922 ) , ( 166923 ) , ( 166924 ) , ( 166925 ) , ( 166926 ) , ( 166927 ) , ( 166928 ) , ( 166929 ) , ( 166930 ) , ( 166931 ) , ( 166932 ) , ( 166933 ) , ( 166934 ) , ( 166935 ) , ( 166936 ) , ( 166937 ) , ( 166938 ) , ( 166939 ) , ( 166940 ) , ( 166941 ) , ( 166942 ) , ( 166943 ) , ( 166944 ) , ( 166945 ) , ( 166946 ) , ( 166947 ) , ( 166948 ) , ( 166949 ) , ( 166950 ) , ( 166951 ) , ( 166952 ) , ( 166953 ) , ( 166954 ) , ( 166955 ) , ( 166956 ) , ( 166957 ) , ( 166958 ) , ( 166959 ) , ( 167395 ) , ( 167396 ) , ( 167397 ) , ( 167398 ) , ( 167399 ) , ( 167400 ) , ( 167401 ) , ( 167402 ) , ( 167403 ) , ( 167404 ) , ( 167405 ) , ( 167406 ) , ( 167407 ) , ( 167408 ) , ( 167409 ) , ( 167410 ) , ( 167411 ) , ( 167412 ) , ( 167539 ) , ( 167540 ) , ( 167541 ) , ( 167542 ) , ( 167543 ) , ( 167544 ) , ( 167545 ) , ( 167546 ) , ( 167547 ) , ( 167548 ) , ( 167549 ) , ( 167550 ) , ( 167551 ) , ( 167552 ) , ( 167553 ) , ( 167554 ) , ( 167555 ) , ( 167556 ) , ( 167557 ) , ( 167558 ) , ( 167559 ) , ( 167560 ) , ( 167561 ) , ( 167562 ) , ( 167563 ) , ( 167564 ) , ( 167565 ) , ( 167566 ) , ( 167567 ) , ( 167568 ) , ( 167569 ) , ( 167570 ) , ( 167571 ) , ( 167572 ) , ( 167573 ) , ( 167574 ) , ( 167575 ) , ( 167576 ) , ( 167577 ) , ( 167578 ) , ( 167579 ) , ( 167580 ) , ( 167581 ) , ( 167582 ) , ( 167583 ) , ( 167584 ) , ( 167585 ) , ( 167586 ) , ( 167587 ) , ( 167588 ) , ( 167589 ) , ( 167590 ) , ( 167591 ) , ( 167592 ) , ( 167593 ) , ( 167594 ) , ( 167595 ) , ( 167596 ) , ( 167597 ) , ( 167598 ) , ( 167599 ) , ( 167600 ) , ( 167601 ) , ( 167602 ) , ( 167603 ) , ( 167604 ) , ( 167605 ) , ( 167606 ) , ( 167607 ) , ( 167608 ) , ( 167609 ) , ( 167610 ) , ( 167611 ) , ( 167612 ) , ( 167613 ) , ( 167614 ) , ( 167615 ) , ( 167616 ) , ( 167617 ) , ( 167618 ) , ( 167619 ) , ( 167620 ) , ( 167621 ) , ( 167622 ) , ( 167623 ) , ( 167624 ) , ( 167625 ) , ( 167626 ) , ( 167627 ) , ( 167628 ) , ( 167629 ) , ( 167630 ) , ( 167631 ) , ( 167632 ) , ( 167633 ) , ( 167634 ) , ( 167635 ) , ( 167636 ) , ( 167637 ) , ( 167638 ) , ( 167639 ) , ( 167640 ) , ( 167641 ) , ( 167642 ) , ( 167643 ) , ( 167644 ) , ( 167645 ) , ( 167646 ) , ( 167647 ) , ( 167648 ) , ( 167649 ) , ( 167650 ) , ( 167651 ) , ( 167652 ) , ( 167653 ) , ( 167654 ) , ( 167655 ) , ( 167656 ) , ( 167657 ) , ( 167658 ) , ( 167659 ) , ( 167660 ) , ( 167661 ) , ( 167662 ) , ( 167663 ) , ( 167664 ) , ( 167665 ) , ( 167666 ) , ( 167667 ) , ( 167668 ) , ( 167669 ) , ( 167670 ) , ( 167671 ) , ( 167672 ) , ( 167673 ) , ( 167674 ) , ( 167675 ) , ( 167676 ) , ( 167677 ) , ( 167678 ) , ( 167679 ) , ( 167680 ) , ( 167681 ) , ( 167682 ) , ( 167683 ) , ( 167684 ) , ( 167685 ) , ( 167686 ) , ( 167687 ) , ( 167688 ) , ( 167689 ) , ( 167690 ) , ( 167691 ) , ( 167692 ) , ( 167693 ) , ( 167694 ) , ( 167695 ) , ( 167696 ) , ( 167697 ) , ( 167698 ) , ( 167699 ) , ( 167700 ) [ RunTime:0.004830s ] INSERT INTO `cms_temp_product_ids_69268ec1add15` (`prodid`) VALUES ( 167701 ) , ( 167702 ) , ( 167703 ) , ( 167704 ) , ( 167705 ) , ( 167706 ) , ( 167707 ) , ( 167708 ) , ( 167709 ) , ( 167710 ) , ( 167711 ) , ( 167712 ) , ( 167713 ) , ( 167714 ) , ( 167715 ) , ( 167716 ) , ( 167717 ) , ( 167718 ) , ( 167719 ) , ( 167720 ) , ( 167721 ) , ( 167722 ) , ( 167723 ) , ( 167724 ) , ( 167725 ) , ( 167726 ) , ( 167727 ) , ( 167728 ) , ( 167729 ) , ( 167730 ) , ( 167731 ) , ( 167732 ) , ( 167733 ) , ( 167734 ) , ( 167735 ) , ( 167736 ) , ( 167737 ) , ( 167738 ) , ( 167739 ) , ( 167740 ) , ( 167741 ) , ( 167742 ) , ( 167743 ) , ( 167744 ) , ( 167745 ) , ( 167746 ) , ( 167747 ) , ( 167748 ) , ( 167749 ) , ( 167750 ) , ( 167751 ) , ( 167752 ) , ( 167753 ) , ( 167754 ) , ( 167755 ) , ( 167756 ) , ( 167757 ) , ( 167758 ) , ( 167759 ) , ( 167760 ) , ( 167761 ) , ( 167762 ) , ( 167763 ) , ( 167764 ) , ( 167765 ) , ( 167766 ) , ( 167767 ) , ( 167768 ) , ( 167769 ) , ( 167770 ) , ( 167771 ) , ( 167772 ) , ( 167773 ) , ( 167774 ) , ( 167775 ) , ( 167776 ) , ( 167777 ) , ( 167778 ) , ( 167779 ) , ( 167780 ) , ( 167781 ) , ( 167782 ) , ( 167783 ) , ( 167784 ) , ( 167785 ) , ( 167786 ) , ( 167787 ) , ( 167788 ) , ( 167789 ) , ( 167790 ) , ( 167791 ) , ( 167792 ) , ( 167793 ) , ( 167794 ) , ( 167795 ) , ( 167796 ) , ( 167797 ) , ( 167798 ) , ( 167799 ) , ( 167800 ) , ( 167801 ) , ( 167802 ) , ( 167803 ) , ( 167804 ) , ( 167805 ) , ( 167806 ) , ( 167807 ) , ( 167808 ) , ( 167809 ) , ( 167810 ) , ( 167811 ) , ( 167812 ) , ( 167813 ) , ( 167814 ) , ( 167815 ) , ( 167816 ) , ( 167817 ) , ( 167818 ) , ( 167819 ) , ( 167820 ) , ( 167821 ) , ( 167822 ) , ( 167823 ) , ( 167824 ) , ( 167825 ) , ( 167826 ) , ( 167827 ) , ( 167828 ) , ( 167829 ) , ( 167830 ) , ( 167831 ) , ( 167832 ) , ( 167833 ) , ( 167834 ) , ( 167835 ) , ( 167836 ) , ( 167837 ) , ( 167838 ) , ( 167839 ) , ( 167840 ) , ( 167841 ) , ( 167842 ) , ( 167843 ) , ( 167844 ) , ( 167845 ) , ( 167846 ) , ( 167847 ) , ( 167848 ) , ( 167849 ) , ( 167850 ) , ( 167851 ) , ( 167852 ) , ( 167853 ) , ( 167854 ) , ( 167855 ) , ( 167856 ) , ( 167857 ) , ( 167858 ) , ( 167859 ) , ( 167860 ) , ( 167861 ) , ( 167862 ) , ( 167863 ) , ( 167864 ) , ( 167865 ) , ( 167866 ) , ( 167867 ) , ( 167868 ) , ( 167869 ) , ( 167870 ) , ( 167871 ) , ( 167872 ) , ( 167873 ) , ( 167874 ) , ( 167875 ) , ( 167876 ) , ( 167877 ) , ( 167878 ) , ( 167879 ) , ( 167880 ) , ( 167881 ) , ( 167882 ) , ( 167883 ) , ( 167884 ) , ( 167885 ) , ( 167886 ) , ( 167887 ) , ( 167888 ) , ( 167889 ) , ( 167890 ) , ( 167891 ) , ( 167892 ) , ( 167893 ) , ( 167894 ) , ( 167895 ) , ( 167896 ) , ( 167897 ) , ( 167898 ) , ( 167899 ) , ( 167900 ) , ( 167901 ) , ( 167902 ) , ( 167903 ) , ( 167904 ) , ( 167905 ) , ( 167906 ) , ( 167907 ) , ( 167908 ) , ( 167909 ) , ( 167910 ) , ( 167911 ) , ( 167912 ) , ( 167913 ) , ( 167914 ) , ( 167915 ) , ( 167916 ) [ RunTime:0.001947s ] SELECT COUNT(*) AS think_count FROM `cms_product` `products` INNER JOIN `cms_temp_product_ids_69268ec1add15` `tmp` ON `products`.`id`=`tmp`.`prodid` WHERE ( `category_id` = 2 ) AND `products`.`delete_time` IS NULL [ RunTime:0.009550s ] SELECT `id`,`brand_id`,`category_id`,`product_name`,`year`,`netwt`,`unit`,`price`,`last_price`,`cover`,`visits` FROM `cms_product` `products` INNER JOIN `cms_temp_product_ids_69268ec1add15` `tmp` ON `products`.`id`=`tmp`.`prodid` WHERE ( `category_id` = 2 ) AND `products`.`delete_time` IS NULL ORDER BY `visits` DESC LIMIT 1440,40 [ RunTime:0.021522s ] SELECT `id`,`name`,`pinyin` FROM `cms_product_categories` WHERE ( `id` = 2 ) [ RunTime:0.003274s ] SELECT `id`,`brandname`,`logoname`,`pinyin`,`product_num`,`exchange_num`,`description` FROM `cms_brand` WHERE ( `id` = 71 ) [ RunTime:0.001518s ] SELECT `id`,`name`,`pinyin`,`icon`,`pathapp`,`iconapp` FROM `cms_product_categories` WHERE `pid` = 0 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000294s ] SHOW FULL COLUMNS FROM `cms_column` [ RunTime:0.000892s ] SELECT * FROM `cms_column` ORDER BY `id` ASC [ RunTime:0.000295s ] SELECT `id`,`name`,`pinyin`,`icon`,`pathapp`,`iconapp` FROM `cms_product_categories` WHERE `pid` = 0 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000274s ]
0.231341s
