| Query | Affected | Num. rows | Took (ms) | Actions |
|---|
| SELECT `Service`.`id`, `Service`.`nom`, `Service`.`slug`, `Service`.`article` FROM `isoprod`.`services` AS `Service` WHERE `Service`.`slug` = 'sportswear' LIMIT 1 | 1 | 1 | 0 | |
| SELECT `MagasinService`.`id`, `MagasinService`.`magasin_id` FROM `isoprod`.`magasins_services` AS `MagasinService` WHERE `MagasinService`.`service_id` = 6 | 550 | 550 | 3 | |
| SELECT `User`.`id`, `User`.`name`, `User`.`email`, `User`.`password`, `User`.`salt`, `User`.`role_id`, `User`.`avatar`, `User`.`photo`, `User`.`created`, `User`.`last_login`, `User`.`photo_count`, `User`.`friend_count`, `User`.`notification_count`, `User`.`friend_request_count`, `User`.`blog_count`, `User`.`topic_count`, `User`.`group_count`, `User`.`event_count`, `User`.`conversation_user_count`, `User`.`video_count`, `User`.`gender`, `User`.`birthday`, `User`.`active`, `User`.`confirmed`, `User`.`code`, `User`.`notification_email`, `User`.`timezone`, `User`.`ip_address`, `User`.`privacy`, `User`.`username`, `User`.`about`, `User`.`featured`, `User`.`lang`, `User`.`hide_online`, `User`.`cover`, `User`.`approved`, `User`.`is_social`, `User`.`has_active_subscription`, `User`.`receive_message_from_non_friend`, `User`.`send_email_when_send_message`, `User`.`request_friend_email`, `User`.`notification_setting`, `User`.`profile_type_id`, `User`.`first_name`, `User`.`last_name`, `User`.`phone`, `User`.`facebook_link`, `User`.`twitter_handle`, `User`.`instagram_handle`, `User`.`strava_handle`, `User`.`linkedin_handle`, `User`.`disciplines`, `User`.`distance`, `User`.`level_id`, `User`.`lat`, `User`.`lng`, `User`.`kilometer_count`, `User`.`training_count`, `User`.`team_count`, `User`.`address`, `User`.`city`, `User`.`state`, `User`.`country`, `User`.`bike1_id`, `User`.`is_pro`, `User`.`social_avatar`, `User`.`magasin`, `User`.`postal_code`, `User`.`country_id`, `User`.`departement_id`, `User`.`registeredby`, `User`.`handisport`, `User`.`licence`, `User`.`licence_ffc`, `User`.`reset_password_token`, `User`.`token_created_at`, `User`.`urgence_nom`, `User`.`urgence_prenom`, `User`.`urgence_tel`, `User`.`tva_intra`, `User`.`raison_sociale`, `User`.`pays_id`, `User`.`uuid`, `User`.`club`, `User`.`token`, `User`.`role_v3`, `User`.`CG`, `Country`.`id`, `Country`.`name`, `Country`.`country_iso`, `Country`.`state_count`, `Country`.`order`, `Country`.`name_fr`, `Departement`.`id`, `Departement`.`departement_code`, `Departement`.`departement_nom`, `Departement`.`departement_nom_uppercase`, `Departement`.`departement_slug`, `Departement`.`departement_nom_soundex`, `Departement`.`country_id`, `Departement`.`article`, `Departement`.`ordre`, `Departement`.`pays_id`, (CONCAT(`Departement`.`departement_code`, " - ", `Departement`.`departement_nom`)) AS `Departement__code_nom` FROM `isoprod`.`users` AS `User` LEFT JOIN `isoprod`.`countries` AS `Country` ON (`User`.`country_id` = `Country`.`id`) LEFT JOIN `isoprod`.`departements` AS `Departement` ON (`User`.`departement_id` = `Departement`.`id`) WHERE `User`.`id` IS NULL LIMIT 1 | 0 | 0 | 1 | maybe slow |
| SELECT *, MagasinType.id, Departement.id FROM `isoprod`.`magasins` AS `Magasin` LEFT JOIN `isoprod`.`magasins_types` AS `MagasinType` ON (`Magasin`.`magasin_type_id` = `MagasinType`.`id`) LEFT JOIN `isoprod`.`departements` AS `Departement` ON (`Magasin`.`departement_id` = `Departement`.`id`) WHERE `Magasin`.`id` IN (49, 146, 148, 151, 149, 147, 145, 154, 155, 94, 96, 104, 97, 92, 105, 90, 225, 195, 303, 304, 305, 306, 308, 309, NULL, 312, 311, 313, 316, 317, 318, 319, 341, 342, 343, 344, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 417, 420, 419, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 454, 455, 457, 458, 461, 462, 464, 465, 467, NULL, 472, 473, 475, 476, 477, 478, 479, 555, 556, 557, 558, 559, 560, 561, 562, 563, 564, 565, 566, 568, 569, 570, 571, 572, 575, 576, 577, 579, 580, 583, 584, 585, 586, 587, 588, 589, 591, 640, 642, 644, 645, 646, 647, 648, 650, 651, 652, 653, 654, 655, 657, 658, 660, 661, 662, 663, 687, 689, 691, 693, 694, 697, 698, 700, 703, 705, 706, 708, 711, 713, 714, 718, 720, 721, 724, 726, 729, 731, 733, 734, 736, 738, 743, 750, 757, 746, 741, 749, 753, 758, 150, 763, 764, 765, 766, 767, 768, 769, 770, 771, 773, 772, 774, 775, 776, 777, 778, 779, 780, 781, 782, 783, 784, 785, 786, 787, 788, 789, 790, 791, 792, 793, 814, 851, 852, 853, 854, 855, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 871, 872, 873, 874, 875, 876, 877, 878, 879, 880, 881, 882, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 900, 901, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 915, 916, 917, 918, 919, 920, 921, 922, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 940, 941, NULL, 943, 944, 945, 946, 947, 948, 949, 950, 951, 952, 953, 955, 954, 956, 957, 958, 959, 960, 961, 962, 963, 964, 965, 990, 991, 992, 993, 994, 995, 996, 997, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1022, 1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1035, 1036, 1037, 1038, 1039, 1040, 1041, 1042, 1043, 1044, 1045, 1046, 1047, 1048, 1049, 1050, 1051, 1052, 1053, 1054, 1055, 1056, 1058, 1059, 1060, 1061, 1062, 1063, 1064, 1065, 1066, 1067, 1068, 1069, 1070, 1071, 1072, 1073, 1074, 1075, 1076, 1077, 1078, 1079, 1080, 1081, 1082, 1083, 1084, 1085, 1086, 1087, 1088, 1090, 1091, 1092, 1094, 1095, 1097, 1098, 1099, 1100, 1101, 1102, 1104, 1106, 1108, 1140, 1141, 1142, 1143, 1145, 1146, 1148, 1150, 1152, 1153, 1155, 1157, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, NULL, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1210, 1209, 1211, 1212, 1214, 1216, 1217, 1218, 1219, 1220, 1221, 1223, 1224, 1225, 1226, 1228, 1233, 762, 418, 1268, 1276, 1285, 1299, 1311, 1351, 1483, 1506, 1509, 1171, 1558, 469, 1215, 307, 939, 1222, 883, 1672, 1297, 1761, 1762, 1767, 1771, 314, 1784, 396, 1788, 1790, 856, 1802, 471, 474, 470, 1502, 2053, 2054, 2066, 2067, 468, 1227, 1213, 2158, 2157, 2168, 2166, 2169, 2170, 2171, 2172, 2179, 2185, 2205) ORDER BY rand() ASC LIMIT 20 | 20 | 20 | 13 | maybe slow |
| SELECT COUNT(*) AS `count` FROM `isoprod`.`magasins` AS `Magasin` WHERE `Magasin`.`id` IN (49, 146, 148, 151, 149, 147, 145, 154, 155, 94, 96, 104, 97, 92, 105, 90, 225, 195, 303, 304, 305, 306, 308, 309, NULL, 312, 311, 313, 316, 317, 318, 319, 341, 342, 343, 344, 367, 368, 369, 370, 371, 372, 373, 374, 375, 376, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 417, 420, 419, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 454, 455, 457, 458, 461, 462, 464, 465, 467, NULL, 472, 473, 475, 476, 477, 478, 479, 555, 556, 557, 558, 559, 560, 561, 562, 563, 564, 565, 566, 568, 569, 570, 571, 572, 575, 576, 577, 579, 580, 583, 584, 585, 586, 587, 588, 589, 591, 640, 642, 644, 645, 646, 647, 648, 650, 651, 652, 653, 654, 655, 657, 658, 660, 661, 662, 663, 687, 689, 691, 693, 694, 697, 698, 700, 703, 705, 706, 708, 711, 713, 714, 718, 720, 721, 724, 726, 729, 731, 733, 734, 736, 738, 743, 750, 757, 746, 741, 749, 753, 758, 150, 763, 764, 765, 766, 767, 768, 769, 770, 771, 773, 772, 774, 775, 776, 777, 778, 779, 780, 781, 782, 783, 784, 785, 786, 787, 788, 789, 790, 791, 792, 793, 814, 851, 852, 853, 854, 855, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 871, 872, 873, 874, 875, 876, 877, 878, 879, 880, 881, 882, 884, 885, 886, 887, 888, 889, 890, 891, 892, 893, 894, 895, 896, 897, 898, 899, 900, 901, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 915, 916, 917, 918, 919, 920, 921, 922, 923, 924, 925, 926, 927, 928, 929, 930, 931, 932, 933, 934, 935, 936, 937, 938, 940, 941, NULL, 943, 944, 945, 946, 947, 948, 949, 950, 951, 952, 953, 955, 954, 956, 957, 958, 959, 960, 961, 962, 963, 964, 965, 990, 991, 992, 993, 994, 995, 996, 997, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1022, 1024, 1025, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1035, 1036, 1037, 1038, 1039, 1040, 1041, 1042, 1043, 1044, 1045, 1046, 1047, 1048, 1049, 1050, 1051, 1052, 1053, 1054, 1055, 1056, 1058, 1059, 1060, 1061, 1062, 1063, 1064, 1065, 1066, 1067, 1068, 1069, 1070, 1071, 1072, 1073, 1074, 1075, 1076, 1077, 1078, 1079, 1080, 1081, 1082, 1083, 1084, 1085, 1086, 1087, 1088, 1090, 1091, 1092, 1094, 1095, 1097, 1098, 1099, 1100, 1101, 1102, 1104, 1106, 1108, 1140, 1141, 1142, 1143, 1145, 1146, 1148, 1150, 1152, 1153, 1155, 1157, 1159, 1160, 1161, 1162, 1163, 1164, 1165, 1166, 1167, 1168, 1169, 1170, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, NULL, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1210, 1209, 1211, 1212, 1214, 1216, 1217, 1218, 1219, 1220, 1221, 1223, 1224, 1225, 1226, 1228, 1233, 762, 418, 1268, 1276, 1285, 1299, 1311, 1351, 1483, 1506, 1509, 1171, 1558, 469, 1215, 307, 939, 1222, 883, 1672, 1297, 1761, 1762, 1767, 1771, 314, 1784, 396, 1788, 1790, 856, 1802, 471, 474, 470, 1502, 2053, 2054, 2066, 2067, 468, 1227, 1213, 2158, 2157, 2168, 2166, 2169, 2170, 2171, 2172, 2179, 2185, 2205) | 1 | 1 | 2 | maybe slow |
| SELECT `Departement`.`departement_slug`, (CONCAT(`Departement`.`departement_code`, " - ", `Departement`.`departement_nom`)) AS `Departement__code_nom` FROM `isoprod`.`departements` AS `Departement` WHERE 1 = 1 ORDER BY `ordre` ASC, `id` ASC | 234 | 234 | 1 | |
| SELECT `MagasinType`.`slug`, `MagasinType`.`nom` FROM `isoprod`.`magasins_types` AS `MagasinType` WHERE 1 = 1 ORDER BY `MagasinType`.`ordre` ASC | 10 | 10 | 0 | |
| SELECT `Marque`.`slug`, `Marque`.`nom` FROM `isoprod`.`marques` AS `Marque` WHERE 1 = 1 ORDER BY `Marque`.`nom` ASC | 138 | 138 | 1 | |
| SELECT `Service`.`slug`, `Service`.`nom` FROM `isoprod`.`services` AS `Service` WHERE 1 = 1 ORDER BY `Service`.`nom` ASC | 13 | 13 | 0 | |
| SELECT `Collection`.`url`, `Collection`.`titre`, `Collection`.`photo` FROM `isoprod`.`collections` AS `Collection` WHERE `type` = 'magasin' AND `statut` = 1 ORDER BY `ordre` ASC | 7 | 7 | 0 | |
| SELECT `Country`.`id`, `Country`.`name_fr` FROM `isoprod`.`countries` AS `Country` WHERE 1 = 1 ORDER BY `name_fr` ASC | 244 | 244 | 3 | |
| SELECT `Config`.`nom`, `Config`.`valeur` FROM `isoprod`.`configs` AS `Config` WHERE `categorie` = 'v3' | 8 | 8 | 1 | maybe slow |