2.31 ms (52.66%)
6
SELECT t0 . id AS id_1 , t0 . login AS login_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . prenom AS prenom_5 , t0 . nom AS nom_6 , t0 . datedenaissance AS datedenaissance_7 , t0 . lieudenaissance AS lieudenaissance_8 , t0 . adresse AS adresse_9 , t0 . contact AS contact_10 , t0 . rib AS rib_11 , t0 . siret AS siret_12 , t0 . securitesociale AS securitesociale_13 , t0 . email AS email_14 , t0 . contacturgence AS contacturgence_15 , t0 . contacturgencetel AS contacturgencetel_16 , t0 . photo AS photo_17 , t0 . permis AS permis_18 , t0 . autres AS autres_19 , t20 . id AS id_21 , t20 . nom_structure AS nom_structure_22 , t20 . type_structure AS type_structure_23 , t20 . types_projet AS types_projet_24 , t20 . volume_vehicule AS volume_vehicule_25 , t20 . manutention AS manutention_26 , t20 . adresse AS adresse_27 , t20 . nom_contact AS nom_contact_28 , t20 . email_contact AS email_contact_29 , t20 . telephone_contact AS telephone_contact_30 , t20 . site_web AS site_web_31 , t20 . linkedin AS linkedin_32 , t20 . ressources AS ressources_33 , t20 . details AS details_34 , t20 . validation AS validation_35 , t20 . user_id AS user_id_36 , t37 . id AS id_38 , t37 . quantites AS quantites_39 , t37 . proprietaire_id AS proprietaire_id_40 FROM `user` t0 LEFT JOIN filiere t20 ON t20 . user_id = t0 . id LEFT JOIN panier t37 ON t37 . proprietaire_id = t0 . id WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . login AS login_2 , t0 . roles AS roles_3 , t0 . password AS password_4 , t0 . prenom AS prenom_5 , t0 . nom AS nom_6 , t0 . datedenaissance AS datedenaissance_7 , t0 . lieudenaissance AS lieudenaissance_8 , t0 . adresse AS adresse_9 , t0 . contact AS contact_10 , t0 . rib AS rib_11 , t0 . siret AS siret_12 , t0 . securitesociale AS securitesociale_13 , t0 . email AS email_14 , t0 . contacturgence AS contacturgence_15 , t0 . contacturgencetel AS contacturgencetel_16 , t0 . photo AS photo_17 , t0 . permis AS permis_18 , t0 . autres AS autres_19 , t20 . id AS id_21 , t20 . nom_structure AS nom_structure_22 , t20 . type_structure AS type_structure_23 , t20 . types_projet AS types_projet_24 , t20 . volume_vehicule AS volume_vehicule_25 , t20 . manutention AS manutention_26 , t20 . adresse AS adresse_27 , t20 . nom_contact AS nom_contact_28 , t20 . email_contact AS email_contact_29 , t20 . telephone_contact AS telephone_contact_30 , t20 . site_web AS site_web_31 , t20 . linkedin AS linkedin_32 , t20 . ressources AS ressources_33 , t20 . details AS details_34 , t20 . validation AS validation_35 , t20 . user_id AS user_id_36 , t37 . id AS id_38 , t37 . quantites AS quantites_39 , t37 . proprietaire_id AS proprietaire_id_40 FROM `user` t0 LEFT JOIN filiere t20 ON t20 . user_id = t0 . id LEFT JOIN panier t37 ON t37 . proprietaire_id = t0 . id WHERE t0 . id = 17 ;
Copy
0.91 ms (20.63%)
1
SELECT s0_ . id AS id_0 , s0_ . type_localisation AS type_localisation_1 , s0_ . localisation AS localisation_2 , s0_ . commentaire AS commentaire_3 , s0_ . date_creation AS date_creation_4 , s0_ . evenement_id AS evenement_id_5 , s0_ . created_by_id AS created_by_id_6 FROM suivi_photo s0_ WHERE s0_ . id IN (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
Parameters :
[
394
396
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
422
423
424
426
427
428
429
430
431
432
433
434
435
436
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
469
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
502
503
]
SELECT
s0_ . id AS id_0 ,
s0_ . type_localisation AS type_localisation_1 ,
s0_ . localisation AS localisation_2 ,
s0_ . commentaire AS commentaire_3 ,
s0_ . date_creation AS date_creation_4 ,
s0_ . evenement_id AS evenement_id_5 ,
s0_ . created_by_id AS created_by_id_6
FROM
suivi_photo s0_
WHERE
s0_ . id IN (
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ,
? , ? , ? , ? , ? , ? , ? , ? , ?
)
Copy
SELECT s0_ . id AS id_0 , s0_ . type_localisation AS type_localisation_1 , s0_ . localisation AS localisation_2 , s0_ . commentaire AS commentaire_3 , s0_ . date_creation AS date_creation_4 , s0_ . evenement_id AS evenement_id_5 , s0_ . created_by_id AS created_by_id_6 FROM suivi_photo s0_ WHERE s0_ . id IN (394 , 396 , 398 , 399 , 400 , 401 , 402 , 403 , 404 , 405 , 406 , 407 , 408 , 409 , 410 , 411 , 412 , 413 , 414 , 415 , 416 , 417 , 418 , 419 , 420 , 422 , 423 , 424 , 426 , 427 , 428 , 429 , 430 , 431 , 432 , 433 , 434 , 435 , 436 , 439 , 440 , 441 , 442 , 443 , 444 , 445 , 446 , 447 , 448 , 449 , 450 , 451 , 452 , 453 , 454 , 455 , 456 , 457 , 458 , 459 , 460 , 461 , 462 , 463 , 464 , 465 , 466 , 467 , 469 , 471 , 472 , 473 , 474 , 475 , 476 , 477 , 478 , 479 , 480 , 481 , 482 , 483 , 484 , 485 , 486 , 487 , 488 , 489 , 490 , 491 , 492 , 493 , 494 , 495 , 496 , 497 , 498 , 499 , 502 , 503 );
Copy