GET https://app.master-immo.net/finance/treso

Response
200 OK
Browse referrer URL
IP
102.17.52.98
Profiled on
Token
dc829f

Query Metrics

64 Database Queries
10 Different statements
433.40 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
342.24 ms
(78.97%) 		36 
SELECT SUM(pl.restap) AS total_restap
                FROM promesse AS pdv
                LEFT JOIN plande_p AS pl 
                ON pl.pdv_id = pdv.id
                AND pl.datedP BETWEEN DATE_FORMAT(?, '%Y-%m-01')
                        AND LAST_DAY(?)
                AND pl.restap > 0
                WHERE pl.enabled = 1
                AND pdv.recstatus != 'end'
                AND pdv.enabled = 1
                AND (
                    EXISTS (
                        SELECT 1
                        FROM plande_p pl2
                        WHERE pl2.pdv_id = pdv.id
                        AND pl2.tendance = 'M+'
                        AND MONTH(pl2.DatedP) = MONTH(CURDATE()) AND YEAR(pl2.DatedP) = YEAR(CURDATE())
                    )
                )
Parameters: 
[
  "2026-03-06"
  "2026-03-06"
]
View formatted query    View runnable query    Explain query    View query backtrace
23.82 ms
(5.50%) 		20 
SELECT 

                SUM(pl.restap) AS montant

                FROM promesse AS pdv

                LEFT JOIN plande_p AS pl 
                    ON pl.pdv_id = pdv.id
                    AND YEAR(pl.DatedP) = YEAR(CURDATE())
                    AND MONTH(pl.DatedP) = MONTH(CURDATE())

                WHERE pl.enabled = TRUE
                AND pdv.recstatus != 'end'
                AND pdv.locat = ?
                AND pl.tendance != 'M+'
Parameters: 
[
  "AMBATOBE ILAFY ABE"
]
View formatted query    View runnable query    Explain query    View query backtrace
14.94 ms
(3.45%) 		1 
SELECT pdv.locat, 
                SUM(CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 1 MONTH), '%Y-%m')
                        THEN pl.restap ELSE 0 END) AS `Apr-26`
            , 
                SUM(CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 2 MONTH), '%Y-%m')
                        THEN pl.restap ELSE 0 END) AS `May-26`
            , 
                SUM(CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 3 MONTH), '%Y-%m')
                        THEN pl.restap ELSE 0 END) AS `Jun-26`
            , 
                SUM(CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 4 MONTH), '%Y-%m')
                        THEN pl.restap ELSE 0 END) AS `Jul-26`
            , 
                SUM(CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 5 MONTH), '%Y-%m')
                        THEN pl.restap ELSE 0 END) AS `Aug-26`
            , 
                SUM(CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 6 MONTH), '%Y-%m')
                        THEN pl.restap ELSE 0 END) AS `Sep-26`
            , 
                SUM(CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 7 MONTH), '%Y-%m')
                        THEN pl.restap ELSE 0 END) AS `Oct-26`
            , 
                SUM(CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 8 MONTH), '%Y-%m')
                        THEN pl.restap ELSE 0 END) AS `Nov-26`
            , 
                SUM(CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 9 MONTH), '%Y-%m')
                        THEN pl.restap ELSE 0 END) AS `Dec-26`
            , 
                SUM(CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 10 MONTH), '%Y-%m')
                        THEN pl.restap ELSE 0 END) AS `Jan-27`
            , 
                SUM(CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 11 MONTH), '%Y-%m')
                        THEN pl.restap ELSE 0 END) AS `Feb-27`
            , 
                SUM(CASE WHEN DATE_FORMAT(pl.DatedP, '%Y-%m') = DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 12 MONTH), '%Y-%m')
                        THEN pl.restap ELSE 0 END) AS `Mar-27`
            
            FROM promesse pdv
            LEFT JOIN plande_p pl ON pl.pdv_id = pdv.id
            WHERE pl.enabled = TRUE
            AND pdv.recstatus != 'end'
            AND pl.DatedP >= DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 1 MONTH), '%Y-%m-01')
            AND pl.DatedP < DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 13 MONTH), '%Y-%m-01')
            AND pdv.id IN (939,971,989,1022,1047,1057,1065,1068,1071,1072,1073,1074,1077,1098,1102,1110,1115,1119,1136,1139,1141,1144,1146,1150,1159,1160,1161,1162,1163,1165,1171,1176,1186,1189,1191,1193,1196,1197,1198,1204,1206,1208,1211,1212,1214,1219,1220,1226,1227,1230,1231,1233,1235,1236,1238,1241,1242,1245,1248,1249,1255,1258,1261,1262,1265,1266,1268,1269,1270,1272,1273,1277,1278,1279,1280,1281,1282,1283,1284,1049,1056,1078,1079,1080,1081,1083,1100,1104,1130,1151,1154,1158,1166,1167,1168,1169,1170,1173,1178,1188,1207,1224,1232,1240,1246)
            GROUP BY pdv.locat
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
13.08 ms
(3.02%) 		1 
SELECT DISTINCT pl.pdv_id
            FROM plande_p AS pl
            LEFT JOIN promesse AS pdv ON pdv.id = pl.pdv_id
            WHERE pl.enabled = TRUE
            AND pdv.recstatus != 'end'
            AND pdv.enabled = 1
            AND COALESCE((
                SELECT SUM(pl2.restap)
                FROM plande_p pl2
                WHERE pl2.pdv_id = pdv.id
                AND pl2.DatedP BETWEEN DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 1 MONTH), '%Y-%m-01')
                                    AND LAST_DAY(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 3 MONTH))
            ), 0) < COALESCE((
                SELECT SUM(pl2.montant)
                FROM plande_p pl2
                WHERE pl2.pdv_id = pdv.id
                AND pl2.DatedP BETWEEN DATE_FORMAT(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 1 MONTH), '%Y-%m-01')
                                    AND LAST_DAY(DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 3 MONTH))
            ), 0)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
12.45 ms
(2.87%) 		1 
SELECT DISTINCT pl.pdv_id
            FROM plande_p AS pl
            LEFT JOIN promesse AS pdv ON pdv.id = pl.pdv_id
            WHERE pl.enabled = TRUE
            AND pdv.recstatus != 'end'
            AND pdv.enabled = 1
            AND COALESCE((
                SELECT SUM(pl2.restap)
                FROM plande_p pl2
                WHERE pl2.pdv_id = pdv.id
                AND pl2.DatedP BETWEEN DATE_FORMAT(DATE_SUB(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 1 MONTH), '%Y-%m-01')
                                    AND LAST_DAY(DATE_SUB(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 1 MONTH))
            ), 0) = 0
            AND NOT EXISTS (
                SELECT 1
                FROM plande_p pl3
                WHERE pl3.pdv_id = pdv.id
                AND pl3.datedP >= DATE_FORMAT(DATE_SUB(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 2 MONTH), '%Y-%m-01')
                AND pl3.datedP < DATE_FORMAT(DATE_FORMAT(CURDATE(), '%Y-%m-01'), '%Y-%m-01')
                AND pl3.date_t IS NOT NULL
                AND (
                    YEAR(pl3.date_t) > YEAR(pl3.datedP)
                    OR MONTH(pl3.date_t) > MONTH(pl3.datedP)
                )
            )
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
10.37 ms
(2.39%) 		1 
SELECT SUM(pl.restap) AS total_restap
                    FROM promesse AS pdv
                    LEFT JOIN plande_p AS pl 
                        ON pl.pdv_id = pdv.id
                    AND pl.datedP BETWEEN DATE_FORMAT(CURDATE(), '%Y-%m-01')
                                        AND LAST_DAY(CURDATE())
                    AND pl.restap > 0
                    WHERE pl.enabled = 1
                    AND pdv.recstatus != 'end'
                    AND pdv.enabled = 1
                    AND EXISTS (
                        SELECT 1
                        FROM plande_p pl2
                        WHERE pl2.pdv_id = pdv.id
                        AND pl2.restap > 0
                        AND pl2.DatedP < DATE_FORMAT(CURDATE(), '%Y-%m-01')
                    )
                    ;
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
7.34 ms
(1.69%) 		1 
SELECT SUM(pl.restap) AS total_restap
                    FROM promesse AS pdv
                    LEFT JOIN plande_p AS pl 
                        ON pl.pdv_id = pdv.id
                    AND pl.datedP BETWEEN DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL 1 MONTH), '%Y-%m-01')
                                        AND LAST_DAY(DATE_SUB(CURDATE(), INTERVAL 1 MONTH))
                    AND pl.restap > 0
                    WHERE pl.enabled = 1
                    AND pdv.recstatus != 'end'
                    AND pdv.enabled = 1;
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
7.30 ms
(1.69%) 		1 
SELECT pdv.locat
                    FROM plande_p AS pl
                    LEFT JOIN promesse AS pdv ON pdv.id = pl.pdv_id
                    WHERE pl.enabled = true
                    AND pdv.recstatus != 'end'
                    AND pl.restap > 0
                    GROUP BY pdv.locat;
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
1.40 ms
(0.32%) 		1 
SELECT * FROM `treso_prevision` as t
                where 
                MONTH(t.date) = MONTH(CURDATE())
                    AND YEAR(t.date) = YEAR(CURDATE());
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
0.46 ms
(0.11%) 		1 
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = ?
Parameters: 
[
  22
]
View formatted query    View runnable query    Explain query    View query backtrace

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
App\Entity\User No errors.
App\Entity\ContractGroup No errors.
App\Entity\Documentation No errors.
App\Entity\Offre No errors.
App\Entity\Terrain
  • The association App\Entity\Terrain#fournisseur refers to the inverse side field App\Entity\Fournisseur#terrains which does not exist.
App\Entity\TresoPrevision No errors.
App\Entity\Promesse No errors.