Query Time: 15.55 ms After last query: 1.73 ms Query memory: 0.121 MB Memory before query: 2.236 MB Rows returned: 42
SELECT SQL_CALC_FOUND_ROWS girl.* ,
(SELECT metro
FROM x5qtg_sexcatalog_metro as metro
WHERE metro.id = girl.metro ) as metroname ,
(SELECT alias
FROM x5qtg_sexcatalog_metro as metro
WHERE metro.id = girl.metro ) as m_alias,
(SELECT rajon_id
FROM x5qtg_sexcatalog_metro as metro
WHERE metro.id = girl.metro ) as rajon_id,
(SELECT rajon
FROM x5qtg_sexcatalog_rajoni as rajon
WHERE rajon_id = rajon.id ) as rajon,
(SELECT alias
FROM x5qtg_sexcatalog_rajoni as rajon
WHERE rajon_id = rajon.id ) as r_alias,
(SELECT nation
FROM x5qtg_sexcatalog_nationality as nation
WHERE girl.nation = nation.id) as nation,
(SELECT alias
FROM x5qtg_sexcatalog_nationality as nation
WHERE girl.nation = nation.id ) as n_alias,
(SELECT hc
FROM x5qtg_sexcatalog_haircolor as hc
WHERE hc.id = girl.hc ) as haircolor,
(SELECT alias
FROM x5qtg_sexcatalog_haircolor as hc
WHERE hc.id = girl.hc ) as hairalias,
(SELECT GROUP_CONCAT(service) as srv
FROM x5qtg_sexcatalog_gs as gs
where gs.girl=girl.id
GROUP BY gs.girl) as gs
FROM x5qtg_sexcatalog_girl as girl
WHERE girl.id IN (59,14,39,65,68,69,71,73,74,75,76,77,78,80,81,82,83,84,85,86,88,90,91,92,93,94,96,98,101,103,105,107,108,134,162,166,203,323,324,325,327,328,329,331,338,341,347,50,87,109,110,112,115,116,117,118,120,121,124,125,126,127,129,130,131,132,133,222,223,224,226,227,228,271,275,276,277,279,282,285,289,292,293,302,303,317,321,322,337,201,191,211,398,179,180,181,182,183,184,185,186,187,189,190,192,193,194,195,196,199,200,202,205,206,210,212,214,216,217,219,220,343,345,349,376,16,27,30,33,36,37,41,42,44,46,51,52,53,62,63,64,136,141,135,142,144,152,153,156,158,167,168,169,170,171,174,176,177,178,198,208,218,188,399,67,154,444,451,478,486,487,417,468,580,2175,714,463,25,31,34,43,45,48,49,54,55,57,58,61,79,114,119,145,150,159,161,163,165,172,175,197,204,207,215,284,435,464,355,404,482,527,800,801,802,803,804,805,806,955,954,953,949,948,947,942,941,940,939,937,936,929,926,921,917,916,915,914,912,909,908,906,904,901,900,898,893,891,888,882,880,879,877,876,875,874,873,862,861,860,855,854,851,852,884,843,841,839,831,832,828,827,825,824,823,821,820,807,816,813,809,1012,883,899,819,933,846,856,935,1067,1053,1060,1061,1054,1052,1059,734,1483,1085,540,1101,537,1104,1105,484,1113,753,767,792,4382,1069,1062,1065,1057,1056,1055,1058,70,72,89,99,100,102,104,106,111,122,123,128,225,230,296,332,334,1675,483,830,834,886,894,897,1063,326,952,930,113,330,812,826,928,845,866,869,885,925,950,878,859,951,864,946,814,892,934,155,38,29,66,405,413,445,164,446,35,60,47,24,32,160,173,447,448,2179,1225,23,40,3917,3916,3915,1302,2264,2263,3914,1115,1116,1114,1120,1121,3913,1119,1122,1118,1124,3912,1123,1126,1125,1312,1315,3911,1317,3910,3909,857,1353,3908,1356,2003,1346,1338,1339,1343,1337,28,1255,1144,1392,209,13,15,19,1484,1485,1486,1487,1488,1489,1490,1491,1492,1493,1494,1495,1496,1497,1498,1499,1500,1501,1502,1503,1504,1505,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,1540,1541,1542,1543,1544,1545,1546,1547,1548,1549,1550,1551,1552,1553,1554,1555,1556,1557,1558,1559,1560,1561,1562,1563,1564,1565,1566,1567,1568,1569,1570,1571,1572,1573,1574,1575,1576,1577,1578,1579,1580,1581,1582,1583,1584,1585,1586,1587,1588,1589,1590,1591,1592,1593,1594,1595,1596,1597,1598,1599,1600,1601,1602,1603,1604,1605,1606,1607,1608,1609,1610,1611,1612,1613,1614,1615,1616,1617,1618,1619,1620,1621,1622,1623,1624,1625,1626,1627,1628,1629,1630,1631,1632,1633,1634,1635,1636,1637,1638,1639,1640,1641,1642,1643,1644,1645,1646,1647,1648,1649,1650,1651,1652,1653,1654,1655,1656,1657,1658,2099,1660,1661,1662,1663,1664,1665,1666,1667,1668,1669,1670,1671,1672,1673,1674,1676,1677,1678,1679,1680,1681,1682,1683,1684,1686,1687,1688,1689,1690,1691,1692,1693,1694,1695,1696,1697,1698,1699,1700,1701,1702,1703,1704,1705,1706,1707,2101,2100,2113,2112,2093,2114,2082,2081,1715,2010,2009,1718,2006,2004,2131,2132,2183,2023,2022,1727,1728,2087,2180,1731,2171,1997,1998,2076,2074,2000,1739,1740,2034,2117,1745,1746,1747,1749,2075,3877,2016,2015,2017,2123,2122,1755,2104,2103,2002,1760,1994,1762,1995,1764,1765,1766,1767,2029,1769,1770,2141,2165,2135,2166,2156,2136,1778,1781,1784,1783,2130,1786,1787,1983,1790,1982,1979,1793,2011,2109,2019,2018,2157,2161,2160,2134,1803,2128,1805,2127,2125,2126,1809,2116,2073,1813,2071,2151,1816,2020,1818,1819,2014,2037,1822,1823,1824,1999,2133,2124,1828,1829,2072,1831,1993,2140,2139,2096,2095,1981,2067,1837,2008,2090,2089,2028,2085,2168,2167,2025,2026,1847,1848,2031,2173,1851,2108,1854,1855,1856,1857,1858,2266,2106,2153,1862,1864,2177,2174,2149,2152,2164,2150,1872,2111,1874,2084,1876,2107,2142,2027,1880,2012,2013,1883,1996,1992,1886,2143,1991,1889,1890,1980,1978,1893,2080,1895,2007,1897,2005,2148,2091,1902,2176,2172,2030,2032,1907,2162,2163,2129,2159,1974,1975,1973,2158,2024,2098,2097,2144,2105,1921,2147,1923,1924,2092,2110,2068,2077,1930,2069,2078,2145,2137,2155,1936,1937,1938,1939,2094,2083,2102,1989,2170,1988,1987,1984,2138,2088,1952,1986,1990,2146,2115,1976,2154,2033,1960,1961,2120,2119,1964,2169,2021,2079,2086,2181,2182,2187,2185,2186,2188,2189,4212,4211,4210,4209,4208,4421,4207,4304,4303,4302,4301,4300,4299,4298,4403,4297,4296,4295,4294,4293,4292,4291,4290,4289,4288,4287,4286,4402,4285,3172,3171,4284,4283,4282,4281,4280,4279,4278,4428,4277,4276,4275,4274,4271,2318,4273,4270,4272,2243,2244,2245,2246,2247,2248,2249,2250,2251,2252,2253,2254,2255,2256,2257,2258,2259,2260,2261,2262,2267,2268,2269,2270,2271,2272,2273,2274,2275,2276,2277,2278,2279,2280,2281,2282,2283,2284,2285,2286,2287,2288,2289,2290,2291,2292,2293,2294,2295,2296,2297,2298,2299,2300,2301,2302,2303,2304,2305,2306,2308,2309,2310,2311,2312,2313,2314,2315,2316,2317,2319,2320,2321,2322,2323,2324,2325,2326,2327,2328,2329,2330,2331,2332,2333,2334,2335,2336,2337,2338,2339,2340,2341,2342,2343,2344,2345,2346,2347,2348,2349,2350,2351,2352,2353,2354,2355,2356,2357,2358,2359,2360,2361,2362,2363,2364,2365,2366,2367,2368,2369,2370,2371,2372,2373,2374,2375,2376,2377,2378,2379,2380,2381,2382,2383,2384,2385,2386,2387,2388,2389,2390,2391,2392,2393,2394,2395,2396,2397,2398,2399,2400,2401,2402,2403,2404,2405,2406,2407,2408,2409,2410,2411,2412,2413,2414,2415,2416,2417,2418,2419,2420,2421,2422,2423,2424,2425,2426,2427,2428,2429,2430,2431,2432,2433,2434,2435,2436,2437,2438,2439,2440,2441,2442,2443,2444,2445,2446,2447,2448,2449,2450,2452,2451,2453,2454,2455,2456,2457,2458,2459,2460,2461,2462,2463,2464,2465,2184,2483,2588,2589,2590,2591,2592,2593,2594,2595,2596,2597,2598,2599,2600,2601,2602,2603,2604,2605,2606,2607,2608,2609,2610,2611,2612,2613,2614,2615,2616,2617,2618,2619,2620,2621,2622,2623,2624,2625,2626,2627,2628,2629,2630,2631,2632,2633,2634,2635,2636,2637,2638,2639,2640,2641,2642,2643,2644,2645,2646,2647,2648,2649,2650,2651,2652,2653,2654,2655,2656,2657,2658,2659,2660,2661,2662,2663,2664,2665,2666,2667,2668,2669,2670,2671,2672,2673,2674,2675,2676,2677,2678,2679,2680,2681,2682,2683,2684,2685,2686,2687,2688,2689,2690,2691,2692,2693,2694,2695,2696,2697,2698,2699,2700,2701,2702,2703,2704,2705,2706,2707,2708,2709,2710,2711,2712,2713,2714,2715,2716,3821,2717,2718,2719,2720,2721,2722,2723,3820,2724,2725,2726,2727,2728,2729,3819,2730,2731,2732,2733,2734,3816,2741,2745,2746,2747,2748,2749,2750,2751,2752,2753,2754,2755,2756,2757,2758,2759,2760,2761,2762,2763,2764,2765,2766,2767,2768,2769,2770,2771,2772,2773,2774,2775,2776,2777,2778,2779,2780,2781,2782,2783,2784,2785,2786,2787,2788,2789,2790,2791,2792,2793,2794,2795,2796,2797,2798,2799,2800,2801,2802,2803,2804,2805,2806,2807,2808,2809,2810,2811,2812,2813,2814,2815,2816,2817,2818,2819,2820,2821,2822,2823,2824,2825,2826,2827,2828,2829,2830,2831,2832,2833,2834,2835,2836,2837,2838,2839,2840,2841,2842,2843,2844,2845,2846,2847,2848,2849,2850,2851,2852,2853,2854,2855,2856,2857,2858,2859,2860,2861,2862,2863,2864,2865,2866,2867,2868,3170,2870,2871,2872,2873,2874,2875,2876,4361,4360,4359,4358,4357,4356,4355,4354,4353,4352,4351,4350,4349,4348,4347,4346,4345,4344,4343,4342,4341,4340,4339,4338,4337,4336,4383,4379,4387,4335,4334,4333,4332,4407,4134,4133,4269,4268,4422,4267,4266,2927,2928,2929,2930,2931,2932,2933,2934,2935,2936,2937,2938,3815,2939,2940,2941,2942,2943,2944,2945,2946,2947,2948,2949,2950,2951,2952,2953,2954,2955,2956,2957,2958,2959,2960,2961,2962,2963,2964,2965,2966,2967,2968,2969,2970,2971,2972,2973,2974,2975,2976,2977,2978,2979,2980,2981,2982,2983,2984,2985,2986,2987,2988,2989,2990,2991,2992,2993,2994,2995,2996,2997,2998,2999,3000,3001,3002,3003,3004,3005,3006,3007,3008,3009,4150,4149,4148,4147,4168,4167,4166,4165,4164,4163,4420,4162,4161,4160,4159,4158,4157,4156,4155,4405,4154,4153,4152,4151,4186,4185,4184,4183,4404,4182,4181,4180,4179,4178,4177,4415,4176,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,3103,3102,3104,3105,3106,3107,3108,3109,3110,3111,3112,3113,3114,3115,3116,3117,3118,3119,4234,4233,4232,4231,4230,4229,4228,4227,4226,4225,4224,4223,4222,4221,4220,4219,4218,4206,4205,4204,4203,4202,4201,4200,4199,4370,4198,4376,4197,4196,4195,4194,4193,4192,4191,4190,4189,4188,4187,3173,3174,3175,3176,3177,3178,3179,3180,3181,3182,3183,3184,3186,3185,3187,3188,3189,3190,3191,3192,3193,3194,3195,3196,3197,3199,3198,3200,3201,3202,3203,3204,3205,3206,3207,3208,3209,3210,3211,3212,3213,3214,3215,3217,3216,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,3255,3244,3245,3246,3247,3248,3249,3250,3251,3252,3253,3254,3257,3256,3258,3261,3259,3260,3262,3267,3263,3264,3265,3266,3271,3268,3269,3270,3272,3274,3273,3278,3275,3276,3277,3288,3279,3280,3281,3282,3283,3284,3285,3286,3287,3293,3289,3290,3291,3292,3296,3294,3295,3297,3298,3299,3300,3301,3814,3302,3303,3304,3305,3306,3307,3308,3813,3309,3310,3311,3312,3313,3314,3315,3316,3317,3318,3812,3319,3320,3321,3327,3323,3324,3325,3326,3328,3811,3329,3330,3331,3332,3333,3334,3335,3336,3337,3810,3338,3339,3340,3341,4146,4145,4144,3809,4143,4142,4141,4175,4174,4173,3808,4172,4398,4397,4396,4395,4394,4393,4392,4391,4390,4389,4388,4171,4362,4363,4365,4364,4305,4170,4169,4217,4216,4215,4406,4401,4214,4409,4400,4399,4408,4424,4427,4426,4425,4423,4414,4413,4412,4411,4410,4373,4372,4374,4375,4213,4419,4418,4416,4417,3442,3443,3444,3445,3807,3446,3447,3448,3449,3450,3806,3451,3452,3453,3454,3455,3456,3805,3457,3458,3459,3460,3461,3462,3463,3804,3464,3465,3466,3467,3468,3469,3470,3471,3472,3803,3473,3474,3475,3476,3477,3478,3479,3480,3802,3481,3482,3483,3484,3485,3486,3487,3801,3488,3489,3490,3491,3492,3493,3494,3495,3800,3496,3497,3498,3499,3500,3501,3502,3799,3503,3504,3505,3506,3507,3508,3509,3798,3510,3511,3512,3513,3514,3515,3516,3517,3518,3797,3519,3520,3521,3522,3523,3524,3525,3529,3530,3531,3532,3533,3534,3795,3535,3536,3537,3538,3539,3540,3541,3547,3794,3548,3549,3550,3551,3552,3553,3554,3555,3556,3557,3558,3559,3560,3561,20,21,3562,3563,3793,3564,3565,3566,3567,3568,3569,3570,3571,3572,3573,3574,3792,3575,3576,3577,3578,3579,3580,3582,3584,3585,3586,3587,3588,3589,3791,3590,3591,3592,3593,3594,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,3790,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,3669,3670,3671,3672,3674,3675,3676,3677,3678,3679,3680,3681,4140,4139,4138,4137,4369,4386,4136,4135,4385,4265,4264,4263,4262,4261,4381,4260,4380,4259,4258,4257,4256,4255,4254,4253,4252,4251,4250,4366,4249,4248,4378,4247,4246,4245,4367,4244,4243,4242,4241,4240,4239,4238,4237,4236,4235,4331,4330,4329,4328,4327,4326,4325,4324,4323,4322,4321,4320,4319,4318,4317,4316,4371,3818,3817,4315,4384,4377,4314,4313,4368,4312,4311,4310,4309,4308,4307,4306,4081,4089,4429,4430,4431,4432,4433,4434,4435,4436,4437,4438,4439,4440,4441,4442,4443,4444,4445,4446,4447,4448,4449,4450,4451,4452,4453,4454,4455,4456,4457,4458,4459,4460,4461,4462,4463,4464,4465,4466,4467,4468,4469,4470,4471,4472,4473,4474,4475,4476,4477,4478,4479,4480,4481,4482,4483,4484,4485,4486,4487,4488,4489,4490,4491)
AND girl.flag_status_1 = "1"
AND girl.flag_status_2 = "1"
ORDER by girl.
order ASC
LIMIT 0, 42
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | PRIMARY | girl | ALL | PRIMARY | NO INDEX KEY COULD BE USED | NULL | NULL | 3513 | Using where; Using filesort |
11 | DEPENDENT SUBQUERY | gs | ref | girl | girl | 5 | gorchiza.girl.id | 15 | Using where |
10 | DEPENDENT SUBQUERY | hc | eq_ref | PRIMARY | PRIMARY | 4 | gorchiza.girl.hc | 1 | |
9 | DEPENDENT SUBQUERY | hc | eq_ref | PRIMARY | PRIMARY | 4 | gorchiza.girl.hc | 1 | |
8 | DEPENDENT SUBQUERY | nation | eq_ref | PRIMARY | PRIMARY | 4 | gorchiza.girl.nation | 1 | |
7 | DEPENDENT SUBQUERY | nation | eq_ref | PRIMARY | PRIMARY | 4 | gorchiza.girl.nation | 1 | |
6 | DEPENDENT SUBQUERY | rajon | eq_ref | PRIMARY | PRIMARY | 4 | func | 1 | Using where |
5 | DEPENDENT SUBQUERY | rajon | eq_ref | PRIMARY | PRIMARY | 4 | func | 1 | Using where |
4 | DEPENDENT SUBQUERY | metro | eq_ref | PRIMARY | PRIMARY | 4 | gorchiza.girl.metro | 1 | |
3 | DEPENDENT SUBQUERY | metro | eq_ref | PRIMARY | PRIMARY | 4 | gorchiza.girl.metro | 1 | |
2 | DEPENDENT SUBQUERY | metro | eq_ref | PRIMARY | PRIMARY | 4 | gorchiza.girl.metro | 1 | |
Status | Duration |
---|
executing | 0.00 ms |
Sending data | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
executing | 0.00 ms |
Sorting result | 0.00 ms |
Sending data | 0.04 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.04 ms |
executing | 0.01 ms |
Sorting result | 0.00 ms |
Sending data | 0.05 ms |
executing | 0.01 ms |
Sending data | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
executing | 0.00 ms |
Sorting result | 0.00 ms |
Sending data | 0.06 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
executing | 0.00 ms |
Sorting result | 0.00 ms |
Sending data | 0.05 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
executing | 0.00 ms |
Sorting result | 0.00 ms |
Sending data | 0.04 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
executing | 0.00 ms |
Sorting result | 0.00 ms |
Sending data | 0.04 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.02 ms |
executing | 0.01 ms |
Sorting result | 0.01 ms |
Sending data | 0.06 ms |
executing | 0.01 ms |
Sending data | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
executing | 0.00 ms |
Sending data | 0.01 ms |
executing | 0.00 ms |
Sorting result | 0.00 ms |
Sending data | 0.04 ms |
end | 0.01 ms |
removing tmp table | 0.01 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.01 ms |
removing tmp table | 0.00 ms |
freeing items | 0.00 ms |
removing tmp table | 0.00 ms |
freeing items | 0.00 ms |
removing tmp table | 0.00 ms |
freeing items | 0.00 ms |
removing tmp table | 0.00 ms |
freeing items | 0.00 ms |
removing tmp table | 0.00 ms |
freeing items | 0.00 ms |
removing tmp table | 0.00 ms |
freeing items | 0.00 ms |
removing tmp table | 0.00 ms |
freeing items | 0.00 ms |
removing tmp table | 0.00 ms |
freeing items | 0.00 ms |
removing tmp table | 0.00 ms |
freeing items | 0.08 ms |
updating status | 0.03 ms |
cleaning up | 0.01 ms |
# | Caller | File and line number |
---|
13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
12 | JDatabaseDriver->loadObjectList() | JROOT/components/com_sexcatalog/models/list.php:305 |
11 | SexcatalogModelList->getGirlList() | JROOT/components/com_sexcatalog/views/list/view.html.php:57 |
10 | SexcatalogViewList->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_sexcatalog/controller.php:26 |
8 | SexcatalogController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_sexcatalog/sexcatalog.php:39 |
6 | require_once JROOT/components/com_sexcatalog/sexcatalog.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |