Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

42 Database Queries

23 Different statements

507.93 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
469.81 ms (92.49%)	20	SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.meta_key AS meta_key_2, p0_.type AS type_3, p0_.not_blank AS not_blank_4, p0_.form_option AS form_option_5, p0_.file_validation AS file_validation_6, p0_.sort AS sort_7, p1_.id AS id_8, p1_.product_id AS product_id_9, p1_.meta_key AS meta_key_10, p1_.meta_content AS meta_content_11 FROM plg_product_field_config p0_ LEFT JOIN plg_product_field_content p1_ ON ((p1_.product_id = ? OR p1_.product_id IS NULL) AND p0_.meta_key = p1_.meta_key) WHERE p0_.meta_key = ? ORDER BY p0_.sort ASC Parameters: [`6972 "related_keyword"`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.meta_key AS meta_key_2, p0_.type AS type_3, p0_.not_blank AS not_blank_4, p0_.form_option AS form_option_5, p0_.file_validation AS file_validation_6, p0_.sort AS sort_7, p1_.id AS id_8, p1_.product_id AS product_id_9, p1_.meta_key AS meta_key_10, p1_.meta_content AS meta_content_11 FROM plg_product_field_config p0_ LEFT JOIN plg_product_field_content p1_ ON ( ( p1_.product_id = ? OR p1_.product_id IS NULL ) AND p0_.meta_key = p1_.meta_key ) WHERE p0_.meta_key = ? ORDER BY p0_.sort ASC SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.meta_key AS meta_key_2, p0_.type AS type_3, p0_.not_blank AS not_blank_4, p0_.form_option AS form_option_5, p0_.file_validation AS file_validation_6, p0_.sort AS sort_7, p1_.id AS id_8, p1_.product_id AS product_id_9, p1_.meta_key AS meta_key_10, p1_.meta_content AS meta_content_11 FROM plg_product_field_config p0_ LEFT JOIN plg_product_field_content p1_ ON ((p1_.product_id = 6972 OR p1_.product_id IS NULL) AND p0_.meta_key = p1_.meta_key) WHERE p0_.meta_key = 'related_keyword' ORDER BY p0_.sort ASC;
18.28 ms (3.60%)	1	SELECT p0_.product_id AS product_id_0, p0_.meta_content AS meta_content_1 FROM plg_product_field_content p0_ WHERE p0_.meta_key = ? AND p0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: ["related_keyword" 1035 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 3060 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 3193 3194 3195 3196 3197 3198 3199 3200 3201 3202 3203 3204 3205 3206 3207 3208 3209 3210 3211 3212 3213 3214 3215 3216 3217 3218 3219 3220 3221 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 3273 3274 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 3300 3301 3302 3303 3304 3305 3306 3307 3308 3309 3310 3311 3312 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 3351 3352 3353 3354 3355 3356 3357 3358 3359 3360 3361 3362 3363 3364 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 3460 3461 3462 3463 3464 3465 3466 3467 3468 3469 3470 3471 3472 3473 3474 3475 3476 3477 3478 3479 3480 3481 3482 3483 3484 3485 3486 3487 3488 3489 3490 3491 3492 3493 3494 3495 3496 3497 3498 3499 3500 3501 3502 3503 3504 3505 3506 3507 3508 3509 3510 3511 3512 3513 3514 3515 3516 3517 3518 3519 3520 3521 3522 3523 3524 3525 3526 3527 3528 3529 3530 3531 3532 3533 3534 3535 3536 3537 3538 3539 3540 3541 3542 3543 3544 3545 3546 3547 3548 3549 3550 3551 3552 3553 3554 3555 3556 3557 3558 3559 3560 3561 3562 3563 3564 3565 3566 3567 3568 3569 3570 3571 3572 3573 3574 3575 3576 3577 3578 3579 3580 3581 3582 3583 3584 3585 3586 3587 3588 3589 3590 3591 3592 3593 3594 3595 3596 3597 3598 3599 3600 3601 3602 3603 3604 3605 3606 3607 3608 3609 3610 3611 3612 3613 3614 3615 3616 3617 3618 3619 3620 3621 3622 3623 3624 3625 3626 3627 3628 3629 3630 3631 3632 3633 3634 3635 3636 3637 3638 3639 3640 3641 3642 3643 3644 3645 3646 3647 3648 3649 3650 3651 3652 3653 3654 3655 3656 3657 3658 3659 3660 3661 3662 3663 3664 3665 3666 3667 3668 3669 3670 3671 3672 3673 3674 3675 3676 3677 3678 3679 3680 3681 3682 3683 3684 3685 3686 3687 3688 3689 3690 3691 3692 3693 3694 3695 3696 3697 3698 3699 3700 3701 3702 3703 3704 3705 3706 3707 3708 3709 3710 3711 6498 6499 6500 6501 6502 6503 6504 6505 6506 6507 6508 6509 6510 6511 6512 6513 6514 6515 6516 6517 6518 6519 6520 6521 6522 6523 6524 6525 6526 6527 6528 6529 6530 6531 6758 6892 6893 6894 6895 6896 6897 6898 6899 6900 6901 6902 6903 6904 6905 6906 6907 6908 6909 6910 6911 6912 6913 6914 6915 6916 6917 6918 6919 6920 6921 6922 6923 6924 6925 6926 6927 6928 6929 6930 6931 6932 6933 6934 6935 6936 6937 6938 6939 6940 6941 6942 6943 6944 6945 6946 6947 6948 6949 6950 6951 6952 6953 6954 6955 6956 6957 6958 6959 6960 6961 6962 6963 6964 6965 6966 6967 6968 6969 6970 6971 6972 7690 7691 7692 7693 7694 7695 7696 7697 7698 7699 7700 7701 7702 7703 7704 7705 7706 7707 7708 7709 7710 7711 7712 7713 7714 7715 7716 7717 7718] View formatted query View runnable query Explain query SELECT p0_.product_id AS product_id_0, p0_.meta_content AS meta_content_1 FROM plg_product_field_content p0_ WHERE p0_.meta_key = ? AND p0_.product_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) SELECT p0_.product_id AS product_id_0, p0_.meta_content AS meta_content_1 FROM plg_product_field_content p0_ WHERE p0_.meta_key = 'related_keyword' AND p0_.product_id IN (1035, 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, 3060, 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, 3193, 3194, 3195, 3196, 3197, 3198, 3199, 3200, 3201, 3202, 3203, 3204, 3205, 3206, 3207, 3208, 3209, 3210, 3211, 3212, 3213, 3214, 3215, 3216, 3217, 3218, 3219, 3220, 3221, 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, 3273, 3274, 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, 3300, 3301, 3302, 3303, 3304, 3305, 3306, 3307, 3308, 3309, 3310, 3311, 3312, 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, 3351, 3352, 3353, 3354, 3355, 3356, 3357, 3358, 3359, 3360, 3361, 3362, 3363, 3364, 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, 3460, 3461, 3462, 3463, 3464, 3465, 3466, 3467, 3468, 3469, 3470, 3471, 3472, 3473, 3474, 3475, 3476, 3477, 3478, 3479, 3480, 3481, 3482, 3483, 3484, 3485, 3486, 3487, 3488, 3489, 3490, 3491, 3492, 3493, 3494, 3495, 3496, 3497, 3498, 3499, 3500, 3501, 3502, 3503, 3504, 3505, 3506, 3507, 3508, 3509, 3510, 3511, 3512, 3513, 3514, 3515, 3516, 3517, 3518, 3519, 3520, 3521, 3522, 3523, 3524, 3525, 3526, 3527, 3528, 3529, 3530, 3531, 3532, 3533, 3534, 3535, 3536, 3537, 3538, 3539, 3540, 3541, 3542, 3543, 3544, 3545, 3546, 3547, 3548, 3549, 3550, 3551, 3552, 3553, 3554, 3555, 3556, 3557, 3558, 3559, 3560, 3561, 3562, 3563, 3564, 3565, 3566, 3567, 3568, 3569, 3570, 3571, 3572, 3573, 3574, 3575, 3576, 3577, 3578, 3579, 3580, 3581, 3582, 3583, 3584, 3585, 3586, 3587, 3588, 3589, 3590, 3591, 3592, 3593, 3594, 3595, 3596, 3597, 3598, 3599, 3600, 3601, 3602, 3603, 3604, 3605, 3606, 3607, 3608, 3609, 3610, 3611, 3612, 3613, 3614, 3615, 3616, 3617, 3618, 3619, 3620, 3621, 3622, 3623, 3624, 3625, 3626, 3627, 3628, 3629, 3630, 3631, 3632, 3633, 3634, 3635, 3636, 3637, 3638, 3639, 3640, 3641, 3642, 3643, 3644, 3645, 3646, 3647, 3648, 3649, 3650, 3651, 3652, 3653, 3654, 3655, 3656, 3657, 3658, 3659, 3660, 3661, 3662, 3663, 3664, 3665, 3666, 3667, 3668, 3669, 3670, 3671, 3672, 3673, 3674, 3675, 3676, 3677, 3678, 3679, 3680, 3681, 3682, 3683, 3684, 3685, 3686, 3687, 3688, 3689, 3690, 3691, 3692, 3693, 3694, 3695, 3696, 3697, 3698, 3699, 3700, 3701, 3702, 3703, 3704, 3705, 3706, 3707, 3708, 3709, 3710, 3711, 6498, 6499, 6500, 6501, 6502, 6503, 6504, 6505, 6506, 6507, 6508, 6509, 6510, 6511, 6512, 6513, 6514, 6515, 6516, 6517, 6518, 6519, 6520, 6521, 6522, 6523, 6524, 6525, 6526, 6527, 6528, 6529, 6530, 6531, 6758, 6892, 6893, 6894, 6895, 6896, 6897, 6898, 6899, 6900, 6901, 6902, 6903, 6904, 6905, 6906, 6907, 6908, 6909, 6910, 6911, 6912, 6913, 6914, 6915, 6916, 6917, 6918, 6919, 6920, 6921, 6922, 6923, 6924, 6925, 6926, 6927, 6928, 6929, 6930, 6931, 6932, 6933, 6934, 6935, 6936, 6937, 6938, 6939, 6940, 6941, 6942, 6943, 6944, 6945, 6946, 6947, 6948, 6949, 6950, 6951, 6952, 6953, 6954, 6955, 6956, 6957, 6958, 6959, 6960, 6961, 6962, 6963, 6964, 6965, 6966, 6967, 6968, 6969, 6970, 6971, 6972, 7690, 7691, 7692, 7693, 7694, 7695, 7696, 7697, 7698, 7699, 7700, 7701, 7702, 7703, 7704, 7705, 7706, 7707, 7708, 7709, 7710, 7711, 7712, 7713, 7714, 7715, 7716, 7717, 7718);
3.50 ms (0.69%)	1	SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.note AS note_2, d0_.description_list AS description_list_3, d0_.description_detail AS description_detail_4, d0_.search_word AS search_word_5, d0_.free_area AS free_area_6, d0_.create_date AS create_date_7, d0_.update_date AS update_date_8, d0_.maker_prices AS maker_prices_9, d0_.option_area AS option_area_10, d0_.option_item_area AS option_item_area_11, d0_.recommend_point AS recommend_point_12, d0_.sales_infomation AS sales_infomation_13, d0_.list_spec AS list_spec_14, d0_.maker_url AS maker_url_15, d1_.id AS id_16, d1_.product_code AS product_code_17, d1_.stock AS stock_18, d1_.stock_unlimited AS stock_unlimited_19, d1_.sale_limit AS sale_limit_20, d1_.price01 AS price01_21, d1_.price02 AS price02_22, d1_.delivery_fee AS delivery_fee_23, d1_.visible AS visible_24, d1_.create_date AS create_date_25, d1_.update_date AS update_date_26, d1_.currency_code AS currency_code_27, d1_.point_rate AS point_rate_28, d2_.id AS id_29, d2_.tax_rate AS tax_rate_30, d2_.tax_adjust AS tax_adjust_31, d2_.apply_date AS apply_date_32, d2_.create_date AS create_date_33, d2_.update_date AS update_date_34, d3_.id AS id_35, d3_.stock AS stock_36, d3_.create_date AS create_date_37, d3_.update_date AS update_date_38, d4_.id AS id_39, d4_.backend_name AS backend_name_40, d4_.name AS name_41, d4_.sort_no AS sort_no_42, d4_.visible AS visible_43, d4_.create_date AS create_date_44, d4_.update_date AS update_date_45, d5_.id AS id_46, d5_.backend_name AS backend_name_47, d5_.name AS name_48, d5_.sort_no AS sort_no_49, d5_.visible AS visible_50, d5_.create_date AS create_date_51, d5_.update_date AS update_date_52, d6_.id AS id_53, d6_.file_name AS file_name_54, d6_.sort_no AS sort_no_55, d6_.create_date AS create_date_56, d7_.id AS id_57, d7_.create_date AS create_date_58, d0_.discriminator_type AS discriminator_type_59, d0_.creator_id AS creator_id_60, d0_.product_status_id AS product_status_id_61, d0_.maker_id AS maker_id_62, d1_.discriminator_type AS discriminator_type_63, d1_.product_id AS product_id_64, d1_.sale_type_id AS sale_type_id_65, d1_.class_category_id1 AS class_category_id1_66, d1_.class_category_id2 AS class_category_id2_67, d1_.delivery_duration_id AS delivery_duration_id_68, d1_.creator_id AS creator_id_69, d2_.discriminator_type AS discriminator_type_70, d2_.product_class_id AS product_class_id_71, d2_.creator_id AS creator_id_72, d2_.country_id AS country_id_73, d2_.pref_id AS pref_id_74, d2_.product_id AS product_id_75, d2_.rounding_type_id AS rounding_type_id_76, d3_.discriminator_type AS discriminator_type_77, d3_.product_class_id AS product_class_id_78, d3_.creator_id AS creator_id_79, d4_.discriminator_type AS discriminator_type_80, d4_.class_name_id AS class_name_id_81, d4_.creator_id AS creator_id_82, d5_.discriminator_type AS discriminator_type_83, d5_.class_name_id AS class_name_id_84, d5_.creator_id AS creator_id_85, d6_.discriminator_type AS discriminator_type_86, d6_.product_id AS product_id_87, d6_.creator_id AS creator_id_88, d7_.discriminator_type AS discriminator_type_89, d7_.product_id AS product_id_90, d7_.tag_id AS tag_id_91, d7_.creator_id AS creator_id_92 FROM dtb_product d0_ INNER JOIN dtb_product_class d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productclass') LEFT JOIN dtb_tax_rule d2_ ON d1_.id = d2_.product_class_id AND d2_.discriminator_type IN ('taxrule') INNER JOIN dtb_product_stock d3_ ON d1_.id = d3_.product_class_id AND d3_.discriminator_type IN ('productstock') LEFT JOIN dtb_class_category d4_ ON d1_.class_category_id1 = d4_.id AND d4_.discriminator_type IN ('classcategory') LEFT JOIN dtb_class_category d5_ ON d1_.class_category_id2 = d5_.id AND d5_.discriminator_type IN ('classcategory') LEFT JOIN dtb_product_image d6_ ON d0_.id = d6_.product_id AND d6_.discriminator_type IN ('productimage') LEFT JOIN dtb_product_tag d7_ ON d0_.id = d7_.product_id AND d7_.discriminator_type IN ('producttag') WHERE (d0_.id IN (6972, 6971, 6970, 6969, 6968, 6967, 6966, 6965, 6964, 6963, 6962, 6961, 6960, 6959, 6958, 6957, 6956, 6955, 6954, 6953) AND d1_.visible = ?) AND d0_.discriminator_type IN ('product') ORDER BY d4_.sort_no DESC, d5_.sort_no DESC, d6_.sort_no ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.note AS note_2, d0_.description_list AS description_list_3, d0_.description_detail AS description_detail_4, d0_.search_word AS search_word_5, d0_.free_area AS free_area_6, d0_.create_date AS create_date_7, d0_.update_date AS update_date_8, d0_.maker_prices AS maker_prices_9, d0_.option_area AS option_area_10, d0_.option_item_area AS option_item_area_11, d0_.recommend_point AS recommend_point_12, d0_.sales_infomation AS sales_infomation_13, d0_.list_spec AS list_spec_14, d0_.maker_url AS maker_url_15, d1_.id AS id_16, d1_.product_code AS product_code_17, d1_.stock AS stock_18, d1_.stock_unlimited AS stock_unlimited_19, d1_.sale_limit AS sale_limit_20, d1_.price01 AS price01_21, d1_.price02 AS price02_22, d1_.delivery_fee AS delivery_fee_23, d1_.visible AS visible_24, d1_.create_date AS create_date_25, d1_.update_date AS update_date_26, d1_.currency_code AS currency_code_27, d1_.point_rate AS point_rate_28, d2_.id AS id_29, d2_.tax_rate AS tax_rate_30, d2_.tax_adjust AS tax_adjust_31, d2_.apply_date AS apply_date_32, d2_.create_date AS create_date_33, d2_.update_date AS update_date_34, d3_.id AS id_35, d3_.stock AS stock_36, d3_.create_date AS create_date_37, d3_.update_date AS update_date_38, d4_.id AS id_39, d4_.backend_name AS backend_name_40, d4_.name AS name_41, d4_.sort_no AS sort_no_42, d4_.visible AS visible_43, d4_.create_date AS create_date_44, d4_.update_date AS update_date_45, d5_.id AS id_46, d5_.backend_name AS backend_name_47, d5_.name AS name_48, d5_.sort_no AS sort_no_49, d5_.visible AS visible_50, d5_.create_date AS create_date_51, d5_.update_date AS update_date_52, d6_.id AS id_53, d6_.file_name AS file_name_54, d6_.sort_no AS sort_no_55, d6_.create_date AS create_date_56, d7_.id AS id_57, d7_.create_date AS create_date_58, d0_.discriminator_type AS discriminator_type_59, d0_.creator_id AS creator_id_60, d0_.product_status_id AS product_status_id_61, d0_.maker_id AS maker_id_62, d1_.discriminator_type AS discriminator_type_63, d1_.product_id AS product_id_64, d1_.sale_type_id AS sale_type_id_65, d1_.class_category_id1 AS class_category_id1_66, d1_.class_category_id2 AS class_category_id2_67, d1_.delivery_duration_id AS delivery_duration_id_68, d1_.creator_id AS creator_id_69, d2_.discriminator_type AS discriminator_type_70, d2_.product_class_id AS product_class_id_71, d2_.creator_id AS creator_id_72, d2_.country_id AS country_id_73, d2_.pref_id AS pref_id_74, d2_.product_id AS product_id_75, d2_.rounding_type_id AS rounding_type_id_76, d3_.discriminator_type AS discriminator_type_77, d3_.product_class_id AS product_class_id_78, d3_.creator_id AS creator_id_79, d4_.discriminator_type AS discriminator_type_80, d4_.class_name_id AS class_name_id_81, d4_.creator_id AS creator_id_82, d5_.discriminator_type AS discriminator_type_83, d5_.class_name_id AS class_name_id_84, d5_.creator_id AS creator_id_85, d6_.discriminator_type AS discriminator_type_86, d6_.product_id AS product_id_87, d6_.creator_id AS creator_id_88, d7_.discriminator_type AS discriminator_type_89, d7_.product_id AS product_id_90, d7_.tag_id AS tag_id_91, d7_.creator_id AS creator_id_92 FROM dtb_product d0_ INNER JOIN dtb_product_class d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productclass') LEFT JOIN dtb_tax_rule d2_ ON d1_.id = d2_.product_class_id AND d2_.discriminator_type IN ('taxrule') INNER JOIN dtb_product_stock d3_ ON d1_.id = d3_.product_class_id AND d3_.discriminator_type IN ('productstock') LEFT JOIN dtb_class_category d4_ ON d1_.class_category_id1 = d4_.id AND d4_.discriminator_type IN ('classcategory') LEFT JOIN dtb_class_category d5_ ON d1_.class_category_id2 = d5_.id AND d5_.discriminator_type IN ('classcategory') LEFT JOIN dtb_product_image d6_ ON d0_.id = d6_.product_id AND d6_.discriminator_type IN ('productimage') LEFT JOIN dtb_product_tag d7_ ON d0_.id = d7_.product_id AND d7_.discriminator_type IN ('producttag') WHERE ( d0_.id IN ( 6972, 6971, 6970, 6969, 6968, 6967, 6966, 6965, 6964, 6963, 6962, 6961, 6960, 6959, 6958, 6957, 6956, 6955, 6954, 6953 ) AND d1_.visible = ? ) AND d0_.discriminator_type IN ('product') ORDER BY d4_.sort_no DESC, d5_.sort_no DESC, d6_.sort_no ASC SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.note AS note_2, d0_.description_list AS description_list_3, d0_.description_detail AS description_detail_4, d0_.search_word AS search_word_5, d0_.free_area AS free_area_6, d0_.create_date AS create_date_7, d0_.update_date AS update_date_8, d0_.maker_prices AS maker_prices_9, d0_.option_area AS option_area_10, d0_.option_item_area AS option_item_area_11, d0_.recommend_point AS recommend_point_12, d0_.sales_infomation AS sales_infomation_13, d0_.list_spec AS list_spec_14, d0_.maker_url AS maker_url_15, d1_.id AS id_16, d1_.product_code AS product_code_17, d1_.stock AS stock_18, d1_.stock_unlimited AS stock_unlimited_19, d1_.sale_limit AS sale_limit_20, d1_.price01 AS price01_21, d1_.price02 AS price02_22, d1_.delivery_fee AS delivery_fee_23, d1_.visible AS visible_24, d1_.create_date AS create_date_25, d1_.update_date AS update_date_26, d1_.currency_code AS currency_code_27, d1_.point_rate AS point_rate_28, d2_.id AS id_29, d2_.tax_rate AS tax_rate_30, d2_.tax_adjust AS tax_adjust_31, d2_.apply_date AS apply_date_32, d2_.create_date AS create_date_33, d2_.update_date AS update_date_34, d3_.id AS id_35, d3_.stock AS stock_36, d3_.create_date AS create_date_37, d3_.update_date AS update_date_38, d4_.id AS id_39, d4_.backend_name AS backend_name_40, d4_.name AS name_41, d4_.sort_no AS sort_no_42, d4_.visible AS visible_43, d4_.create_date AS create_date_44, d4_.update_date AS update_date_45, d5_.id AS id_46, d5_.backend_name AS backend_name_47, d5_.name AS name_48, d5_.sort_no AS sort_no_49, d5_.visible AS visible_50, d5_.create_date AS create_date_51, d5_.update_date AS update_date_52, d6_.id AS id_53, d6_.file_name AS file_name_54, d6_.sort_no AS sort_no_55, d6_.create_date AS create_date_56, d7_.id AS id_57, d7_.create_date AS create_date_58, d0_.discriminator_type AS discriminator_type_59, d0_.creator_id AS creator_id_60, d0_.product_status_id AS product_status_id_61, d0_.maker_id AS maker_id_62, d1_.discriminator_type AS discriminator_type_63, d1_.product_id AS product_id_64, d1_.sale_type_id AS sale_type_id_65, d1_.class_category_id1 AS class_category_id1_66, d1_.class_category_id2 AS class_category_id2_67, d1_.delivery_duration_id AS delivery_duration_id_68, d1_.creator_id AS creator_id_69, d2_.discriminator_type AS discriminator_type_70, d2_.product_class_id AS product_class_id_71, d2_.creator_id AS creator_id_72, d2_.country_id AS country_id_73, d2_.pref_id AS pref_id_74, d2_.product_id AS product_id_75, d2_.rounding_type_id AS rounding_type_id_76, d3_.discriminator_type AS discriminator_type_77, d3_.product_class_id AS product_class_id_78, d3_.creator_id AS creator_id_79, d4_.discriminator_type AS discriminator_type_80, d4_.class_name_id AS class_name_id_81, d4_.creator_id AS creator_id_82, d5_.discriminator_type AS discriminator_type_83, d5_.class_name_id AS class_name_id_84, d5_.creator_id AS creator_id_85, d6_.discriminator_type AS discriminator_type_86, d6_.product_id AS product_id_87, d6_.creator_id AS creator_id_88, d7_.discriminator_type AS discriminator_type_89, d7_.product_id AS product_id_90, d7_.tag_id AS tag_id_91, d7_.creator_id AS creator_id_92 FROM dtb_product d0_ INNER JOIN dtb_product_class d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productclass') LEFT JOIN dtb_tax_rule d2_ ON d1_.id = d2_.product_class_id AND d2_.discriminator_type IN ('taxrule') INNER JOIN dtb_product_stock d3_ ON d1_.id = d3_.product_class_id AND d3_.discriminator_type IN ('productstock') LEFT JOIN dtb_class_category d4_ ON d1_.class_category_id1 = d4_.id AND d4_.discriminator_type IN ('classcategory') LEFT JOIN dtb_class_category d5_ ON d1_.class_category_id2 = d5_.id AND d5_.discriminator_type IN ('classcategory') LEFT JOIN dtb_product_image d6_ ON d0_.id = d6_.product_id AND d6_.discriminator_type IN ('productimage') LEFT JOIN dtb_product_tag d7_ ON d0_.id = d7_.product_id AND d7_.discriminator_type IN ('producttag') WHERE (d0_.id IN (6972, 6971, 6970, 6969, 6968, 6967, 6966, 6965, 6964, 6963, 6962, 6961, 6960, 6959, 6958, 6957, 6956, 6955, 6954, 6953) AND d1_.visible = 1) AND d0_.discriminator_type IN ('product') ORDER BY d4_.sort_no DESC, d5_.sort_no DESC, d6_.sort_no ASC;
3.48 ms (0.69%)	1	SELECT DISTINCT d0_.id AS id_0 FROM dtb_product d0_ INNER JOIN dtb_product_category d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productcategory') WHERE (d0_.product_status_id = 1 AND d1_.category_id IN (?)) AND d0_.discriminator_type IN ('product') Parameters: [`14`] View formatted query View runnable query Explain query SELECT DISTINCT d0_.id AS id_0 FROM dtb_product d0_ INNER JOIN dtb_product_category d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productcategory') WHERE ( d0_.product_status_id = 1 AND d1_.category_id IN (?) ) AND d0_.discriminator_type IN ('product') SELECT DISTINCT d0_.id AS id_0 FROM dtb_product d0_ INNER JOIN dtb_product_category d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productcategory') WHERE (d0_.product_status_id = 1 AND d1_.category_id IN (14)) AND d0_.discriminator_type IN ('product');
2.81 ms (0.55%)	1	SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.note AS note_2, d0_.description_list AS description_list_3, d0_.description_detail AS description_detail_4, d0_.search_word AS search_word_5, d0_.free_area AS free_area_6, d0_.create_date AS create_date_7, d0_.update_date AS update_date_8, d0_.maker_prices AS maker_prices_9, d0_.option_area AS option_area_10, d0_.option_item_area AS option_item_area_11, d0_.recommend_point AS recommend_point_12, d0_.sales_infomation AS sales_infomation_13, d0_.list_spec AS list_spec_14, d0_.maker_url AS maker_url_15, d0_.discriminator_type AS discriminator_type_16, d0_.creator_id AS creator_id_17, d0_.product_status_id AS product_status_id_18, d0_.maker_id AS maker_id_19 FROM dtb_product d0_ INNER JOIN dtb_product_category d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productcategory') INNER JOIN dtb_category d2_ ON d1_.category_id = d2_.id AND d2_.discriminator_type IN ('category') LEFT JOIN plg_sort_product p3_ ON (d0_.id = p3_.id) AND p3_.discriminator_type IN ('sortproduct') WHERE (d0_.product_status_id = 1 AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d1_.category_id IN (?) AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND d0_.discriminator_type IN ('product') ORDER BY p3_.sort_no DESC Parameters: [6910 3222 3225 3136 3262 3195 3330 3194 3113 3146 3150 3131 3533 3068 3190 3103 3076 3107 3142 3199 3400 3397 6514 3140 3441 1035 3561 3564 3166 3088 3419 3666 3660 3521 3484 3244 3250 3201 3675 3677 3707 3709 3670 3642 3646 3657 3648 3655 3659 3651 3652 3215 3429 3430 3433 3458 3460 3465 3481 3540 3571 3160 3574 3266 3268 3271 3274 3275 3281 3220 3664 6510 3206 3449 3436 3208 3291 3288 3451 3541 3547 3551 3559 3557 3554 3232 3311 3335 3339 3387 3523 3512 3322 3306 3308 3470 3691 3692 3377 3360 3124 3629 3133 3134 3138 3139 3172 3174 3175 3176 3179 3180 3197 3198 3221 3231 3265 3295 3313 3314 3342 3343 3344 3345 3346 3347 3348 3349 3350 3351 3383 3384 3403 3404 3405 3406 3428 3440 3466 3467 3483 3488 3489 3490 3491 3509 3510 3550 3570 3581 3582 3583 3584 3585 3586 3587 3588 3589 3590 3591 3592 3593 3594 3595 3596 3603 3604 3640 3641 3645 3647 3656 3665 3674 3711 6498 6892 6893 6894 6898 6899 6900 6901 6902 6903 6904 6905 6906 6919 6920 6921 6922 6923 6924 6925 6926 6927 6928 6929 6930 6931 6932 6933 6934 6935 6936 6937 6938 6939 6940 6941 6942 6943 6944 6945 6946 6947 6948 6949 6950 6951 6952 6953 6954 6955 6956 6957 6958 6959 6960 6961 6962 6963 6964 6965 6966 6967 6968 6969 6970 6971 6972 7690 7691 7692 7693 7694 7695 7696 7697 7698 7699 7700 7701 7702 7703 7704 7705 7706 7707 7708 7709 7710 7711 7712 7713 7714 7715 7716 7717 7718 14 6972 6971 6970 6969 6968 6967 6966 6965 6964 6963 6962 6961 6960 6959 6958 6957 6956 6955 6954 6953] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.note AS note_2, d0_.description_list AS description_list_3, d0_.description_detail AS description_detail_4, d0_.search_word AS search_word_5, d0_.free_area AS free_area_6, d0_.create_date AS create_date_7, d0_.update_date AS update_date_8, d0_.maker_prices AS maker_prices_9, d0_.option_area AS option_area_10, d0_.option_item_area AS option_item_area_11, d0_.recommend_point AS recommend_point_12, d0_.sales_infomation AS sales_infomation_13, d0_.list_spec AS list_spec_14, d0_.maker_url AS maker_url_15, d0_.discriminator_type AS discriminator_type_16, d0_.creator_id AS creator_id_17, d0_.product_status_id AS product_status_id_18, d0_.maker_id AS maker_id_19 FROM dtb_product d0_ INNER JOIN dtb_product_category d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productcategory') INNER JOIN dtb_category d2_ ON d1_.category_id = d2_.id AND d2_.discriminator_type IN ('category') LEFT JOIN plg_sort_product p3_ ON (d0_.id = p3_.id) AND p3_.discriminator_type IN ('sortproduct') WHERE ( d0_.product_status_id = 1 AND d0_.id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND d1_.category_id IN (?) AND d0_.id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ) AND d0_.discriminator_type IN ('product') ORDER BY p3_.sort_no DESC SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.note AS note_2, d0_.description_list AS description_list_3, d0_.description_detail AS description_detail_4, d0_.search_word AS search_word_5, d0_.free_area AS free_area_6, d0_.create_date AS create_date_7, d0_.update_date AS update_date_8, d0_.maker_prices AS maker_prices_9, d0_.option_area AS option_area_10, d0_.option_item_area AS option_item_area_11, d0_.recommend_point AS recommend_point_12, d0_.sales_infomation AS sales_infomation_13, d0_.list_spec AS list_spec_14, d0_.maker_url AS maker_url_15, d0_.discriminator_type AS discriminator_type_16, d0_.creator_id AS creator_id_17, d0_.product_status_id AS product_status_id_18, d0_.maker_id AS maker_id_19 FROM dtb_product d0_ INNER JOIN dtb_product_category d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productcategory') INNER JOIN dtb_category d2_ ON d1_.category_id = d2_.id AND d2_.discriminator_type IN ('category') LEFT JOIN plg_sort_product p3_ ON (d0_.id = p3_.id) AND p3_.discriminator_type IN ('sortproduct') WHERE (d0_.product_status_id = 1 AND d0_.id IN (6910, 3222, 3225, 3136, 3262, 3195, 3330, 3194, 3113, 3146, 3150, 3131, 3533, 3068, 3190, 3103, 3076, 3107, 3142, 3199, 3400, 3397, 6514, 3140, 3441, 1035, 3561, 3564, 3166, 3088, 3419, 3666, 3660, 3521, 3484, 3244, 3250, 3201, 3675, 3677, 3707, 3709, 3670, 3642, 3646, 3657, 3648, 3655, 3659, 3651, 3652, 3215, 3429, 3430, 3433, 3458, 3460, 3465, 3481, 3540, 3571, 3160, 3574, 3266, 3268, 3271, 3274, 3275, 3281, 3220, 3664, 6510, 3206, 3449, 3436, 3208, 3291, 3288, 3451, 3541, 3547, 3551, 3559, 3557, 3554, 3232, 3311, 3335, 3339, 3387, 3523, 3512, 3322, 3306, 3308, 3470, 3691, 3692, 3377, 3360, 3124, 3629, 3133, 3134, 3138, 3139, 3172, 3174, 3175, 3176, 3179, 3180, 3197, 3198, 3221, 3231, 3265, 3295, 3313, 3314, 3342, 3343, 3344, 3345, 3346, 3347, 3348, 3349, 3350, 3351, 3383, 3384, 3403, 3404, 3405, 3406, 3428, 3440, 3466, 3467, 3483, 3488, 3489, 3490, 3491, 3509, 3510, 3550, 3570, 3581, 3582, 3583, 3584, 3585, 3586, 3587, 3588, 3589, 3590, 3591, 3592, 3593, 3594, 3595, 3596, 3603, 3604, 3640, 3641, 3645, 3647, 3656, 3665, 3674, 3711, 6498, 6892, 6893, 6894, 6898, 6899, 6900, 6901, 6902, 6903, 6904, 6905, 6906, 6919, 6920, 6921, 6922, 6923, 6924, 6925, 6926, 6927, 6928, 6929, 6930, 6931, 6932, 6933, 6934, 6935, 6936, 6937, 6938, 6939, 6940, 6941, 6942, 6943, 6944, 6945, 6946, 6947, 6948, 6949, 6950, 6951, 6952, 6953, 6954, 6955, 6956, 6957, 6958, 6959, 6960, 6961, 6962, 6963, 6964, 6965, 6966, 6967, 6968, 6969, 6970, 6971, 6972, 7690, 7691, 7692, 7693, 7694, 7695, 7696, 7697, 7698, 7699, 7700, 7701, 7702, 7703, 7704, 7705, 7706, 7707, 7708, 7709, 7710, 7711, 7712, 7713, 7714, 7715, 7716, 7717, 7718) AND d1_.category_id IN (14) AND d0_.id IN (6972, 6971, 6970, 6969, 6968, 6967, 6966, 6965, 6964, 6963, 6962, 6961, 6960, 6959, 6958, 6957, 6956, 6955, 6954, 6953)) AND d0_.discriminator_type IN ('product') ORDER BY p3_.sort_no DESC;
2.80 ms (0.55%)	1	SELECT d0_.product_id AS sclr_0, MIN(d0_.price02) AS sclr_1 FROM dtb_product_class d0_ WHERE (d0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d0_.visible = 1) AND d0_.discriminator_type IN ('productclass') GROUP BY d0_.product_id Parameters: [3205 3204 3171 3170 3169 3222 3224 3223 3225 3230 3229 3228 3227 3226 3136 3137 3093 3262 3263 3195 3310 3331 3332 3330 3386 3385 3194 3113 3114 3115 3145 3480 3146 3155 3154 3152 3151 3150 3132 3131 3531 3536 3535 3534 3533 3532 3158 3157 3156 3067 3185 3068 3186 3190 3192 3191 3193 3101 3103 3100 3099 3501 3500 3499 3498 3102 3497 3496 3495 3494 3493 3492 3077 3075 3073 3078 3074 3076 3105 3111 3110 3109 3064 3063 3062 3043 3042 3039 3038 3058 3057 3047 3046 3052 3189 3051 3506 3505 3504 3503 3502 3112 3188 3070 3069 3187 3045 3044 3183 3066 3065 3184 3041 3040 3037 3036 3056 3055 3104 3108 3508 3507 3107 3106 3050 3049 3048 3061 3060 3059 3054 3053 3072 3071 3153 3143 3144 3142 3261 3260 3264 3199 3402 3401 3400 3399 3398 3397 3396 6514 6513 6512 3435 3140 3434 3141 3443 3442 3441 3444 1035 3447 3446 3445 3196 3561 3562 3564 3563 3569 3568 3167 3166 3165 3567 3164 3163 3566 3565 6499 3029 6506 6515 3081 3088 6516 6501 3035 6518 6517 3086 6520 6519 3089 6521 3082 6523 6522 3083 3080 3079 3030 6758 3031 3032 3408 3407 3034 6524 6500 3033 3421 3420 3419 3418 3417 3416 3415 3414 3149 3413 3148 3412 3411 3178 3410 3177 3409 3085 3084 6507 6525 3090 3200 6526 6527 3092 3091 3147 3422 3423 3424 3425 3426 3427 3135 3129 3127 3128 3130 3087 3667 3666 3662 3661 3660 3521 3522 3484 3485 3486 3487 3244 3245 3246 3247 3249 3248 3251 3250 3253 3252 3255 3254 3257 3256 3258 3259 3201 3202 3203 3675 3676 3677 3678 3707 3708 3709 3710 3672 3673 3668 3669 3670 3671 3642 3643 3644 3646 3657 3648 3649 3650 3655 3659 3651 3652 3653 3654 3658 3213 3214 3215 3216 3429 3430 3431 3432 3433 3458 3459 3457 3462 3461 3460 3464 3465 3463 3481 3482 3537 3538 3539 3540 3571 3572 3160 3573 3574 3161 3162 3575 3576 3578 3579 3580 3159 3577 3266 3267 3268 3270 3269 3272 3271 3274 3276 3277 3275 3273 3278 3281 3280 3279 3219 3218 3217 3220 3664 3663 6510 6511 3207 3206 3449 3450 3448 3438 3437 3436 3439 3212 3211 3210 3209 3208 3294 3293 3292 3291 3290 3289 3288 3287 3286 3285 3284 3283 3282 3453 3452 3451 3456 3455 3454 3546 3545 3544 3543 3542 3541 3549 3548 3547 3552 3551 3560 3559 3558 3557 3555 3553 3556 3554 3243 3242 3241 3240 3239 3238 3237 3236 3235 3234 3233 3232 3311 3312 3333 3334 3335 3336 3337 3338 3339 3340 3341 3387 3388 3389 3390 3391 3392 3393 3394 3395 3523 3524 3525 3526 3527 3528 3529 3530 3511 3512 3513 3514 3515 3516 3517 3518 3519 3520 3315 3316 3317 3318 3319 3320 3321 3322 3323 3324 3325 3326 3327 3328 3329 3296 3297 3298 3299 3300 3308 3306 3309 3307 3305 3304 3303 3302 3301 3478 3477 3474 3472 3470 3476 3468 3469 3471 3473 3475 3479 3683 3686 3684 3685 3679 3682 3680 3681 3687 3688 3689 3690 3695 3698 3696 3693 3692 3694 3691 3697 3703 3706 3704 3705 3699 3702 3700 3701 3371 3372 3373 3374 3375 3376 3377 3378 3379 3380 3381 3382 3367 3366 3365 3370 3369 3368 3364 3362 3361 3360 3359 3363 3352 3353 3354 3355 3356 3357 3358 3597 6528 3098 6505 6503 3095 6529 3124 6530 6531 3599 3598 3097 6508 6504 3096 6502 3602 3601 3600 3168 6509 3173 3094 3116 3605 3606 3117 3607 3181 3619 3620 3182 3610 3119 3609 3608 3118 3120 3611 3612 3121 3613 3614 3122 3615 3616 3617 3123 3618 3125 3621 3622 3623 3624 3626 3625 3628 3627 3629 3631 3630 3632 3633 3637 3636 3635 3634 3126 3638 3639 6918 6917 6916 6915 6914 6913 6912 6911 6910 6909 6908 6907 6897 6896 6895] View formatted query View runnable query Explain query SELECT d0_.product_id AS sclr_0, MIN(d0_.price02) AS sclr_1 FROM dtb_product_class d0_ WHERE ( d0_.product_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND d0_.visible = 1 ) AND d0_.discriminator_type IN ('productclass') GROUP BY d0_.product_id SELECT d0_.product_id AS sclr_0, MIN(d0_.price02) AS sclr_1 FROM dtb_product_class d0_ WHERE (d0_.product_id IN (3205, 3204, 3171, 3170, 3169, 3222, 3224, 3223, 3225, 3230, 3229, 3228, 3227, 3226, 3136, 3137, 3093, 3262, 3263, 3195, 3310, 3331, 3332, 3330, 3386, 3385, 3194, 3113, 3114, 3115, 3145, 3480, 3146, 3155, 3154, 3152, 3151, 3150, 3132, 3131, 3531, 3536, 3535, 3534, 3533, 3532, 3158, 3157, 3156, 3067, 3185, 3068, 3186, 3190, 3192, 3191, 3193, 3101, 3103, 3100, 3099, 3501, 3500, 3499, 3498, 3102, 3497, 3496, 3495, 3494, 3493, 3492, 3077, 3075, 3073, 3078, 3074, 3076, 3105, 3111, 3110, 3109, 3064, 3063, 3062, 3043, 3042, 3039, 3038, 3058, 3057, 3047, 3046, 3052, 3189, 3051, 3506, 3505, 3504, 3503, 3502, 3112, 3188, 3070, 3069, 3187, 3045, 3044, 3183, 3066, 3065, 3184, 3041, 3040, 3037, 3036, 3056, 3055, 3104, 3108, 3508, 3507, 3107, 3106, 3050, 3049, 3048, 3061, 3060, 3059, 3054, 3053, 3072, 3071, 3153, 3143, 3144, 3142, 3261, 3260, 3264, 3199, 3402, 3401, 3400, 3399, 3398, 3397, 3396, 6514, 6513, 6512, 3435, 3140, 3434, 3141, 3443, 3442, 3441, 3444, 1035, 3447, 3446, 3445, 3196, 3561, 3562, 3564, 3563, 3569, 3568, 3167, 3166, 3165, 3567, 3164, 3163, 3566, 3565, 6499, 3029, 6506, 6515, 3081, 3088, 6516, 6501, 3035, 6518, 6517, 3086, 6520, 6519, 3089, 6521, 3082, 6523, 6522, 3083, 3080, 3079, 3030, 6758, 3031, 3032, 3408, 3407, 3034, 6524, 6500, 3033, 3421, 3420, 3419, 3418, 3417, 3416, 3415, 3414, 3149, 3413, 3148, 3412, 3411, 3178, 3410, 3177, 3409, 3085, 3084, 6507, 6525, 3090, 3200, 6526, 6527, 3092, 3091, 3147, 3422, 3423, 3424, 3425, 3426, 3427, 3135, 3129, 3127, 3128, 3130, 3087, 3667, 3666, 3662, 3661, 3660, 3521, 3522, 3484, 3485, 3486, 3487, 3244, 3245, 3246, 3247, 3249, 3248, 3251, 3250, 3253, 3252, 3255, 3254, 3257, 3256, 3258, 3259, 3201, 3202, 3203, 3675, 3676, 3677, 3678, 3707, 3708, 3709, 3710, 3672, 3673, 3668, 3669, 3670, 3671, 3642, 3643, 3644, 3646, 3657, 3648, 3649, 3650, 3655, 3659, 3651, 3652, 3653, 3654, 3658, 3213, 3214, 3215, 3216, 3429, 3430, 3431, 3432, 3433, 3458, 3459, 3457, 3462, 3461, 3460, 3464, 3465, 3463, 3481, 3482, 3537, 3538, 3539, 3540, 3571, 3572, 3160, 3573, 3574, 3161, 3162, 3575, 3576, 3578, 3579, 3580, 3159, 3577, 3266, 3267, 3268, 3270, 3269, 3272, 3271, 3274, 3276, 3277, 3275, 3273, 3278, 3281, 3280, 3279, 3219, 3218, 3217, 3220, 3664, 3663, 6510, 6511, 3207, 3206, 3449, 3450, 3448, 3438, 3437, 3436, 3439, 3212, 3211, 3210, 3209, 3208, 3294, 3293, 3292, 3291, 3290, 3289, 3288, 3287, 3286, 3285, 3284, 3283, 3282, 3453, 3452, 3451, 3456, 3455, 3454, 3546, 3545, 3544, 3543, 3542, 3541, 3549, 3548, 3547, 3552, 3551, 3560, 3559, 3558, 3557, 3555, 3553, 3556, 3554, 3243, 3242, 3241, 3240, 3239, 3238, 3237, 3236, 3235, 3234, 3233, 3232, 3311, 3312, 3333, 3334, 3335, 3336, 3337, 3338, 3339, 3340, 3341, 3387, 3388, 3389, 3390, 3391, 3392, 3393, 3394, 3395, 3523, 3524, 3525, 3526, 3527, 3528, 3529, 3530, 3511, 3512, 3513, 3514, 3515, 3516, 3517, 3518, 3519, 3520, 3315, 3316, 3317, 3318, 3319, 3320, 3321, 3322, 3323, 3324, 3325, 3326, 3327, 3328, 3329, 3296, 3297, 3298, 3299, 3300, 3308, 3306, 3309, 3307, 3305, 3304, 3303, 3302, 3301, 3478, 3477, 3474, 3472, 3470, 3476, 3468, 3469, 3471, 3473, 3475, 3479, 3683, 3686, 3684, 3685, 3679, 3682, 3680, 3681, 3687, 3688, 3689, 3690, 3695, 3698, 3696, 3693, 3692, 3694, 3691, 3697, 3703, 3706, 3704, 3705, 3699, 3702, 3700, 3701, 3371, 3372, 3373, 3374, 3375, 3376, 3377, 3378, 3379, 3380, 3381, 3382, 3367, 3366, 3365, 3370, 3369, 3368, 3364, 3362, 3361, 3360, 3359, 3363, 3352, 3353, 3354, 3355, 3356, 3357, 3358, 3597, 6528, 3098, 6505, 6503, 3095, 6529, 3124, 6530, 6531, 3599, 3598, 3097, 6508, 6504, 3096, 6502, 3602, 3601, 3600, 3168, 6509, 3173, 3094, 3116, 3605, 3606, 3117, 3607, 3181, 3619, 3620, 3182, 3610, 3119, 3609, 3608, 3118, 3120, 3611, 3612, 3121, 3613, 3614, 3122, 3615, 3616, 3617, 3123, 3618, 3125, 3621, 3622, 3623, 3624, 3626, 3625, 3628, 3627, 3629, 3631, 3630, 3632, 3633, 3637, 3636, 3635, 3634, 3126, 3638, 3639, 6918, 6917, 6916, 6915, 6914, 6913, 6912, 6911, 6910, 6909, 6908, 6907, 6897, 6896, 6895) AND d0_.visible = 1) AND d0_.discriminator_type IN ('productclass') GROUP BY d0_.product_id;
2.36 ms (0.46%)	1	SELECT count(DISTINCT d0_.id) AS sclr_0 FROM dtb_product d0_ INNER JOIN dtb_product_category d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productcategory') INNER JOIN dtb_category d2_ ON d1_.category_id = d2_.id AND d2_.discriminator_type IN ('category') LEFT JOIN plg_sort_product p3_ ON (d0_.id = p3_.id) AND p3_.discriminator_type IN ('sortproduct') WHERE (d0_.product_status_id = 1 AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d1_.category_id IN (?)) AND d0_.discriminator_type IN ('product') Parameters: [6910 3222 3225 3136 3262 3195 3330 3194 3113 3146 3150 3131 3533 3068 3190 3103 3076 3107 3142 3199 3400 3397 6514 3140 3441 1035 3561 3564 3166 3088 3419 3666 3660 3521 3484 3244 3250 3201 3675 3677 3707 3709 3670 3642 3646 3657 3648 3655 3659 3651 3652 3215 3429 3430 3433 3458 3460 3465 3481 3540 3571 3160 3574 3266 3268 3271 3274 3275 3281 3220 3664 6510 3206 3449 3436 3208 3291 3288 3451 3541 3547 3551 3559 3557 3554 3232 3311 3335 3339 3387 3523 3512 3322 3306 3308 3470 3691 3692 3377 3360 3124 3629 3133 3134 3138 3139 3172 3174 3175 3176 3179 3180 3197 3198 3221 3231 3265 3295 3313 3314 3342 3343 3344 3345 3346 3347 3348 3349 3350 3351 3383 3384 3403 3404 3405 3406 3428 3440 3466 3467 3483 3488 3489 3490 3491 3509 3510 3550 3570 3581 3582 3583 3584 3585 3586 3587 3588 3589 3590 3591 3592 3593 3594 3595 3596 3603 3604 3640 3641 3645 3647 3656 3665 3674 3711 6498 6892 6893 6894 6898 6899 6900 6901 6902 6903 6904 6905 6906 6919 6920 6921 6922 6923 6924 6925 6926 6927 6928 6929 6930 6931 6932 6933 6934 6935 6936 6937 6938 6939 6940 6941 6942 6943 6944 6945 6946 6947 6948 6949 6950 6951 6952 6953 6954 6955 6956 6957 6958 6959 6960 6961 6962 6963 6964 6965 6966 6967 6968 6969 6970 6971 6972 7690 7691 7692 7693 7694 7695 7696 7697 7698 7699 7700 7701 7702 7703 7704 7705 7706 7707 7708 7709 7710 7711 7712 7713 7714 7715 7716 7717 7718 14] View formatted query View runnable query Explain query SELECT count(DISTINCT d0_.id) AS sclr_0 FROM dtb_product d0_ INNER JOIN dtb_product_category d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productcategory') INNER JOIN dtb_category d2_ ON d1_.category_id = d2_.id AND d2_.discriminator_type IN ('category') LEFT JOIN plg_sort_product p3_ ON (d0_.id = p3_.id) AND p3_.discriminator_type IN ('sortproduct') WHERE ( d0_.product_status_id = 1 AND d0_.id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND d1_.category_id IN (?) ) AND d0_.discriminator_type IN ('product') SELECT count(DISTINCT d0_.id) AS sclr_0 FROM dtb_product d0_ INNER JOIN dtb_product_category d1_ ON d0_.id = d1_.product_id AND d1_.discriminator_type IN ('productcategory') INNER JOIN dtb_category d2_ ON d1_.category_id = d2_.id AND d2_.discriminator_type IN ('category') LEFT JOIN plg_sort_product p3_ ON (d0_.id = p3_.id) AND p3_.discriminator_type IN ('sortproduct') WHERE (d0_.product_status_id = 1 AND d0_.id IN (6910, 3222, 3225, 3136, 3262, 3195, 3330, 3194, 3113, 3146, 3150, 3131, 3533, 3068, 3190, 3103, 3076, 3107, 3142, 3199, 3400, 3397, 6514, 3140, 3441, 1035, 3561, 3564, 3166, 3088, 3419, 3666, 3660, 3521, 3484, 3244, 3250, 3201, 3675, 3677, 3707, 3709, 3670, 3642, 3646, 3657, 3648, 3655, 3659, 3651, 3652, 3215, 3429, 3430, 3433, 3458, 3460, 3465, 3481, 3540, 3571, 3160, 3574, 3266, 3268, 3271, 3274, 3275, 3281, 3220, 3664, 6510, 3206, 3449, 3436, 3208, 3291, 3288, 3451, 3541, 3547, 3551, 3559, 3557, 3554, 3232, 3311, 3335, 3339, 3387, 3523, 3512, 3322, 3306, 3308, 3470, 3691, 3692, 3377, 3360, 3124, 3629, 3133, 3134, 3138, 3139, 3172, 3174, 3175, 3176, 3179, 3180, 3197, 3198, 3221, 3231, 3265, 3295, 3313, 3314, 3342, 3343, 3344, 3345, 3346, 3347, 3348, 3349, 3350, 3351, 3383, 3384, 3403, 3404, 3405, 3406, 3428, 3440, 3466, 3467, 3483, 3488, 3489, 3490, 3491, 3509, 3510, 3550, 3570, 3581, 3582, 3583, 3584, 3585, 3586, 3587, 3588, 3589, 3590, 3591, 3592, 3593, 3594, 3595, 3596, 3603, 3604, 3640, 3641, 3645, 3647, 3656, 3665, 3674, 3711, 6498, 6892, 6893, 6894, 6898, 6899, 6900, 6901, 6902, 6903, 6904, 6905, 6906, 6919, 6920, 6921, 6922, 6923, 6924, 6925, 6926, 6927, 6928, 6929, 6930, 6931, 6932, 6933, 6934, 6935, 6936, 6937, 6938, 6939, 6940, 6941, 6942, 6943, 6944, 6945, 6946, 6947, 6948, 6949, 6950, 6951, 6952, 6953, 6954, 6955, 6956, 6957, 6958, 6959, 6960, 6961, 6962, 6963, 6964, 6965, 6966, 6967, 6968, 6969, 6970, 6971, 6972, 7690, 7691, 7692, 7693, 7694, 7695, 7696, 7697, 7698, 7699, 7700, 7701, 7702, 7703, 7704, 7705, 7706, 7707, 7708, 7709, 7710, 7711, 7712, 7713, 7714, 7715, 7716, 7717, 7718) AND d1_.category_id IN (14)) AND d0_.discriminator_type IN ('product');
2.36 ms (0.46%)	1	SELECT DISTINCT d0_.id AS id_0, p1_.sort_no AS sort_no_1 FROM dtb_product d0_ INNER JOIN dtb_product_category d2_ ON d0_.id = d2_.product_id AND d2_.discriminator_type IN ('productcategory') INNER JOIN dtb_category d3_ ON d2_.category_id = d3_.id AND d3_.discriminator_type IN ('category') LEFT JOIN plg_sort_product p1_ ON (d0_.id = p1_.id) AND p1_.discriminator_type IN ('sortproduct') WHERE (d0_.product_status_id = 1 AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND d2_.category_id IN (?)) AND d0_.discriminator_type IN ('product') ORDER BY p1_.sort_no DESC LIMIT 20 Parameters: [6910 3222 3225 3136 3262 3195 3330 3194 3113 3146 3150 3131 3533 3068 3190 3103 3076 3107 3142 3199 3400 3397 6514 3140 3441 1035 3561 3564 3166 3088 3419 3666 3660 3521 3484 3244 3250 3201 3675 3677 3707 3709 3670 3642 3646 3657 3648 3655 3659 3651 3652 3215 3429 3430 3433 3458 3460 3465 3481 3540 3571 3160 3574 3266 3268 3271 3274 3275 3281 3220 3664 6510 3206 3449 3436 3208 3291 3288 3451 3541 3547 3551 3559 3557 3554 3232 3311 3335 3339 3387 3523 3512 3322 3306 3308 3470 3691 3692 3377 3360 3124 3629 3133 3134 3138 3139 3172 3174 3175 3176 3179 3180 3197 3198 3221 3231 3265 3295 3313 3314 3342 3343 3344 3345 3346 3347 3348 3349 3350 3351 3383 3384 3403 3404 3405 3406 3428 3440 3466 3467 3483 3488 3489 3490 3491 3509 3510 3550 3570 3581 3582 3583 3584 3585 3586 3587 3588 3589 3590 3591 3592 3593 3594 3595 3596 3603 3604 3640 3641 3645 3647 3656 3665 3674 3711 6498 6892 6893 6894 6898 6899 6900 6901 6902 6903 6904 6905 6906 6919 6920 6921 6922 6923 6924 6925 6926 6927 6928 6929 6930 6931 6932 6933 6934 6935 6936 6937 6938 6939 6940 6941 6942 6943 6944 6945 6946 6947 6948 6949 6950 6951 6952 6953 6954 6955 6956 6957 6958 6959 6960 6961 6962 6963 6964 6965 6966 6967 6968 6969 6970 6971 6972 7690 7691 7692 7693 7694 7695 7696 7697 7698 7699 7700 7701 7702 7703 7704 7705 7706 7707 7708 7709 7710 7711 7712 7713 7714 7715 7716 7717 7718 14] View formatted query View runnable query Explain query SELECT DISTINCT d0_.id AS id_0, p1_.sort_no AS sort_no_1 FROM dtb_product d0_ INNER JOIN dtb_product_category d2_ ON d0_.id = d2_.product_id AND d2_.discriminator_type IN ('productcategory') INNER JOIN dtb_category d3_ ON d2_.category_id = d3_.id AND d3_.discriminator_type IN ('category') LEFT JOIN plg_sort_product p1_ ON (d0_.id = p1_.id) AND p1_.discriminator_type IN ('sortproduct') WHERE ( d0_.product_status_id = 1 AND d0_.id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) AND d2_.category_id IN (?) ) AND d0_.discriminator_type IN ('product') ORDER BY p1_.sort_no DESC LIMIT 20 SELECT DISTINCT d0_.id AS id_0, p1_.sort_no AS sort_no_1 FROM dtb_product d0_ INNER JOIN dtb_product_category d2_ ON d0_.id = d2_.product_id AND d2_.discriminator_type IN ('productcategory') INNER JOIN dtb_category d3_ ON d2_.category_id = d3_.id AND d3_.discriminator_type IN ('category') LEFT JOIN plg_sort_product p1_ ON (d0_.id = p1_.id) AND p1_.discriminator_type IN ('sortproduct') WHERE (d0_.product_status_id = 1 AND d0_.id IN (6910, 3222, 3225, 3136, 3262, 3195, 3330, 3194, 3113, 3146, 3150, 3131, 3533, 3068, 3190, 3103, 3076, 3107, 3142, 3199, 3400, 3397, 6514, 3140, 3441, 1035, 3561, 3564, 3166, 3088, 3419, 3666, 3660, 3521, 3484, 3244, 3250, 3201, 3675, 3677, 3707, 3709, 3670, 3642, 3646, 3657, 3648, 3655, 3659, 3651, 3652, 3215, 3429, 3430, 3433, 3458, 3460, 3465, 3481, 3540, 3571, 3160, 3574, 3266, 3268, 3271, 3274, 3275, 3281, 3220, 3664, 6510, 3206, 3449, 3436, 3208, 3291, 3288, 3451, 3541, 3547, 3551, 3559, 3557, 3554, 3232, 3311, 3335, 3339, 3387, 3523, 3512, 3322, 3306, 3308, 3470, 3691, 3692, 3377, 3360, 3124, 3629, 3133, 3134, 3138, 3139, 3172, 3174, 3175, 3176, 3179, 3180, 3197, 3198, 3221, 3231, 3265, 3295, 3313, 3314, 3342, 3343, 3344, 3345, 3346, 3347, 3348, 3349, 3350, 3351, 3383, 3384, 3403, 3404, 3405, 3406, 3428, 3440, 3466, 3467, 3483, 3488, 3489, 3490, 3491, 3509, 3510, 3550, 3570, 3581, 3582, 3583, 3584, 3585, 3586, 3587, 3588, 3589, 3590, 3591, 3592, 3593, 3594, 3595, 3596, 3603, 3604, 3640, 3641, 3645, 3647, 3656, 3665, 3674, 3711, 6498, 6892, 6893, 6894, 6898, 6899, 6900, 6901, 6902, 6903, 6904, 6905, 6906, 6919, 6920, 6921, 6922, 6923, 6924, 6925, 6926, 6927, 6928, 6929, 6930, 6931, 6932, 6933, 6934, 6935, 6936, 6937, 6938, 6939, 6940, 6941, 6942, 6943, 6944, 6945, 6946, 6947, 6948, 6949, 6950, 6951, 6952, 6953, 6954, 6955, 6956, 6957, 6958, 6959, 6960, 6961, 6962, 6963, 6964, 6965, 6966, 6967, 6968, 6969, 6970, 6971, 6972, 7690, 7691, 7692, 7693, 7694, 7695, 7696, 7697, 7698, 7699, 7700, 7701, 7702, 7703, 7704, 7705, 7706, 7707, 7708, 7709, 7710, 7711, 7712, 7713, 7714, 7715, 7716, 7717, 7718) AND d2_.category_id IN (14)) AND d0_.discriminator_type IN ('product') ORDER BY p1_.sort_no DESC LIMIT 20;
0.41 ms (0.08%)	1	SELECT d0_.id AS id_0, d0_.category_name AS category_name_1, d0_.hierarchy AS hierarchy_2, d0_.sort_no AS sort_no_3, d0_.create_date AS create_date_4, d0_.update_date AS update_date_5, d1_.id AS id_6, d1_.category_name AS category_name_7, d1_.hierarchy AS hierarchy_8, d1_.sort_no AS sort_no_9, d1_.create_date AS create_date_10, d1_.update_date AS update_date_11, d2_.id AS id_12, d2_.category_name AS category_name_13, d2_.hierarchy AS hierarchy_14, d2_.sort_no AS sort_no_15, d2_.create_date AS create_date_16, d2_.update_date AS update_date_17, d3_.id AS id_18, d3_.category_name AS category_name_19, d3_.hierarchy AS hierarchy_20, d3_.sort_no AS sort_no_21, d3_.create_date AS create_date_22, d3_.update_date AS update_date_23, d4_.id AS id_24, d4_.category_name AS category_name_25, d4_.hierarchy AS hierarchy_26, d4_.sort_no AS sort_no_27, d4_.create_date AS create_date_28, d4_.update_date AS update_date_29, d0_.discriminator_type AS discriminator_type_30, d0_.parent_category_id AS parent_category_id_31, d0_.creator_id AS creator_id_32, d1_.discriminator_type AS discriminator_type_33, d1_.parent_category_id AS parent_category_id_34, d1_.creator_id AS creator_id_35, d2_.discriminator_type AS discriminator_type_36, d2_.parent_category_id AS parent_category_id_37, d2_.creator_id AS creator_id_38, d3_.discriminator_type AS discriminator_type_39, d3_.parent_category_id AS parent_category_id_40, d3_.creator_id AS creator_id_41, d4_.discriminator_type AS discriminator_type_42, d4_.parent_category_id AS parent_category_id_43, d4_.creator_id AS creator_id_44 FROM dtb_category d0_ LEFT JOIN dtb_category d1_ ON d0_.id = d1_.parent_category_id AND d1_.discriminator_type IN ('category') LEFT JOIN dtb_category d2_ ON d1_.id = d2_.parent_category_id AND d2_.discriminator_type IN ('category') LEFT JOIN dtb_category d3_ ON d2_.id = d3_.parent_category_id AND d3_.discriminator_type IN ('category') LEFT JOIN dtb_category d4_ ON d3_.id = d4_.parent_category_id AND d4_.discriminator_type IN ('category') WHERE (d0_.parent_category_id IS NULL) AND d0_.discriminator_type IN ('category') ORDER BY d0_.sort_no DESC, d1_.sort_no DESC, d2_.sort_no DESC, d3_.sort_no DESC, d4_.sort_no DESC Parameters: [] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.category_name AS category_name_1, d0_.hierarchy AS hierarchy_2, d0_.sort_no AS sort_no_3, d0_.create_date AS create_date_4, d0_.update_date AS update_date_5, d1_.id AS id_6, d1_.category_name AS category_name_7, d1_.hierarchy AS hierarchy_8, d1_.sort_no AS sort_no_9, d1_.create_date AS create_date_10, d1_.update_date AS update_date_11, d2_.id AS id_12, d2_.category_name AS category_name_13, d2_.hierarchy AS hierarchy_14, d2_.sort_no AS sort_no_15, d2_.create_date AS create_date_16, d2_.update_date AS update_date_17, d3_.id AS id_18, d3_.category_name AS category_name_19, d3_.hierarchy AS hierarchy_20, d3_.sort_no AS sort_no_21, d3_.create_date AS create_date_22, d3_.update_date AS update_date_23, d4_.id AS id_24, d4_.category_name AS category_name_25, d4_.hierarchy AS hierarchy_26, d4_.sort_no AS sort_no_27, d4_.create_date AS create_date_28, d4_.update_date AS update_date_29, d0_.discriminator_type AS discriminator_type_30, d0_.parent_category_id AS parent_category_id_31, d0_.creator_id AS creator_id_32, d1_.discriminator_type AS discriminator_type_33, d1_.parent_category_id AS parent_category_id_34, d1_.creator_id AS creator_id_35, d2_.discriminator_type AS discriminator_type_36, d2_.parent_category_id AS parent_category_id_37, d2_.creator_id AS creator_id_38, d3_.discriminator_type AS discriminator_type_39, d3_.parent_category_id AS parent_category_id_40, d3_.creator_id AS creator_id_41, d4_.discriminator_type AS discriminator_type_42, d4_.parent_category_id AS parent_category_id_43, d4_.creator_id AS creator_id_44 FROM dtb_category d0_ LEFT JOIN dtb_category d1_ ON d0_.id = d1_.parent_category_id AND d1_.discriminator_type IN ('category') LEFT JOIN dtb_category d2_ ON d1_.id = d2_.parent_category_id AND d2_.discriminator_type IN ('category') LEFT JOIN dtb_category d3_ ON d2_.id = d3_.parent_category_id AND d3_.discriminator_type IN ('category') LEFT JOIN dtb_category d4_ ON d3_.id = d4_.parent_category_id AND d4_.discriminator_type IN ('category') WHERE (d0_.parent_category_id IS NULL) AND d0_.discriminator_type IN ('category') ORDER BY d0_.sort_no DESC, d1_.sort_no DESC, d2_.sort_no DESC, d3_.sort_no DESC, d4_.sort_no DESC SELECT d0_.id AS id_0, d0_.category_name AS category_name_1, d0_.hierarchy AS hierarchy_2, d0_.sort_no AS sort_no_3, d0_.create_date AS create_date_4, d0_.update_date AS update_date_5, d1_.id AS id_6, d1_.category_name AS category_name_7, d1_.hierarchy AS hierarchy_8, d1_.sort_no AS sort_no_9, d1_.create_date AS create_date_10, d1_.update_date AS update_date_11, d2_.id AS id_12, d2_.category_name AS category_name_13, d2_.hierarchy AS hierarchy_14, d2_.sort_no AS sort_no_15, d2_.create_date AS create_date_16, d2_.update_date AS update_date_17, d3_.id AS id_18, d3_.category_name AS category_name_19, d3_.hierarchy AS hierarchy_20, d3_.sort_no AS sort_no_21, d3_.create_date AS create_date_22, d3_.update_date AS update_date_23, d4_.id AS id_24, d4_.category_name AS category_name_25, d4_.hierarchy AS hierarchy_26, d4_.sort_no AS sort_no_27, d4_.create_date AS create_date_28, d4_.update_date AS update_date_29, d0_.discriminator_type AS discriminator_type_30, d0_.parent_category_id AS parent_category_id_31, d0_.creator_id AS creator_id_32, d1_.discriminator_type AS discriminator_type_33, d1_.parent_category_id AS parent_category_id_34, d1_.creator_id AS creator_id_35, d2_.discriminator_type AS discriminator_type_36, d2_.parent_category_id AS parent_category_id_37, d2_.creator_id AS creator_id_38, d3_.discriminator_type AS discriminator_type_39, d3_.parent_category_id AS parent_category_id_40, d3_.creator_id AS creator_id_41, d4_.discriminator_type AS discriminator_type_42, d4_.parent_category_id AS parent_category_id_43, d4_.creator_id AS creator_id_44 FROM dtb_category d0_ LEFT JOIN dtb_category d1_ ON d0_.id = d1_.parent_category_id AND d1_.discriminator_type IN ('category') LEFT JOIN dtb_category d2_ ON d1_.id = d2_.parent_category_id AND d2_.discriminator_type IN ('category') LEFT JOIN dtb_category d3_ ON d2_.id = d3_.parent_category_id AND d3_.discriminator_type IN ('category') LEFT JOIN dtb_category d4_ ON d3_.id = d4_.parent_category_id AND d4_.discriminator_type IN ('category') WHERE (d0_.parent_category_id IS NULL) AND d0_.discriminator_type IN ('category') ORDER BY d0_.sort_no DESC, d1_.sort_no DESC, d2_.sort_no DESC, d3_.sort_no DESC, d4_.sort_no DESC;
0.31 ms (0.06%)	1	SELECT d0_.id AS id_0, d0_.tax_rate AS tax_rate_1, d0_.tax_adjust AS tax_adjust_2, d0_.apply_date AS apply_date_3, d0_.create_date AS create_date_4, d0_.update_date AS update_date_5, d0_.discriminator_type AS discriminator_type_6, d0_.product_class_id AS product_class_id_7, d0_.creator_id AS creator_id_8, d0_.country_id AS country_id_9, d0_.pref_id AS pref_id_10, d0_.product_id AS product_id_11, d0_.rounding_type_id AS rounding_type_id_12 FROM dtb_tax_rule d0_ WHERE (d0_.apply_date < ? AND d0_.pref_id IS NULL AND d0_.country_id IS NULL AND d0_.product_id IS NULL AND d0_.product_class_id IS NULL) AND d0_.discriminator_type IN ('taxrule') ORDER BY d0_.apply_date DESC Parameters: [`"2026-05-01 23:12:08"`] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.tax_rate AS tax_rate_1, d0_.tax_adjust AS tax_adjust_2, d0_.apply_date AS apply_date_3, d0_.create_date AS create_date_4, d0_.update_date AS update_date_5, d0_.discriminator_type AS discriminator_type_6, d0_.product_class_id AS product_class_id_7, d0_.creator_id AS creator_id_8, d0_.country_id AS country_id_9, d0_.pref_id AS pref_id_10, d0_.product_id AS product_id_11, d0_.rounding_type_id AS rounding_type_id_12 FROM dtb_tax_rule d0_ WHERE ( d0_.apply_date < ? AND d0_.pref_id IS NULL AND d0_.country_id IS NULL AND d0_.product_id IS NULL AND d0_.product_class_id IS NULL ) AND d0_.discriminator_type IN ('taxrule') ORDER BY d0_.apply_date DESC SELECT d0_.id AS id_0, d0_.tax_rate AS tax_rate_1, d0_.tax_adjust AS tax_adjust_2, d0_.apply_date AS apply_date_3, d0_.create_date AS create_date_4, d0_.update_date AS update_date_5, d0_.discriminator_type AS discriminator_type_6, d0_.product_class_id AS product_class_id_7, d0_.creator_id AS creator_id_8, d0_.country_id AS country_id_9, d0_.pref_id AS pref_id_10, d0_.product_id AS product_id_11, d0_.rounding_type_id AS rounding_type_id_12 FROM dtb_tax_rule d0_ WHERE (d0_.apply_date < '2026-05-01 23:12:08' AND d0_.pref_id IS NULL AND d0_.country_id IS NULL AND d0_.product_id IS NULL AND d0_.product_class_id IS NULL) AND d0_.discriminator_type IN ('taxrule') ORDER BY d0_.apply_date DESC;
0.28 ms (0.06%)	1	SET SESSION time_zone = '+00:00' Parameters: [] View formatted query View runnable query Explain query SET SESSION time_zone = '+00:00' SET SESSION time_zone = '+00:00';
0.18 ms (0.03%)	1	SELECT t0.id AS id_1, t0.primary_color_1 AS primary_color_1_2, t0.primary_color_2 AS primary_color_2_3, t0.primary_color_3 AS primary_color_3_4, t0.json_data AS json_data_5, t0.slider_json_data AS slider_json_data_6, t0.type AS type_7, t0.key_name AS key_name_8, t0.create_date AS create_date_9, t0.update_date AS update_date_10, t0.block_id AS block_id_11 FROM plg_banner_b001_block_42 t0 WHERE t0.type = ? LIMIT 1 Parameters: [`"banner01"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.primary_color_1 AS primary_color_1_2, t0.primary_color_2 AS primary_color_2_3, t0.primary_color_3 AS primary_color_3_4, t0.json_data AS json_data_5, t0.slider_json_data AS slider_json_data_6, t0.type AS type_7, t0.key_name AS key_name_8, t0.create_date AS create_date_9, t0.update_date AS update_date_10, t0.block_id AS block_id_11 FROM plg_banner_b001_block_42 t0 WHERE t0.type = ? LIMIT 1 SELECT t0.id AS id_1, t0.primary_color_1 AS primary_color_1_2, t0.primary_color_2 AS primary_color_2_3, t0.primary_color_3 AS primary_color_3_4, t0.json_data AS json_data_5, t0.slider_json_data AS slider_json_data_6, t0.type AS type_7, t0.key_name AS key_name_8, t0.create_date AS create_date_9, t0.update_date AS update_date_10, t0.block_id AS block_id_11 FROM plg_banner_b001_block_42 t0 WHERE t0.type = 'banner01' LIMIT 1;
0.17 ms (0.03%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.create_date AS create_date_4, t0.update_date AS update_date_5 FROM plg_maker t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.create_date AS create_date_4, t0.update_date AS update_date_5 FROM plg_maker t0 SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.create_date AS create_date_4, t0.update_date AS update_date_5 FROM plg_maker t0;
0.17 ms (0.03%)	1	SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.company_kana AS company_kana_3, t0.postal_code AS postal_code_4, t0.addr01 AS addr01_5, t0.addr02 AS addr02_6, t0.phone_number AS phone_number_7, t0.business_hour AS business_hour_8, t0.email01 AS email01_9, t0.email02 AS email02_10, t0.email03 AS email03_11, t0.email04 AS email04_12, t0.shop_name AS shop_name_13, t0.shop_kana AS shop_kana_14, t0.shop_name_eng AS shop_name_eng_15, t0.update_date AS update_date_16, t0.good_traded AS good_traded_17, t0.message AS message_18, t0.delivery_free_amount AS delivery_free_amount_19, t0.delivery_free_quantity AS delivery_free_quantity_20, t0.option_mypage_order_status_display AS option_mypage_order_status_display_21, t0.option_nostock_hidden AS option_nostock_hidden_22, t0.option_favorite_product AS option_favorite_product_23, t0.option_product_delivery_fee AS option_product_delivery_fee_24, t0.invoice_registration_number AS invoice_registration_number_25, t0.option_product_tax_rule AS option_product_tax_rule_26, t0.option_customer_activate AS option_customer_activate_27, t0.option_remember_me AS option_remember_me_28, t0.option_mail_notifier AS option_mail_notifier_29, t0.authentication_key AS authentication_key_30, t0.php_path AS php_path_31, t0.option_point AS option_point_32, t0.basic_point_rate AS basic_point_rate_33, t0.point_conversion_rate AS point_conversion_rate_34, t0.country_id AS country_id_35, t0.pref_id AS pref_id_36, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = ? AND t0.discriminator_type IN ('baseinfo') Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.company_kana AS company_kana_3, t0.postal_code AS postal_code_4, t0.addr01 AS addr01_5, t0.addr02 AS addr02_6, t0.phone_number AS phone_number_7, t0.business_hour AS business_hour_8, t0.email01 AS email01_9, t0.email02 AS email02_10, t0.email03 AS email03_11, t0.email04 AS email04_12, t0.shop_name AS shop_name_13, t0.shop_kana AS shop_kana_14, t0.shop_name_eng AS shop_name_eng_15, t0.update_date AS update_date_16, t0.good_traded AS good_traded_17, t0.message AS message_18, t0.delivery_free_amount AS delivery_free_amount_19, t0.delivery_free_quantity AS delivery_free_quantity_20, t0.option_mypage_order_status_display AS option_mypage_order_status_display_21, t0.option_nostock_hidden AS option_nostock_hidden_22, t0.option_favorite_product AS option_favorite_product_23, t0.option_product_delivery_fee AS option_product_delivery_fee_24, t0.invoice_registration_number AS invoice_registration_number_25, t0.option_product_tax_rule AS option_product_tax_rule_26, t0.option_customer_activate AS option_customer_activate_27, t0.option_remember_me AS option_remember_me_28, t0.option_mail_notifier AS option_mail_notifier_29, t0.authentication_key AS authentication_key_30, t0.php_path AS php_path_31, t0.option_point AS option_point_32, t0.basic_point_rate AS basic_point_rate_33, t0.point_conversion_rate AS point_conversion_rate_34, t0.country_id AS country_id_35, t0.pref_id AS pref_id_36, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = ? AND t0.discriminator_type IN ('baseinfo') SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.company_kana AS company_kana_3, t0.postal_code AS postal_code_4, t0.addr01 AS addr01_5, t0.addr02 AS addr02_6, t0.phone_number AS phone_number_7, t0.business_hour AS business_hour_8, t0.email01 AS email01_9, t0.email02 AS email02_10, t0.email03 AS email03_11, t0.email04 AS email04_12, t0.shop_name AS shop_name_13, t0.shop_kana AS shop_kana_14, t0.shop_name_eng AS shop_name_eng_15, t0.update_date AS update_date_16, t0.good_traded AS good_traded_17, t0.message AS message_18, t0.delivery_free_amount AS delivery_free_amount_19, t0.delivery_free_quantity AS delivery_free_quantity_20, t0.option_mypage_order_status_display AS option_mypage_order_status_display_21, t0.option_nostock_hidden AS option_nostock_hidden_22, t0.option_favorite_product AS option_favorite_product_23, t0.option_product_delivery_fee AS option_product_delivery_fee_24, t0.invoice_registration_number AS invoice_registration_number_25, t0.option_product_tax_rule AS option_product_tax_rule_26, t0.option_customer_activate AS option_customer_activate_27, t0.option_remember_me AS option_remember_me_28, t0.option_mail_notifier AS option_mail_notifier_29, t0.authentication_key AS authentication_key_30, t0.php_path AS php_path_31, t0.option_point AS option_point_32, t0.basic_point_rate AS basic_point_rate_33, t0.point_conversion_rate AS point_conversion_rate_34, t0.country_id AS country_id_35, t0.pref_id AS pref_id_36, t0.discriminator_type FROM dtb_base_info t0 WHERE t0.id = 1 AND t0.discriminator_type IN ('baseinfo');
0.16 ms (0.03%)	1	SELECT d0_.id AS id_0, d0_.page_name AS page_name_1, d0_.url AS url_2, d0_.file_name AS file_name_3, d0_.edit_type AS edit_type_4, d0_.author AS author_5, d0_.description AS description_6, d0_.keyword AS keyword_7, d0_.create_date AS create_date_8, d0_.update_date AS update_date_9, d0_.meta_robots AS meta_robots_10, d0_.meta_tags AS meta_tags_11, d1_.page_id AS page_id_12, d1_.layout_id AS layout_id_13, d1_.sort_no AS sort_no_14, d2_.id AS id_15, d2_.layout_name AS layout_name_16, d2_.create_date AS create_date_17, d2_.update_date AS update_date_18, d0_.discriminator_type AS discriminator_type_19, d0_.master_page_id AS master_page_id_20, d1_.discriminator_type AS discriminator_type_21, d1_.page_id AS page_id_22, d1_.layout_id AS layout_id_23, d2_.discriminator_type AS discriminator_type_24, d2_.device_type_id AS device_type_id_25 FROM dtb_page d0_ LEFT JOIN dtb_page_layout d1_ ON d0_.id = d1_.page_id AND d1_.discriminator_type IN ('pagelayout') LEFT JOIN dtb_layout d2_ ON d1_.layout_id = d2_.id AND d2_.discriminator_type IN ('layout') WHERE (d0_.url = ?) AND d0_.discriminator_type IN ('page') Parameters: [`"product_list"`] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.page_name AS page_name_1, d0_.url AS url_2, d0_.file_name AS file_name_3, d0_.edit_type AS edit_type_4, d0_.author AS author_5, d0_.description AS description_6, d0_.keyword AS keyword_7, d0_.create_date AS create_date_8, d0_.update_date AS update_date_9, d0_.meta_robots AS meta_robots_10, d0_.meta_tags AS meta_tags_11, d1_.page_id AS page_id_12, d1_.layout_id AS layout_id_13, d1_.sort_no AS sort_no_14, d2_.id AS id_15, d2_.layout_name AS layout_name_16, d2_.create_date AS create_date_17, d2_.update_date AS update_date_18, d0_.discriminator_type AS discriminator_type_19, d0_.master_page_id AS master_page_id_20, d1_.discriminator_type AS discriminator_type_21, d1_.page_id AS page_id_22, d1_.layout_id AS layout_id_23, d2_.discriminator_type AS discriminator_type_24, d2_.device_type_id AS device_type_id_25 FROM dtb_page d0_ LEFT JOIN dtb_page_layout d1_ ON d0_.id = d1_.page_id AND d1_.discriminator_type IN ('pagelayout') LEFT JOIN dtb_layout d2_ ON d1_.layout_id = d2_.id AND d2_.discriminator_type IN ('layout') WHERE (d0_.url = ?) AND d0_.discriminator_type IN ('page') SELECT d0_.id AS id_0, d0_.page_name AS page_name_1, d0_.url AS url_2, d0_.file_name AS file_name_3, d0_.edit_type AS edit_type_4, d0_.author AS author_5, d0_.description AS description_6, d0_.keyword AS keyword_7, d0_.create_date AS create_date_8, d0_.update_date AS update_date_9, d0_.meta_robots AS meta_robots_10, d0_.meta_tags AS meta_tags_11, d1_.page_id AS page_id_12, d1_.layout_id AS layout_id_13, d1_.sort_no AS sort_no_14, d2_.id AS id_15, d2_.layout_name AS layout_name_16, d2_.create_date AS create_date_17, d2_.update_date AS update_date_18, d0_.discriminator_type AS discriminator_type_19, d0_.master_page_id AS master_page_id_20, d1_.discriminator_type AS discriminator_type_21, d1_.page_id AS page_id_22, d1_.layout_id AS layout_id_23, d2_.discriminator_type AS discriminator_type_24, d2_.device_type_id AS device_type_id_25 FROM dtb_page d0_ LEFT JOIN dtb_page_layout d1_ ON d0_.id = d1_.page_id AND d1_.discriminator_type IN ('pagelayout') LEFT JOIN dtb_layout d2_ ON d1_.layout_id = d2_.id AND d2_.discriminator_type IN ('layout') WHERE (d0_.url = 'product_list') AND d0_.discriminator_type IN ('page');
0.15 ms (0.03%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.show_product_list_flg AS show_product_list_flg_4, t0.text_color AS text_color_5, t0.background_color AS background_color_6, t0.border_color AS border_color_7, t0.discriminator_type FROM dtb_tag t0 WHERE t0.show_product_list_flg = ? AND t0.discriminator_type IN ('tag') Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.show_product_list_flg AS show_product_list_flg_4, t0.text_color AS text_color_5, t0.background_color AS background_color_6, t0.border_color AS border_color_7, t0.discriminator_type FROM dtb_tag t0 WHERE t0.show_product_list_flg = ? AND t0.discriminator_type IN ('tag') SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.show_product_list_flg AS show_product_list_flg_4, t0.text_color AS text_color_5, t0.background_color AS background_color_6, t0.border_color AS border_color_7, t0.discriminator_type FROM dtb_tag t0 WHERE t0.show_product_list_flg = 1 AND t0.discriminator_type IN ('tag');
0.15 ms (0.03%)	1	SELECT d0_.id AS id_0, d0_.layout_name AS layout_name_1, d0_.create_date AS create_date_2, d0_.update_date AS update_date_3, d1_.section AS section_4, d1_.block_id AS block_id_5, d1_.layout_id AS layout_id_6, d1_.block_row AS block_row_7, d2_.id AS id_8, d2_.block_name AS block_name_9, d2_.file_name AS file_name_10, d2_.use_controller AS use_controller_11, d2_.deletable AS deletable_12, d2_.create_date AS create_date_13, d2_.update_date AS update_date_14, d0_.discriminator_type AS discriminator_type_15, d0_.device_type_id AS device_type_id_16, d1_.discriminator_type AS discriminator_type_17, d1_.block_id AS block_id_18, d1_.layout_id AS layout_id_19, d2_.discriminator_type AS discriminator_type_20, d2_.device_type_id AS device_type_id_21 FROM dtb_layout d0_ LEFT JOIN dtb_block_position d1_ ON d0_.id = d1_.layout_id AND d1_.discriminator_type IN ('blockposition') LEFT JOIN dtb_block d2_ ON d1_.block_id = d2_.id AND d2_.discriminator_type IN ('block') WHERE (d0_.id = ?) AND d0_.discriminator_type IN ('layout') ORDER BY d1_.block_row ASC Parameters: [`2`] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.layout_name AS layout_name_1, d0_.create_date AS create_date_2, d0_.update_date AS update_date_3, d1_.section AS section_4, d1_.block_id AS block_id_5, d1_.layout_id AS layout_id_6, d1_.block_row AS block_row_7, d2_.id AS id_8, d2_.block_name AS block_name_9, d2_.file_name AS file_name_10, d2_.use_controller AS use_controller_11, d2_.deletable AS deletable_12, d2_.create_date AS create_date_13, d2_.update_date AS update_date_14, d0_.discriminator_type AS discriminator_type_15, d0_.device_type_id AS device_type_id_16, d1_.discriminator_type AS discriminator_type_17, d1_.block_id AS block_id_18, d1_.layout_id AS layout_id_19, d2_.discriminator_type AS discriminator_type_20, d2_.device_type_id AS device_type_id_21 FROM dtb_layout d0_ LEFT JOIN dtb_block_position d1_ ON d0_.id = d1_.layout_id AND d1_.discriminator_type IN ('blockposition') LEFT JOIN dtb_block d2_ ON d1_.block_id = d2_.id AND d2_.discriminator_type IN ('block') WHERE (d0_.id = ?) AND d0_.discriminator_type IN ('layout') ORDER BY d1_.block_row ASC SELECT d0_.id AS id_0, d0_.layout_name AS layout_name_1, d0_.create_date AS create_date_2, d0_.update_date AS update_date_3, d1_.section AS section_4, d1_.block_id AS block_id_5, d1_.layout_id AS layout_id_6, d1_.block_row AS block_row_7, d2_.id AS id_8, d2_.block_name AS block_name_9, d2_.file_name AS file_name_10, d2_.use_controller AS use_controller_11, d2_.deletable AS deletable_12, d2_.create_date AS create_date_13, d2_.update_date AS update_date_14, d0_.discriminator_type AS discriminator_type_15, d0_.device_type_id AS device_type_id_16, d1_.discriminator_type AS discriminator_type_17, d1_.block_id AS block_id_18, d1_.layout_id AS layout_id_19, d2_.discriminator_type AS discriminator_type_20, d2_.device_type_id AS device_type_id_21 FROM dtb_layout d0_ LEFT JOIN dtb_block_position d1_ ON d0_.id = d1_.layout_id AND d1_.discriminator_type IN ('blockposition') LEFT JOIN dtb_block d2_ ON d1_.block_id = d2_.id AND d2_.discriminator_type IN ('block') WHERE (d0_.id = 2) AND d0_.discriminator_type IN ('layout') ORDER BY d1_.block_row ASC;
0.12 ms (0.02%)	1	SELECT t0.id AS id_1, t0.primary_color_1 AS primary_color_1_2, t0.primary_color_2 AS primary_color_2_3, t0.primary_color_3 AS primary_color_3_4, t0.primary_color_4 AS primary_color_4_5, t0.title AS title_6, t0.description AS description_7, t0.image AS image_8, t0.json_data AS json_data_9, t0.type AS type_10, t0.key_name AS key_name_11, t0.create_date AS create_date_12, t0.update_date AS update_date_13, t0.block_id AS block_id_14 FROM plg_faq_f001_block_42 t0 WHERE t0.type = ? LIMIT 1 Parameters: [`"faq01"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.primary_color_1 AS primary_color_1_2, t0.primary_color_2 AS primary_color_2_3, t0.primary_color_3 AS primary_color_3_4, t0.primary_color_4 AS primary_color_4_5, t0.title AS title_6, t0.description AS description_7, t0.image AS image_8, t0.json_data AS json_data_9, t0.type AS type_10, t0.key_name AS key_name_11, t0.create_date AS create_date_12, t0.update_date AS update_date_13, t0.block_id AS block_id_14 FROM plg_faq_f001_block_42 t0 WHERE t0.type = ? LIMIT 1 SELECT t0.id AS id_1, t0.primary_color_1 AS primary_color_1_2, t0.primary_color_2 AS primary_color_2_3, t0.primary_color_3 AS primary_color_3_4, t0.primary_color_4 AS primary_color_4_5, t0.title AS title_6, t0.description AS description_7, t0.image AS image_8, t0.json_data AS json_data_9, t0.type AS type_10, t0.key_name AS key_name_11, t0.create_date AS create_date_12, t0.update_date AS update_date_13, t0.block_id AS block_id_14 FROM plg_faq_f001_block_42 t0 WHERE t0.type = 'faq01' LIMIT 1;
0.10 ms (0.02%)	1	SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED Parameters: [] View formatted query View runnable query Explain query SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
0.10 ms (0.02%)	1	SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.description AS description_4, t0.primary_color_1 AS primary_color_1_5, t0.primary_color_2 AS primary_color_2_6, t0.primary_color_3 AS primary_color_3_7, t0.primary_color_4 AS primary_color_4_8, t0.json_data AS json_data_9, t0.keyword_json_data AS keyword_json_data_10, t0.text_json_data AS text_json_data_11, t0.category_json_data AS category_json_data_12, t0.type AS type_13, t0.key_name AS key_name_14, t0.create_date AS create_date_15, t0.update_date AS update_date_16, t0.block_id AS block_id_17 FROM plg_header_block_42 t0 WHERE t0.type = ? LIMIT 1 Parameters: [`"header01"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.description AS description_4, t0.primary_color_1 AS primary_color_1_5, t0.primary_color_2 AS primary_color_2_6, t0.primary_color_3 AS primary_color_3_7, t0.primary_color_4 AS primary_color_4_8, t0.json_data AS json_data_9, t0.keyword_json_data AS keyword_json_data_10, t0.text_json_data AS text_json_data_11, t0.category_json_data AS category_json_data_12, t0.type AS type_13, t0.key_name AS key_name_14, t0.create_date AS create_date_15, t0.update_date AS update_date_16, t0.block_id AS block_id_17 FROM plg_header_block_42 t0 WHERE t0.type = ? LIMIT 1 SELECT t0.id AS id_1, t0.title AS title_2, t0.logo AS logo_3, t0.description AS description_4, t0.primary_color_1 AS primary_color_1_5, t0.primary_color_2 AS primary_color_2_6, t0.primary_color_3 AS primary_color_3_7, t0.primary_color_4 AS primary_color_4_8, t0.json_data AS json_data_9, t0.keyword_json_data AS keyword_json_data_10, t0.text_json_data AS text_json_data_11, t0.category_json_data AS category_json_data_12, t0.type AS type_13, t0.key_name AS key_name_14, t0.create_date AS create_date_15, t0.update_date AS update_date_16, t0.block_id AS block_id_17 FROM plg_header_block_42 t0 WHERE t0.type = 'header01' LIMIT 1;
0.09 ms (0.02%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_product_list_order_by t0 WHERE t0.discriminator_type IN ('productlistorderby') ORDER BY t0.sort_no ASC Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_product_list_order_by t0 WHERE t0.discriminator_type IN ('productlistorderby') ORDER BY t0.sort_no ASC SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_product_list_order_by t0 WHERE t0.discriminator_type IN ('productlistorderby') ORDER BY t0.sort_no ASC;
0.08 ms (0.02%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_product_list_max t0 WHERE t0.discriminator_type IN ('productlistmax') ORDER BY t0.sort_no ASC Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_product_list_max t0 WHERE t0.discriminator_type IN ('productlistmax') ORDER BY t0.sort_no ASC SELECT t0.id AS id_1, t0.name AS name_2, t0.sort_no AS sort_no_3, t0.discriminator_type FROM mtb_product_list_max t0 WHERE t0.discriminator_type IN ('productlistmax') ORDER BY t0.sort_no ASC;
0.06 ms (0.01%)	1	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
Eccube\Entity\AbstractEntity	No errors.
Eccube\Entity\ProductClass	No errors.
Eccube\Entity\Cart	No errors.
Eccube\Entity\Order	No errors.
Eccube\Entity\Product	No errors.
Plugin\ProductField\Entity\Config	No errors.
Eccube\Entity\BaseInfo	No errors.
Eccube\Entity\Page	No errors.
Eccube\Entity\PageLayout	No errors.
Eccube\Entity\Block	No errors.
Eccube\Entity\BlockPosition	No errors.
Eccube\Entity\Master\AbstractMasterEntity	No errors.
Eccube\Entity\Master\DeviceType	No errors.
Eccube\Entity\AuthorityRole	No errors.
Eccube\Entity\Layout	No errors.
Eccube\Entity\Customer	No errors.
Eccube\Entity\Master\Country	No errors.
Eccube\Entity\Master\Pref	No errors.
Eccube\Entity\Delivery	No errors.
Eccube\Entity\CustomerFavoriteProduct	No errors.
Eccube\Entity\Master\ProductListMax	No errors.
Eccube\Entity\Category	No errors.
Plugin\Maker42\Entity\Maker	No errors.
Eccube\Entity\Member	No errors.
Eccube\Entity\ProductCategory	No errors.
Eccube\Entity\Master\ProductListOrderBy	No errors.
Plugin\ProductField\Entity\ProductFieldContent	No errors.
Plugin\SortProduct42Plus\Entity\SortProduct	No errors.
Eccube\Entity\Master\ProductStatus	No errors.
Eccube\Entity\ProductImage	No errors.
Eccube\Entity\ProductTag	No errors.
Eccube\Entity\TaxRule	No errors.
Eccube\Entity\ProductStock	No errors.
Eccube\Entity\ClassCategory	No errors.
Eccube\Entity\Master\SaleType	No errors.
Eccube\Entity\DeliveryDuration	No errors.
Eccube\Entity\Master\RoundingType	No errors.
Eccube\Entity\ClassName	No errors.
Eccube\Entity\Tag	No errors.
Eccube\Entity\CartItem	No errors.
Plugin\BannerB001Block42\Entity\BannerBlock	No errors.
Plugin\FaqF001Block42\Entity\FaqBlock	No errors.
Plugin\HeaderBlock42\Entity\HeaderBlock	No errors.
Plugin\HsdRelatedProduct42\Entity\Config	No errors.
Eccube\Entity\News	No errors.

Symfony Profiler

http://exterior-plus.jp/index.php/block_hsd_related_product42

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping