SHOW FULL COLUMNS FROM `shop_discount_config` [ RunTime:0.004791s ]
SHOW FULL COLUMNS FROM `shop_column` [ RunTime:0.004637s ]
SHOW FULL COLUMNS FROM `shop_column_page` [ RunTime:0.004562s ]
SELECT `page_id`,`page_name` FROM `shop_column_page` `a` WHERE ( ( `parent_id` = 0 ) AND `substation_id` = 1 ) AND `a`.`delete_time` IS NULL ORDER BY sort [ RunTime:0.004462s ]
SELECT `page_id`,`page_name` FROM `shop_column_page` `a` WHERE ( ( `parent_id` = 18 ) AND `substation_id` = 1 ) AND `a`.`delete_time` IS NULL ORDER BY sort [ RunTime:0.004507s ]
SELECT `page_id`,`page_name` FROM `shop_column_page` `a` WHERE ( ( `parent_id` = 16 ) AND `substation_id` = 1 ) AND `a`.`delete_time` IS NULL ORDER BY sort [ RunTime:0.004305s ]
SELECT `page_id`,`page_name` FROM `shop_column_page` `a` WHERE ( ( `parent_id` = 22 ) AND `substation_id` = 1 ) AND `a`.`delete_time` IS NULL ORDER BY sort [ RunTime:0.004346s ]
SELECT `page_id`,`page_name` FROM `shop_column_page` `a` WHERE ( ( `parent_id` = 17 ) AND `substation_id` = 1 ) AND `a`.`delete_time` IS NULL ORDER BY sort [ RunTime:0.004332s ]
SHOW FULL COLUMNS FROM `shop_information_keyword` [ RunTime:0.004549s ]
SHOW FULL COLUMNS FROM `shop_information_keyword_relation` [ RunTime:0.004438s ]
SELECT `keyword_id` FROM `shop_information_keyword_relation` WHERE `drawing_id` IS NOT NULL GROUP BY `keyword_id` [ RunTime:0.021287s ]
SELECT COUNT(*) AS think_count FROM `shop_information_keyword` `a` WHERE ( ( ( `keyword_id` IN (13,14,15,17,18,19,20,21,22,23,24,25,26,27,30,31,32,33,34,35,37,38,40,41,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,72,73,74,75,76,82,83,87,89,91,92,94,97,99,100,103,104,105,107,108,109,110,111,113,116,117,118,119,120,121,122,123,124,125,135,136,137,138,141,153,154,155,156,158,166,167,168,170,172,180,181,182,183,188,189,190,191,192,193,194,195,196,197,198,199,206,207,208,209,210,212,219,223,224,225,226,235,237,238,246,247,248,250,251,254,255,259,261,262,295,298,300,306,308,310,311,312,313,316,345,346,348,350,351,352,354,356,357,359,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,637,638,639,640,641,642,643,644,645,646,647,648,649,651,652,653,654,655,657,658,659,660,661,663,664,665,666,667,669,670,671,673,675,676,677,678,680,681,682,683,684,688,690,700,703,709,716,757,759,763,765,767,770,773,774,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,964,965,966,967,968,969,970,971,972,973,974,975,976,977,978,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,996,997,998,999,1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029) ) AND `a`.`is_display` = '1' AND `substation_id` = 1 ) ) AND `a`.`delete_time` IS NULL [ RunTime:0.014504s ]
SELECT `keyword_id` FROM `shop_information_keyword_relation` WHERE `drawing_id` IS NOT NULL GROUP BY `keyword_id` [ RunTime:0.052945s ]
SELECT `a`.* FROM `shop_information_keyword` `a` WHERE ( ( ( `keyword_id` IN (13,14,15,17,18,19,20,21,22,23,24,25,26,27,30,31,32,33,34,35,37,38,40,41,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,72,73,74,75,76,82,83,87,89,91,92,94,97,99,100,103,104,105,107,108,109,110,111,113,116,117,118,119,120,121,122,123,124,125,135,136,137,138,141,153,154,155,156,158,166,167,168,170,172,180,181,182,183,188,189,190,191,192,193,194,195,196,197,198,199,206,207,208,209,210,212,219,223,224,225,226,235,237,238,246,247,248,250,251,254,255,259,261,262,295,298,300,306,308,310,311,312,313,316,345,346,348,350,351,352,354,356,357,359,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,556,557,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,591,592,593,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,637,638,639,640,641,642,643,644,645,646,647,648,649,651,652,653,654,655,657,658,659,660,661,663,664,665,666,667,669,670,671,673,675,676,677,678,680,681,682,683,684,688,690,700,703,709,716,757,759,763,765,767,770,773,774,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,964,965,966,967,968,969,970,971,972,973,974,975,976,977,978,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,996,997,998,999,1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029) ) AND `a`.`is_display` = '1' AND `substation_id` = 1 ) ) AND `a`.`delete_time` IS NULL ORDER BY a.update_time desc LIMIT 408,12 [ RunTime:0.014307s ]
SHOW FULL COLUMNS FROM `shop_config` [ RunTime:0.004762s ]
SELECT `config_name`,`config_id` FROM `shop_config` WHERE ( `config_type` = 'DrawingStyle' ) AND `shop_config`.`delete_time` IS NULL [ RunTime:0.004476s ]
SELECT `config_name`,`config_id` FROM `shop_config` WHERE ( `config_type` = 'DrawingFrameStructure' ) AND `shop_config`.`delete_time` IS NULL [ RunTime:0.005291s ]
SHOW FULL COLUMNS FROM `shop_drawing` [ RunTime:0.005635s ]
SELECT COUNT(*) AS think_count FROM `shop_drawing` `a` WHERE ( ( `a`.`attrs` NOT LIKE '%[541]%' AND `a`.`is_hot` = '1' ) AND `a`.`is_shel` = '1' ) [ RunTime:0.005823s ]
SELECT null is_jg,`a`.`price`,`a`.`price2`,`a`.`price3`,`a`.`cate`,`a`.`is_top`,`a`.`attrs`,`a`.`is_wholesale`,`a`.`is_new`,`a`.`drawing_id`,`a`.`topic`,`a`.`layct`,`a`.`style`,`a`.`no`,`a`.`cover`,a.cover thumbnail,`a`.`zarea`,`a`.`jarea`,`a`.`bprice1`,`a`.`bprice2`,`a`.`depth`,`a`.`open`,`a`.`struct`,null style_text,null layct_text,null struct_text FROM `shop_drawing` `a` WHERE ( ( `a`.`attrs` NOT LIKE '%[541]%' AND `a`.`is_hot` = '1' ) AND `a`.`is_shel` = '1' ) ORDER BY rand() LIMIT 204,6 [ RunTime:0.006849s ]
SHOW FULL COLUMNS FROM `shop_information` [ RunTime:0.006197s ]
SELECT COUNT(*) AS think_count FROM `shop_information` `a` WHERE ( ( `is_display` = '1' AND `substation_id` = 1 ) ) AND `a`.`delete_time` IS NULL [ RunTime:0.019233s ]
SELECT `a`.* FROM `shop_information` `a` WHERE ( ( `is_display` = '1' AND `substation_id` = 1 ) ) AND `a`.`delete_time` IS NULL ORDER BY create_time desc LIMIT 204,6 [ RunTime:0.021950s ]
SELECT COUNT(*) AS think_count FROM `shop_information` `a` WHERE ( ( `is_display` = '1' AND `substation_id` = 1 ) ) AND `a`.`delete_time` IS NULL [ RunTime:0.017508s ]
SELECT `a`.* FROM `shop_information` `a` WHERE ( ( `is_display` = '1' AND `substation_id` = 1 ) ) AND `a`.`delete_time` IS NULL ORDER BY reading_number desc LIMIT 204,6 [ RunTime:0.030620s ]
SELECT * FROM `shop_information_keyword` WHERE ( `is_display` = '1' AND `substation_id` = 1 ) AND `shop_information_keyword`.`delete_time` IS NULL ORDER BY rand() LIMIT 20 [ RunTime:0.010814s ]