SHOW FULL COLUMNS FROM `sxo_navigation` [ RunTime:0.000842s ]
SELECT `id`,`pid`,`name`,`url`,`value`,`data_type`,`is_new_window_open` FROM `sxo_navigation` WHERE `nav_type` = 'header' AND `is_show` = 1 AND `pid` = 0 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000626s ]
SELECT `id`,`pid`,`name`,`url`,`value`,`data_type`,`is_new_window_open` FROM `sxo_navigation` WHERE `nav_type` = 'header' AND `is_show` = 1 AND `pid` IN (62,56,58,59,60,61) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000536s ]
SELECT `id`,`pid`,`name`,`url`,`value`,`data_type`,`is_new_window_open` FROM `sxo_navigation` WHERE `nav_type` = 'footer' AND `is_show` = 1 AND `pid` = 0 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000472s ]
SELECT `id`,`pid`,`name`,`url`,`value`,`data_type`,`is_new_window_open` FROM `sxo_navigation` WHERE `nav_type` = 'footer' AND `is_show` = 1 AND `pid` IN (63,75,76,87) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000614s ]
SHOW FULL COLUMNS FROM `sxo_quick_nav` [ RunTime:0.000634s ]
SELECT `id`,`name`,`images_url`,`event_value`,`event_type`,`bg_color` FROM `sxo_quick_nav` WHERE `platform` = 'pc' AND `is_enable` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000470s ]
SHOW FULL COLUMNS FROM `sxo_goods_category` [ RunTime:0.000714s ]
SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `pid` = 0 AND `is_enable` = 1 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000934s ]
SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` = 4886 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000458s ]
SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` = 4443 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000702s ]
SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` IN (4444,4457,4460) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000760s ]
SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` = 4471 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000696s ]
SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` IN (4472,4475,4478,4481,4484) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000616s ]
SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` = 4487 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000803s ]
SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` IN (4500,4508,4518,4524,4532,4539,4542,4550) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.001056s ]
SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` = 4323 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000721s ]
SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` IN (4376,4381,4406,4414,4428,4324,4342) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.001562s ]
SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` = 4587 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000880s ]
SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` IN (4610,4615,4621,4629,4637,4655,4665,4674,4679,4683,4588,4603) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.001530s ]
SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` = 4488 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000818s ]
SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` IN (4489,4490,4491,4492,4493,4494,4495,4496,4497,4498,4499) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000535s ]
SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` = 4363 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000687s ]
SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` IN (4364,4365,4366,4367,4368,4369,4370,4371,4372,4373,4374,4375) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000618s ]
SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` = 4452 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000657s ]
SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` IN (4453,4454,4455,4456) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000474s ]
SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` = 4712 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000776s ]
SELECT `id`,`pid`,`icon`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `pid` IN (4713,4714,4715,4716) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000457s ]
SELECT `id` FROM `sxo_goods_category` WHERE `pid` = 4454 AND `is_enable` = 1 [ RunTime:0.000301s ]
SHOW FULL COLUMNS FROM `sxo_goods` [ RunTime:0.001007s ]
SELECT COUNT(DISTINCT `g`.`id`) AS think_count FROM `sxo_goods` `g` INNER JOIN `sxo_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `g`.`is_delete_time` = '0' AND `g`.`is_shelves` = '1' AND `gci`.`category_id` = '4454' LIMIT 1 [ RunTime:0.007029s ]
SELECT `g`.* FROM `sxo_goods` `g` INNER JOIN `sxo_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `g`.`is_delete_time` = '0' AND `g`.`is_shelves` = '1' AND `gci`.`category_id` = '4454' GROUP BY `g`.`id` ORDER BY `g`.`access_count` DESC,`g`.`sales_count` DESC,`g`.`id` DESC LIMIT 0,20 [ RunTime:0.033424s ]
SHOW FULL COLUMNS FROM `sxo_brand` [ RunTime:0.000555s ]
SELECT `name`,`id` FROM `sxo_brand` WHERE `id` IN (2748,2754,2321,2784,2757,2798,2572,2561,2724,2779,2564,2634,2811,2776,2635,2769) [ RunTime:0.000401s ]
SELECT distinct brand_id FROM `sxo_goods` WHERE `is_shelves` = 1 AND `is_delete_time` = 0 AND `brand_id` > 0 [ RunTime:0.077215s ]
SELECT `id`,`name`,`logo`,`website_url` FROM `sxo_brand` WHERE `is_enable` = 1 AND `id` IN (2321,2377,2320,2378,2339,2412,2416,2409,2379,2410,2411,2408,2413,2417,2414,2415,2338,2380,2381,2418,2342,2331,2340,2419,2420,2407,2395,2390,2394,2396,2397,2398,2399,2400,2401,2402,2335,2403,2404,2336,2405,2406,2392,2391,2382,2423,2421,2356,2426,2428,2429,2430,2431,2433,2432,2434,2435,2466,2436,2437,2438,2439,2442,2443,2444,2440,2446,2445,2332,2447,2448,2449,2450,2451,2452,2453,2454,2455,2422,2456,2457,2459,2460,2461,2462,2479,2465,2467,2468,2469,2470,2471,2472,2473,2474,2475,2476,2477,2478,2480,2481,2482,2484,2485,2487,2489,2493,2495,2496,2383,2492,2490,2497,2463,2322,2341,2502,2507,2508,2509,2511,2514,2503,2504,2515,2516,2517,2518,2519,2520,2385,2521,2389,2505,2498,2530,2531,2526,2522,2524,2523,2525,2527,2528,2529,2393,2491,2532,2533,2534,2535,2536,2538,2539,2540,2328,2541,2542,2543,2499,2544,2545,2546,2548,2549,2550,2551,2344,2559,2560,2561,2562,2563,2564,2565,2566,2567,2568,2569,2570,2571,2572,2573,2574,2575,2346,2576,2337,2351,2577,2578,2579,2581,2582,2583,2584,2585,2586,2587,2588,2589,2590,2591,2580,2592,2593,2594,2595,2596,2597,2598,2599,2600,2601,2603,2604,2605,2606,2607,2608,2609,2611,2612,2613,2614,2615,2616,2617,2618,2619,2620,2621,2622,2623,2624,2625,2626,2627,2628,2629,2630,2631,2632,2633,2634,2635,2636,2637,2638,2639,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2669,2670,2671,2672,2673,2355,2610,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684,2685,2686,2687,2688,2689,2690,2691,2692,2693,2694,2695,2696,2697,2698,2699,2700,2701,2702,2703,2704,2705,2706,2707,2708,2709,2710,2711,2712,2713,2714,2715,2716,2717,2721,2723,2724,2725,2726,2719,2728,2729,2730,2731,2732,2733,2734,2735,2736,2737,2738,2739,2740,2741,2742,2743,2744,2745,2747,2748,2749,2750,2751,2752,2387,2753,2754,2755,2756,2757,2758,2759,2760,2761,2762,2763,2764,2766,2765,2767,2768,2769,2771,2772,2773,2774,2775,2776,2777,2778,2779,2780,2354,2781,2782,2783,2784,2785,2786,2787,2788,2789,2790,2791,2792,2793,2794,2795,2796,2797,2798,2799,2720,2800,2801,2802,2803,2804,2805,2806,2807,2808,2809,2810,2811,2812,2813,2814,2815,2816,2818,2819,2820,2821,2822,2823,2824,2825,2826,2827,2828,2829,2830,2831,2832,2833,2834,2835,2836,2364,2837,2838,2839,2840,2841,2842,2843,2844,2845,2846,2847,2848,2849,2850,2851,2852,2853,2854,2855,2856,2857,2858,2859,2860,2861,2862,2863,2864,2865,2866,2867,2868,2869,2870,2871,2872,2873,2875,2668,2876,2877,2878,2879,2880,2881,2882,2883,2884,2885,2886,2887,2888,2889,2890,2891,2892,2893,2894,2895,2896,2897,2898,2899,2900,2901,2902,2903,2904,2905,2906,2907,2908,2909,2910,2911,2912,2913,2914,2916,2917,2918,2920,2921,2922,2923,2874,2924,2925,2926,2927,2928,2929,2931,2933,2934,2935,2936,2334,2937,2938,2939,2940,2941,2942,2943,2944,2945,2946,2947,2948,2949,2950,2951,2952,2953,2954,2955,2956,2957,2959,2960,2961,2962,2963,2964,2965,2966,2967,2968,2969,2970,2971,2972,2973,2974,2975,2976,2977,2978,2979,2980,2981,2982,2983,2984,2985,2986,2988,2990,2991,2992,2993,2994,2995,2996,2997,2998,2999,3000,3001,3002,3003,3004,3005,3006,3007,3008,3009,3010,3011,3012,3013,3014,3015,3016,3017,3018,3019,3020,3021,3022,3023,3024,3025,3026,3027,3028,3029,3030,3031,3032,3033,3034,3035,3036,3037,3038,3039,3040,3041,3042,3043,3044,3045,3046,3047,3048,3049,3050,3051,3052,3053,3054,3055,3056,3057,3058,3061,3062,3063,3064,3065,3066,3067,3068,3069,2358,3070,3071,2371,3072,3073,3074,3075,3076,3077,3078,3079,3080,3081,3082,3083,3084,3085,3086,3087,3088,3089,3090,3091,3092,3093,3094,3095,3096,3097,3098,3099,3100,3101,3102,3103,3104,3105,3106,3107,3108,3109,3110,3111,3112,3113,3114,3115,3116,3117,3118,3119,3120,3121,3122,3124,3123,3125,3126,3127,3128,3129,3130,3131,3132,3133,3134,3135,3136,3137,2343,3138,3139,3140,3141,3142,3143,3144,3145,3146,3148,3149,3150,3151,3152,3153,3154,3155,3156,3157,3158,3159,3160,3161,3162,3163,3164,3165,3166,3167,3168,3169,3170,3171,3172,3173,3174,3175,3176,3177,3178,3179,3180,3181,3059,3182,3183,3184,3185,3147,3186,3187,3188,3189,3190,3191,3192,3197,3201,3205,3203,3211,3212,3195,3213,3215,3216,3217,3218,3219,3220,3196,3222,3223,3224,3225,3226,3227,3228,3209,3229,3230,3231,3232,3233,3200,3234,3235,3236,3237,3238,3239,3240,3241,3242,3243,3244,3245,3246,3247,3248,3249,3250,3251,3252,3253,3254,3255,3256,3208,3257,3258,3259,3260,3214,3261,3262,3263,3264,3265,3266,3267,3268,3269,3270,3271,3272,3275,3276,3277,3278,3279,3280,3281,3282,3283,3284,3285,3286,3287,3288,3289,3290,3291,3292,3293,3294,3295,3297,3298,3299,3296,3301,3302,3303,3304,3305,3306,3307,3308,3309,3310,3311,3313,3314,3315,3316,3317,3318,3319,3320,3321,3322,3323,3324,3325,3326,3327,3328,3329,3330,3331,3332,3333,3334,3335,3336,3337,3338,3339,3340,3342,3341,3343,3344,3345,3346,3347,3348,3349,3350,3353,3354,3355,3356,3357,3358,3359,3360,3361,3362,3363,3365,3366,3367,3368,3369,3370,3371,3372,3373,3374,3375,3376,3377,3378,3379,3380,3381,3382,3383,3384,3385,3386,3387,3388,3389,3390,3391,3392,3393,3394,3395,3396,3397,3398,3399,3400,3401,3402,3403,3404,3405,3406,3407,3408,3409,3410,3411,3412,3413,3414,3415,3416,3417,3418,3419,3420,3421,3422,3423,3424,3425,3426,3427,3428,3429,3430,3431,3432,3433,3434,3435,3436,3437,3438,3439,3440,3441,3442,3443,3444,3445,3446,3447,3448,3449,3450,3451,3452,3453,3454,3455,3456,3457,3458,3459,3461,3462,3463,3464,3465,3466,3467,3468,3469,3470,3471,3472,3473,3474,3475,3476,3477) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.008509s ]
SHOW FULL COLUMNS FROM `sxo_brand_category_join` [ RunTime:0.000576s ]
SELECT `brand_id`,`brand_category_id` FROM `sxo_brand_category_join` WHERE `brand_id` IN (2320,2321,2322,2328,2331,2332,2334,2335,2336,2337,2338,2339,2340,2341,2342,2343,2344,2346,2351,2354,2355,2356,2358,2364,2371,2377,2378,2379,2380,2381,2382,2383,2385,2387,2389,2390,2391,2392,2393,2394,2395,2396,2397,2398,2399,2400,2401,2402,2403,2404,2405,2406,2407,2408,2409,2410,2411,2412,2413,2414,2415,2416,2417,2418,2419,2420,2421,2422,2423,2426,2428,2429,2430,2431,2432,2433,2434,2435,2436,2437,2438,2439,2440,2442,2443,2444,2445,2446,2447,2448,2449,2450,2451,2452,2453,2454,2455,2456,2457,2459,2460,2461,2462,2463,2465,2466,2467,2468,2469,2470,2471,2472,2473,2474,2475,2476,2477,2478,2479,2480,2481,2482,2484,2485,2487,2489,2490,2491,2492,2493,2495,2496,2497,2498,2499,2502,2503,2504,2505,2507,2508,2509,2511,2514,2515,2516,2517,2518,2519,2520,2521,2522,2523,2524,2525,2526,2527,2528,2529,2530,2531,2532,2533,2534,2535,2536,2538,2539,2540,2541,2542,2543,2544,2545,2546,2548,2549,2550,2551,2559,2560,2561,2562,2563,2564,2565,2566,2567,2568,2569,2570,2571,2572,2573,2574,2575,2576,2577,2578,2579,2580,2581,2582,2583,2584,2585,2586,2587,2588,2589,2590,2591,2592,2593,2594,2595,2596,2597,2598,2599,2600,2601,2603,2604,2605,2606,2607,2608,2609,2610,2611,2612,2613,2614,2615,2616,2617,2618,2619,2620,2621,2622,2623,2624,2625,2626,2627,2628,2629,2630,2631,2632,2633,2634,2635,2636,2637,2638,2639,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684,2685,2686,2687,2688,2689,2690,2691,2692,2693,2694,2695,2696,2697,2698,2699,2700,2701,2702,2703,2704,2705,2706,2707,2708,2709,2710,2711,2712,2713,2714,2715,2716,2717,2719,2720,2721,2723,2724,2725,2726,2728,2729,2730,2731,2732,2733,2734,2735,2736,2737,2738,2739,2740,2741,2742,2743,2744,2745,2747,2748,2749,2750,2751,2752,2753,2754,2755,2756,2757,2758,2759,2760,2761,2762,2763,2764,2765,2766,2767,2768,2769,2771,2772,2773,2774,2775,2776,2777,2778,2779,2780,2781,2782,2783,2784,2785,2786,2787,2788,2789,2790,2791,2792,2793,2794,2795,2796,2797,2798,2799,2800,2801,2802,2803,2804,2805,2806,2807,2808,2809,2810,2811,2812,2813,2814,2815,2816,2818,2819,2820,2821,2822,2823,2824,2825,2826,2827,2828,2829,2830,2831,2832,2833,2834,2835,2836,2837,2838,2839,2840,2841,2842,2843,2844,2845,2846,2847,2848,2849,2850,2851,2852,2853,2854,2855,2856,2857,2858,2859,2860,2861,2862,2863,2864,2865,2866,2867,2868,2869,2870,2871,2872,2873,2874,2875,2876,2877,2878,2879,2880,2881,2882,2883,2884,2885,2886,2887,2888,2889,2890,2891,2892,2893,2894,2895,2896,2897,2898,2899,2900,2901,2902,2903,2904,2905,2906,2907,2908,2909,2910,2911,2912,2913,2914,2916,2917,2918,2920,2921,2922,2923,2924,2925,2926,2927,2928,2929,2931,2933,2934,2935,2936,2937,2938,2939,2940,2941,2942,2943,2944,2945,2946,2947,2948,2949,2950,2951,2952,2953,2954,2955,2956,2957,2959,2960,2961,2962,2963,2964,2965,2966,2967,2968,2969,2970,2971,2972,2973,2974,2975,2976,2977,2978,2979,2980,2981,2982,2983,2984,2985,2986,2988,2990,2991,2992,2993,2994,2995,2996,2997,2998,2999,3000,3001,3002,3003,3004,3005,3006,3007,3008,3009,3010,3011,3012,3013,3014,3015,3016,3017,3018,3019,3020,3021,3022,3023,3024,3025,3026,3027,3028,3029,3030,3031,3032,3033,3034,3035,3036,3037,3038,3039,3040,3041,3042,3043,3044,3045,3046,3047,3048,3049,3050,3051,3052,3053,3054,3055,3056,3057,3058,3059,3061,3062,3063,3064,3065,3066,3067,3068,3069,3070,3071,3072,3073,3074,3075,3076,3077,3078,3079,3080,3081,3082,3083,3084,3085,3086,3087,3088,3089,3090,3091,3092,3093,3094,3095,3096,3097,3098,3099,3100,3101,3102,3103,3104,3105,3106,3107,3108,3109,3110,3111,3112,3113,3114,3115,3116,3117,3118,3119,3120,3121,3122,3123,3124,3125,3126,3127,3128,3129,3130,3131,3132,3133,3134,3135,3136,3137,3138,3139,3140,3141,3142,3143,3144,3145,3146,3147,3148,3149,3150,3151,3152,3153,3154,3155,3156,3157,3158,3159,3160,3161,3162,3163,3164,3165,3166,3167,3168,3169,3170,3171,3172,3173,3174,3175,3176,3177,3178,3179,3180,3181,3182,3183,3184,3185,3186,3187,3188,3189,3190,3191,3192,3195,3196,3197,3200,3201,3203,3205,3208,3209,3211,3212,3213,3214,3215,3216,3217,3218,3219,3220,3222,3223,3224,3225,3226,3227,3228,3229,3230,3231,3232,3233,3234,3235,3236,3237,3238,3239,3240,3241,3242,3243,3244,3245,3246,3247,3248,3249,3250,3251,3252,3253,3254,3255,3256,3257,3258,3259,3260,3261,3262,3263,3264,3265,3266,3267,3268,3269,3270,3271,3272,3275,3276,3277,3278,3279,3280,3281,3282,3283,3284,3285,3286,3287,3288,3289,3290,3291,3292,3293,3294,3295,3296,3297,3298,3299,3301,3302,3303,3304,3305,3306,3307,3308,3309,3310,3311,3313,3314,3315,3316,3317,3318,3319,3320,3321,3322,3323,3324,3325,3326,3327,3328,3329,3330,3331,3332,3333,3334,3335,3336,3337,3338,3339,3340,3341,3342,3343,3344,3345,3346,3347,3348,3349,3350,3353,3354,3355,3356,3357,3358,3359,3360,3361,3362,3363,3365,3366,3367,3368,3369,3370,3371,3372,3373,3374,3375,3376,3377,3378,3379,3380,3381,3382,3383,3384,3385,3386,3387,3388,3389,3390,3391,3392,3393,3394,3395,3396,3397,3398,3399,3400,3401,3402,3403,3404,3405,3406,3407,3408,3409,3410,3411,3412,3413,3414,3415,3416,3417,3418,3419,3420,3421,3422,3423,3424,3425,3426,3427,3428,3429,3430,3431,3432,3433,3434,3435,3436,3437,3438,3439,3440,3441,3442,3443,3444,3445,3446,3447,3448,3449,3450,3451,3452,3453,3454,3455,3456,3457,3458,3459,3461,3462,3463,3464,3465,3466,3467,3468,3469,3470,3471,3472,3473,3474,3475,3476,3477) [ RunTime:0.004282s ]
SHOW FULL COLUMNS FROM `sxo_brand_category` [ RunTime:0.000476s ]
SELECT `name`,`id` FROM `sxo_brand_category` WHERE `id` IN (1,2) [ RunTime:0.000204s ]
SELECT `name`,`vice_name`,`describe`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sxo_goods_category` WHERE `is_enable` = 1 AND `id` = 4454 LIMIT 1 [ RunTime:0.000440s ]
SELECT `pid` FROM `sxo_goods_category` WHERE `id` = 4454 LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`name` FROM `sxo_goods_category` WHERE `pid` = 4452 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000699s ]
SHOW FULL COLUMNS FROM `sxo_screening_price` [ RunTime:0.000697s ]
SELECT `id`,`name`,`min_price`,`max_price` FROM `sxo_screening_price` WHERE `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000474s ]
SELECT `gp`.`value` FROM `sxo_goods` `g` INNER JOIN `sxo_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` INNER JOIN `sxo_goods_params` `gp` ON `g`.`id`=`gp`.`goods_id` WHERE `g`.`is_delete_time` = '0' AND `g`.`is_shelves` = '1' AND `gci`.`category_id` = '4454' AND `gp`.`type` = '2' GROUP BY `gp`.`value` [ RunTime:0.000788s ]
SELECT `gsv`.`value` FROM `sxo_goods` `g` INNER JOIN `sxo_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` INNER JOIN `sxo_goods_spec_value` `gsv` ON `g`.`id`=`gsv`.`goods_id` WHERE `g`.`is_delete_time` = '0' AND `g`.`is_shelves` = '1' AND `gci`.`category_id` = '4454' GROUP BY `gsv`.`value` [ RunTime:0.000878s ]
SELECT `id`,`pid`,`name` FROM `sxo_goods_category` WHERE `id` = 4454 AND `is_enable` = 1 LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`pid`,`name` FROM `sxo_goods_category` WHERE `pid` = 4452 AND `is_enable` = 1 [ RunTime:0.000616s ]
SELECT `id`,`pid`,`name` FROM `sxo_goods_category` WHERE `id` = 4452 AND `is_enable` = 1 LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`pid`,`name` FROM `sxo_goods_category` WHERE `pid` = 0 AND `is_enable` = 1 [ RunTime:0.000752s ]
SELECT `id`,`pid`,`name` FROM `sxo_goods_category` WHERE `id` = 0 AND `is_enable` = 1 LIMIT 1 [ RunTime:0.000335s ]
SHOW FULL COLUMNS FROM `sxo_search_history` [ RunTime:0.000709s ]
