Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

18.69 ms Query time

3 Invalid entities

1476 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

8.95 ms
(47.90%)

SELECT d0_.id_dechet AS id_dechet_0, d0_.nom AS nom_1, d0_.synonyme AS synonyme_2, d0_.consignes_evitement AS consignes_evitement_3, d0_.consignes_tri AS consignes_tri_4, d0_.consignes_valorisation AS consignes_valorisation_5, d0_.filieres_rep AS filieres_rep_6, d0_.visible AS visible_7 FROM dechet d0_ WHERE d0_.visible = ? ORDER BY d0_.nom ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id_dechet AS id_dechet_0,
  d0_.nom AS nom_1,
  d0_.synonyme AS synonyme_2,
  d0_.consignes_evitement AS consignes_evitement_3,
  d0_.consignes_tri AS consignes_tri_4,
  d0_.consignes_valorisation AS consignes_valorisation_5,
  d0_.filieres_rep AS filieres_rep_6,
  d0_.visible AS visible_7
FROM
  dechet d0_
WHERE
  d0_.visible = ?
ORDER BY
  d0_.nom ASC

SELECT d0_.id_dechet AS id_dechet_0, d0_.nom AS nom_1, d0_.synonyme AS synonyme_2, d0_.consignes_evitement AS consignes_evitement_3, d0_.consignes_tri AS consignes_tri_4, d0_.consignes_valorisation AS consignes_valorisation_5, d0_.filieres_rep AS filieres_rep_6, d0_.visible AS visible_7 FROM dechet d0_ WHERE d0_.visible = 1 ORDER BY d0_.nom ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\DechetRepository->findAllVisible (line 29)
7	App\Form\SearchDechetFormType->buildForm (line 36)
8	Symfony\Component\Form\ResolvedFormType->buildForm (line 96)
9	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 73)
10	Symfony\Component\Form\FormFactory->createNamedBuilder (line 56)
11	Symfony\Component\Form\FormFactory->createBuilder (line 41)
12	Symfony\Component\Form\FormFactory->create (line 26)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 323)
14	App\Controller\GuideTriController->index (line 43)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 182)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 29)
20	require_once (line 5)

4.93 ms
(26.35%)

SELECT d0_.id_decheterie AS id_decheterie_0, d0_.nom AS nom_1, d0_.adresse AS adresse_2, d0_.latitude AS latitude_3, d0_.longitude AS longitude_4, d0_.telephone AS telephone_5, d0_.open_lun_matin AS open_lun_matin_6, d0_.open_lun_aprem AS open_lun_aprem_7, d0_.open_mar_matin AS open_mar_matin_8, d0_.open_mar_aprem AS open_mar_aprem_9, d0_.open_mer_matin AS open_mer_matin_10, d0_.open_mer_aprem AS open_mer_aprem_11, d0_.open_jeu_matin AS open_jeu_matin_12, d0_.open_jeu_aprem AS open_jeu_aprem_13, d0_.open_ven_matin AS open_ven_matin_14, d0_.open_ven_aprem AS open_ven_aprem_15, d0_.open_sam_matin AS open_sam_matin_16, d0_.open_sam_aprem AS open_sam_aprem_17, d0_.open_dim_matin AS open_dim_matin_18, d0_.open_dim_aprem AS open_dim_aprem_19, d0_.icon AS icon_20, d0_.conditions_acces AS conditions_acces_21, d0_.informations AS informations_22, d0_.photo_1 AS photo_1_23, d0_.photo_2 AS photo_2_24, d0_.photo_3 AS photo_3_25, d0_.visible AS visible_26, d0_.id_tc_flux AS id_tc_flux_27, d0_.id_tc_ville AS id_tc_ville_28 FROM decheterie d0_ LEFT JOIN decheterie_ville d2_ ON d0_.id_decheterie = d2_.id_decheterie LEFT JOIN tc_ville t1_ ON t1_.id_tc_ville = d2_.id_tc_ville LEFT JOIN tc_ville t3_ ON d0_.id_tc_ville = t3_.id_tc_ville WHERE d0_.visible = 1 AND (d0_.id_tc_ville IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) OR t1_.id_tc_ville IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND t1_.id_tc_structure = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id_decheterie AS id_decheterie_0,
  d0_.nom AS nom_1,
  d0_.adresse AS adresse_2,
  d0_.latitude AS latitude_3,
  d0_.longitude AS longitude_4,
  d0_.telephone AS telephone_5,
  d0_.open_lun_matin AS open_lun_matin_6,
  d0_.open_lun_aprem AS open_lun_aprem_7,
  d0_.open_mar_matin AS open_mar_matin_8,
  d0_.open_mar_aprem AS open_mar_aprem_9,
  d0_.open_mer_matin AS open_mer_matin_10,
  d0_.open_mer_aprem AS open_mer_aprem_11,
  d0_.open_jeu_matin AS open_jeu_matin_12,
  d0_.open_jeu_aprem AS open_jeu_aprem_13,
  d0_.open_ven_matin AS open_ven_matin_14,
  d0_.open_ven_aprem AS open_ven_aprem_15,
  d0_.open_sam_matin AS open_sam_matin_16,
  d0_.open_sam_aprem AS open_sam_aprem_17,
  d0_.open_dim_matin AS open_dim_matin_18,
  d0_.open_dim_aprem AS open_dim_aprem_19,
  d0_.icon AS icon_20,
  d0_.conditions_acces AS conditions_acces_21,
  d0_.informations AS informations_22,
  d0_.photo_1 AS photo_1_23,
  d0_.photo_2 AS photo_2_24,
  d0_.photo_3 AS photo_3_25,
  d0_.visible AS visible_26,
  d0_.id_tc_flux AS id_tc_flux_27,
  d0_.id_tc_ville AS id_tc_ville_28
FROM
  decheterie d0_
  LEFT JOIN decheterie_ville d2_ ON d0_.id_decheterie = d2_.id_decheterie
  LEFT JOIN tc_ville t1_ ON t1_.id_tc_ville = d2_.id_tc_ville
  LEFT JOIN tc_ville t3_ ON d0_.id_tc_ville = t3_.id_tc_ville
WHERE
  d0_.visible = 1
  AND (
    d0_.id_tc_ville IN (
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?
    )
    OR t1_.id_tc_ville IN (
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?,
      ?
    )
  )
  AND t1_.id_tc_structure = ?

SELECT d0_.id_decheterie AS id_decheterie_0, d0_.nom AS nom_1, d0_.adresse AS adresse_2, d0_.latitude AS latitude_3, d0_.longitude AS longitude_4, d0_.telephone AS telephone_5, d0_.open_lun_matin AS open_lun_matin_6, d0_.open_lun_aprem AS open_lun_aprem_7, d0_.open_mar_matin AS open_mar_matin_8, d0_.open_mar_aprem AS open_mar_aprem_9, d0_.open_mer_matin AS open_mer_matin_10, d0_.open_mer_aprem AS open_mer_aprem_11, d0_.open_jeu_matin AS open_jeu_matin_12, d0_.open_jeu_aprem AS open_jeu_aprem_13, d0_.open_ven_matin AS open_ven_matin_14, d0_.open_ven_aprem AS open_ven_aprem_15, d0_.open_sam_matin AS open_sam_matin_16, d0_.open_sam_aprem AS open_sam_aprem_17, d0_.open_dim_matin AS open_dim_matin_18, d0_.open_dim_aprem AS open_dim_aprem_19, d0_.icon AS icon_20, d0_.conditions_acces AS conditions_acces_21, d0_.informations AS informations_22, d0_.photo_1 AS photo_1_23, d0_.photo_2 AS photo_2_24, d0_.photo_3 AS photo_3_25, d0_.visible AS visible_26, d0_.id_tc_flux AS id_tc_flux_27, d0_.id_tc_ville AS id_tc_ville_28 FROM decheterie d0_ LEFT JOIN decheterie_ville d2_ ON d0_.id_decheterie = d2_.id_decheterie LEFT JOIN tc_ville t1_ ON t1_.id_tc_ville = d2_.id_tc_ville LEFT JOIN tc_ville t3_ ON d0_.id_tc_ville = t3_.id_tc_ville WHERE d0_.visible = 1 AND (d0_.id_tc_ville IN (2199, 2200, 2202, 2203, 2204, 2205, 2209, 2210, 2211, 2212, 2213, 2214, 2216, 2217, 2218, 2219, 2220, 2221, 2222, 2223, 2224, 2225, 2226, 2227, 2228, 2229, 2230, 2231, 2232, 2233, 2234, 2235, 2236, 2237, 2238, 2239, 2240, 2241, 2242, 2243, 2244, 2245, 2246, 2247, 2248, 2249, 2250, 2251, 2252, 2253, 2254, 2255, 2256, 2257, 2258, 2259, 2260, 2261, 2262, 2263, 2264, 2265, 2266, 2267, 2268, 2269, 2270, 2271, 2272, 2273, 2274, 2275, 2276, 2277, 2278, 2279, 2280, 2281, 2282, 2284, 2285, 2286, 2287, 2288, 2289, 2291, 2292, 2293, 2294, 2295, 2296, 2297, 2298, 2299, 2300, 2301, 2302, 2303, 2304, 2305, 2306, 2307, 2308, 2309, 2310, 2311, 2312, 2313, 2314, 2315, 2316, 2317, 2318, 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, 2436, 2437, 2438, 2439, 2441, 2442, 2443, 2444, 2445, 2446, 2447, 2448, 2449, 2450, 2451, 2452, 2453, 2454, 2455, 2456, 2457, 2459, 2460, 2461, 2463, 2464, 2465, 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) OR t1_.id_tc_ville IN (2199, 2200, 2202, 2203, 2204, 2205, 2209, 2210, 2211, 2212, 2213, 2214, 2216, 2217, 2218, 2219, 2220, 2221, 2222, 2223, 2224, 2225, 2226, 2227, 2228, 2229, 2230, 2231, 2232, 2233, 2234, 2235, 2236, 2237, 2238, 2239, 2240, 2241, 2242, 2243, 2244, 2245, 2246, 2247, 2248, 2249, 2250, 2251, 2252, 2253, 2254, 2255, 2256, 2257, 2258, 2259, 2260, 2261, 2262, 2263, 2264, 2265, 2266, 2267, 2268, 2269, 2270, 2271, 2272, 2273, 2274, 2275, 2276, 2277, 2278, 2279, 2280, 2281, 2282, 2284, 2285, 2286, 2287, 2288, 2289, 2291, 2292, 2293, 2294, 2295, 2296, 2297, 2298, 2299, 2300, 2301, 2302, 2303, 2304, 2305, 2306, 2307, 2308, 2309, 2310, 2311, 2312, 2313, 2314, 2315, 2316, 2317, 2318, 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, 2436, 2437, 2438, 2439, 2441, 2442, 2443, 2444, 2445, 2446, 2447, 2448, 2449, 2450, 2451, 2452, 2453, 2454, 2455, 2456, 2457, 2459, 2460, 2461, 2463, 2464, 2465, 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)) AND t1_.id_tc_structure = 102;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\DecheterieRepository->findAllVisible (line 135)
7	App\Controller\GuideTriController->index (line 60)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

1.72 ms
(9.22%)

SELECT t0.id_tc_ville AS id_tc_ville_1, t0.insee AS insee_2, t0.code_postal AS code_postal_3, t0.nom_ville AS nom_ville_4, t0.is_active AS is_active_5, t0.id_tc_structure AS id_tc_structure_6 FROM tc_ville t0 WHERE t0.id_tc_structure = ?

Parameters:

[
  102
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_tc_ville AS id_tc_ville_1,
  t0.insee AS insee_2,
  t0.code_postal AS code_postal_3,
  t0.nom_ville AS nom_ville_4,
  t0.is_active AS is_active_5,
  t0.id_tc_structure AS id_tc_structure_6
FROM
  tc_ville t0
WHERE
  t0.id_tc_structure = ?

SELECT t0.id_tc_ville AS id_tc_ville_1, t0.insee AS insee_2, t0.code_postal AS code_postal_3, t0.nom_ville AS nom_ville_4, t0.is_active AS is_active_5, t0.id_tc_structure AS id_tc_structure_6 FROM tc_ville t0 WHERE t0.id_tc_structure = 102;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Repository\DecheterieRepository->findAllVisible (line 115)
8	App\Controller\GuideTriController->index (line 60)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

1.64 ms
(8.79%)

SELECT t0.id_tc_structure AS id_tc_structure_1, t0.name AS name_2, t0.acronym AS acronym_3, t0.code_territoire_wastreet_eu AS code_territoire_wastreet_eu_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.logo AS logo_7, t0.tc_agence_id AS tc_agence_id_8, t0.simplicity_vehicle_category_id AS simplicity_vehicle_category_id_9, t10.id_tc_signalement AS id_tc_signalement_11, t10.titre AS titre_12, t10.origine AS origine_13, t10.contrat AS contrat_14, t10.source AS source_15, t10.numero_voie AS numero_voie_16, t10.adresse_complement AS adresse_complement_17, t10.numero_bac AS numero_bac_18, t10.date_incident AS date_incident_19, t10.commentaire AS commentaire_20, t10.suite_a_donner AS suite_a_donner_21, t10.information AS information_22, t10.info_supp AS info_supp_23, t10.date_creation AS date_creation_24, t10.gpso_flux_ou_prestation AS gpso_flux_ou_prestation_25, t10.gpso_chantier AS gpso_chantier_26, t10.is_new_message AS is_new_message_27, t10.is_new_message_by AS is_new_message_by_28, t10.is_new_signalement AS is_new_signalement_29, t10.is_resp_sepure AS is_resp_sepure_30, t10.sygom_email AS sygom_email_31, t10.sygom_name AS sygom_name_32, t10.sygom_firstname AS sygom_firstname_33, t10.sygom_phone AS sygom_phone_34, t10.sygom_type AS sygom_type_35, t10.sygom_productor AS sygom_productor_36, t10.sygom_is_contact_usager AS sygom_is_contact_usager_37, t10.is_sygom AS is_sygom_38, t10.sygom_commentaire AS sygom_commentaire_39, t10.is_from_simplicity AS is_from_simplicity_40, t10.id_simplicity_anomaly AS id_simplicity_anomaly_41, t10.priorite AS priorite_42, t10.lat AS lat_43, t10.lon AS lon_44, t10.icon AS icon_45, t10.simplicity_file_parsed AS simplicity_file_parsed_46, t10.voie AS voie_47, t10.id_tc_ville AS id_tc_ville_48, t10.id_tc_structure AS id_tc_structure_49, t10.id_administre AS id_administre_50, t10.description AS description_51, t10.complement AS complement_52, t10.statut AS statut_53 FROM tc_structure t0 LEFT JOIN tc_signalements t10 ON t10.id_tc_structure = t0.id_tc_structure WHERE t0.id_tc_structure = ?

Parameters:

[
  102
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_tc_structure AS id_tc_structure_1,
  t0.name AS name_2,
  t0.acronym AS acronym_3,
  t0.code_territoire_wastreet_eu AS code_territoire_wastreet_eu_4,
  t0.latitude AS latitude_5,
  t0.longitude AS longitude_6,
  t0.logo AS logo_7,
  t0.tc_agence_id AS tc_agence_id_8,
  t0.simplicity_vehicle_category_id AS simplicity_vehicle_category_id_9,
  t10.id_tc_signalement AS id_tc_signalement_11,
  t10.titre AS titre_12,
  t10.origine AS origine_13,
  t10.contrat AS contrat_14,
  t10.source AS source_15,
  t10.numero_voie AS numero_voie_16,
  t10.adresse_complement AS adresse_complement_17,
  t10.numero_bac AS numero_bac_18,
  t10.date_incident AS date_incident_19,
  t10.commentaire AS commentaire_20,
  t10.suite_a_donner AS suite_a_donner_21,
  t10.information AS information_22,
  t10.info_supp AS info_supp_23,
  t10.date_creation AS date_creation_24,
  t10.gpso_flux_ou_prestation AS gpso_flux_ou_prestation_25,
  t10.gpso_chantier AS gpso_chantier_26,
  t10.is_new_message AS is_new_message_27,
  t10.is_new_message_by AS is_new_message_by_28,
  t10.is_new_signalement AS is_new_signalement_29,
  t10.is_resp_sepure AS is_resp_sepure_30,
  t10.sygom_email AS sygom_email_31,
  t10.sygom_name AS sygom_name_32,
  t10.sygom_firstname AS sygom_firstname_33,
  t10.sygom_phone AS sygom_phone_34,
  t10.sygom_type AS sygom_type_35,
  t10.sygom_productor AS sygom_productor_36,
  t10.sygom_is_contact_usager AS sygom_is_contact_usager_37,
  t10.is_sygom AS is_sygom_38,
  t10.sygom_commentaire AS sygom_commentaire_39,
  t10.is_from_simplicity AS is_from_simplicity_40,
  t10.id_simplicity_anomaly AS id_simplicity_anomaly_41,
  t10.priorite AS priorite_42,
  t10.lat AS lat_43,
  t10.lon AS lon_44,
  t10.icon AS icon_45,
  t10.simplicity_file_parsed AS simplicity_file_parsed_46,
  t10.voie AS voie_47,
  t10.id_tc_ville AS id_tc_ville_48,
  t10.id_tc_structure AS id_tc_structure_49,
  t10.id_administre AS id_administre_50,
  t10.description AS description_51,
  t10.complement AS complement_52,
  t10.statut AS statut_53
FROM
  tc_structure t0
  LEFT JOIN tc_signalements t10 ON t10.id_tc_structure = t0.id_tc_structure
WHERE
  t0.id_tc_structure = ?

SELECT t0.id_tc_structure AS id_tc_structure_1, t0.name AS name_2, t0.acronym AS acronym_3, t0.code_territoire_wastreet_eu AS code_territoire_wastreet_eu_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.logo AS logo_7, t0.tc_agence_id AS tc_agence_id_8, t0.simplicity_vehicle_category_id AS simplicity_vehicle_category_id_9, t10.id_tc_signalement AS id_tc_signalement_11, t10.titre AS titre_12, t10.origine AS origine_13, t10.contrat AS contrat_14, t10.source AS source_15, t10.numero_voie AS numero_voie_16, t10.adresse_complement AS adresse_complement_17, t10.numero_bac AS numero_bac_18, t10.date_incident AS date_incident_19, t10.commentaire AS commentaire_20, t10.suite_a_donner AS suite_a_donner_21, t10.information AS information_22, t10.info_supp AS info_supp_23, t10.date_creation AS date_creation_24, t10.gpso_flux_ou_prestation AS gpso_flux_ou_prestation_25, t10.gpso_chantier AS gpso_chantier_26, t10.is_new_message AS is_new_message_27, t10.is_new_message_by AS is_new_message_by_28, t10.is_new_signalement AS is_new_signalement_29, t10.is_resp_sepure AS is_resp_sepure_30, t10.sygom_email AS sygom_email_31, t10.sygom_name AS sygom_name_32, t10.sygom_firstname AS sygom_firstname_33, t10.sygom_phone AS sygom_phone_34, t10.sygom_type AS sygom_type_35, t10.sygom_productor AS sygom_productor_36, t10.sygom_is_contact_usager AS sygom_is_contact_usager_37, t10.is_sygom AS is_sygom_38, t10.sygom_commentaire AS sygom_commentaire_39, t10.is_from_simplicity AS is_from_simplicity_40, t10.id_simplicity_anomaly AS id_simplicity_anomaly_41, t10.priorite AS priorite_42, t10.lat AS lat_43, t10.lon AS lon_44, t10.icon AS icon_45, t10.simplicity_file_parsed AS simplicity_file_parsed_46, t10.voie AS voie_47, t10.id_tc_ville AS id_tc_ville_48, t10.id_tc_structure AS id_tc_structure_49, t10.id_administre AS id_administre_50, t10.description AS description_51, t10.complement AS complement_52, t10.statut AS statut_53 FROM tc_structure t0 LEFT JOIN tc_signalements t10 ON t10.id_tc_structure = t0.id_tc_structure WHERE t0.id_tc_structure = 102;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Controller\GuideTriController->index (line 46)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.73 ms
(3.89%)

SELECT t0.id AS id_1, t0.server_name AS server_name_2, t0.name AS name_3, t0.extension AS extension_4, t0.mimetype AS mimetype_5, t0.size AS size_6, t0.structure AS structure_7, t0.signalement AS signalement_8 FROM tc_signalements_files t0 WHERE t0.signalement IN (?)

Parameters:

[
  89105
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.server_name AS server_name_2,
  t0.name AS name_3,
  t0.extension AS extension_4,
  t0.mimetype AS mimetype_5,
  t0.size AS size_6,
  t0.structure AS structure_7,
  t0.signalement AS signalement_8
FROM
  tc_signalements_files t0
WHERE
  t0.signalement IN (?)

SELECT t0.id AS id_1, t0.server_name AS server_name_2, t0.name AS name_3, t0.extension AS extension_4, t0.mimetype AS mimetype_5, t0.size AS size_6, t0.structure AS structure_7, t0.signalement AS signalement_8 FROM tc_signalements_files t0 WHERE t0.signalement IN (89105);

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2677)
3	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 2653)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 124)
5	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 177)
6	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
8	Doctrine\ORM\EntityManager->find (line 366)
9	Doctrine\ORM\EntityRepository->find (line 86)
10	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
11	App\Controller\GuideTriController->index (line 46)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 182)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 29)
17	require_once (line 5)

0.72 ms
(3.85%)

SELECT t0.id AS id_1, t0.commentaire_action_a_mener AS commentaire_action_a_mener_2, t0.tc_signalement_id AS tc_signalement_id_3 FROM tc_signalements_traitements t0 WHERE t0.tc_signalement_id = ?

Parameters:

[
  89105
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.commentaire_action_a_mener AS commentaire_action_a_mener_2,
  t0.tc_signalement_id AS tc_signalement_id_3
FROM
  tc_signalements_traitements t0
WHERE
  t0.tc_signalement_id = ?

SELECT t0.id AS id_1, t0.commentaire_action_a_mener AS commentaire_action_a_mener_2, t0.tc_signalement_id AS tc_signalement_id_3 FROM tc_signalements_traitements t0 WHERE t0.tc_signalement_id = 89105;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2458)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 442)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 175)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
10	Doctrine\ORM\EntityManager->find (line 366)
11	Doctrine\ORM\EntityRepository->find (line 86)
12	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
13	App\Controller\GuideTriController->index (line 46)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 182)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 29)
19	require_once (line 5)

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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Dechet	1162
App\Entity\TcVille	296
App\Entity\Decheterie	11
App\Entity\Tc_structure	1
App\Entity\TcSignalements	1
App\Entity\ZonesVoies	1
App\Entity\TcSignalementsDescriptions	1
App\Entity\TcSignalementsComplements	1
App\Entity\TcSignalementsFiles	1
App\Entity\Flux	1

Entities Mapping

Class	Mapping errors
App\Entity\Dechet	No errors.
App\Entity\Decheterie	No errors.
App\Entity\ConsigneDechetDechetterie	No errors.
App\Entity\Tc_structure	The mappings App\Entity\Tc_structure#TcSignalementFile and App\Entity\TcSignalementsFiles#tcStructure are inconsistent with each other.
App\Entity\TcSignalements	No errors.
App\Entity\ZonesVoies	No errors.
App\Entity\TcVille	No errors.
App\Entity\Administre	No errors.
App\Entity\TcSignalementsDescriptions	No errors.
App\Entity\TcSignalementsComplements	No errors.
App\Entity\TcSignalementsStatuts	No errors.
App\Entity\Cout	No errors.
App\Entity\Objectif	No errors.
App\Entity\Tonnage	No errors.
App\Entity\Valorisation	No errors.
App\Entity\Flux	The association App\Entity\Flux#valorisations refers to the owning side field App\Entity\Valorisation#flux which does not exist.
App\Entity\TcSignalementsFiles	The association App\Entity\TcSignalementsFiles#tcStructure refers to the inverse side field App\Entity\Tc_structure#TcSignalement which does not exist.
App\Entity\TcSignalementsStatutsType	No errors.
App\Entity\TcSignalementsTraitements	No errors.
App\Entity\Pav	No errors.
App\Entity\Ramassage	No errors.

Symfony Profiler

GET http://demo-app.wastreet.app/guide-tri

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping