Forms 0
Symfony 2.5.12
Symfony 2.5.12
Symfony Documentation
PHP
PHP7.1.33
PHP Extensionsxdebugaccel
PHP SAPIfpm-fcgi
Environment 849324 app dev
Nameapp
Environmentdev
Token849324
Request 200 HomeController isLoggedAction on NONE
Status200 OK
ControllerHomeController isLoggedAction
Route nameNONE
Has sessionno
Logs 35
Deprecated Calls 35
Time 1546 ms
Total time 1546 ms
Memory Usage 20.0 MB
Memory usage 20.0 / 128.0 MB
Security
anon.
Logged in as anon.
Authenticated Yes
Token class AnonymousToken
Database 8 in 10.35 ms
DB Queries 8
Query time 10.35 ms
Invalid entities 0

Queries

Connection default

#▲ Time Info
1 1.71 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_vetrina l0_ INNER JOIN [...] WHERE l0_.url_scheda = ? AND [...] 
SELECT 
  l0_.id AS id_0, 
  l0_.created_by AS created_by_1, 
  l0_.updated_by AS updated_by_2, 
  l0_.url_scheda AS url_scheda_3, 
  l0_.stato AS stato_4, 
  l0_.email AS email_5, 
  l0_.premium AS premium_6, 
  l0_.testo AS testo_7, 
  l0_.info_recapito AS info_recapito_8, 
  l0_.fattura AS fattura_9, 
  l0_.edit AS edit_10, 
  l0_.website AS website_11, 
  l0_.data_attivazione AS data_attivazione_12, 
  l0_.stat_user AS stat_user_13, 
  l0_.stat_pwd AS stat_pwd_14, 
  l0_.preview AS preview_15, 
  l0_.nuovo AS nuovo_16, 
  l0_.no_rinnovo AS no_rinnovo_17, 
  l0_.ritardo_pagamento AS ritardo_pagamento_18, 
  l0_.data_pubblicazione AS data_pubblicazione_19, 
  l0_.scadenza AS scadenza_20, 
  l0_.link_scambio AS link_scambio_21, 
  l0_.link_url AS link_url_22, 
  l0_.link_checked AS link_checked_23, 
  l0_.vetrina_tipo_id AS vetrina_tipo_id_24, 
  l0_.data_conferma AS data_conferma_25, 
  l0_.slug AS slug_26, 
  l0_.pubblico AS pubblico_27, 
  l0_.titolo AS titolo_28, 
  l0_.h1 AS h1_29, 
  l0_.h2 AS h2_30, 
  l0_.meta_title AS meta_title_31, 
  l0_.meta_keyword AS meta_keyword_32, 
  l0_.meta_description AS meta_description_33, 
  l0_.descrizione AS descrizione_34, 
  l0_.created_at AS created_at_35, 
  l0_.updated_at AS updated_at_36, 
  l1_.id AS id_37, 
  l1_.old_id AS old_id_38, 
  l1_.limitrofi AS limitrofi_39, 
  l1_.lft AS lft_40, 
  l1_.lvl AS lvl_41, 
  l1_.rgt AS rgt_42, 
  l1_.root AS root_43, 
  l1_.slug AS slug_44, 
  l1_.pubblico AS pubblico_45, 
  l1_.titolo AS titolo_46, 
  l1_.h1 AS h1_47, 
  l1_.h2 AS h2_48, 
  l1_.meta_title AS meta_title_49, 
  l1_.meta_keyword AS meta_keyword_50, 
  l1_.meta_description AS meta_description_51, 
  l1_.descrizione AS descrizione_52, 
  l1_.testo AS testo_53, 
  l1_.created_at AS created_at_54, 
  l1_.updated_at AS updated_at_55, 
  l2_.id AS id_56, 
  l2_.tipo AS tipo_57, 
  l2_.lat AS lat_58, 
  l2_.lon AS lon_59, 
  l2_.old_id AS old_id_60, 
  l2_.url AS url_61, 
  l2_.main AS main_62, 
  l2_.slug AS slug_63, 
  l2_.pubblico AS pubblico_64, 
  l2_.titolo AS titolo_65, 
  l2_.h1 AS h1_66, 
  l2_.h2 AS h2_67, 
  l2_.meta_title AS meta_title_68, 
  l2_.meta_keyword AS meta_keyword_69, 
  l2_.meta_description AS meta_description_70, 
  l2_.descrizione AS descrizione_71, 
  l2_.testo AS testo_72, 
  l2_.created_at AS created_at_73, 
  l2_.updated_at AS updated_at_74, 
  l0_.categoria_id AS categoria_id_75, 
  l0_.geo_id AS geo_id_76, 
  l0_.cliente_id AS cliente_id_77, 
  l0_.recapito_id AS recapito_id_78, 
  l0_.listing_id AS listing_id_79, 
  l0_.boximage_id AS boximage_id_80, 
  l0_.logo_id AS logo_id_81, 
  l0_.vetrina_tipo_id AS vetrina_tipo_id_82, 
  l0_.copertina_id AS copertina_id_83, 
  l1_.padre_id AS padre_id_84, 
  l1_.copertina_id AS copertina_id_85, 
  l2_.regione_id AS regione_id_86, 
  l2_.provincia_id AS provincia_id_87, 
  l2_.copertina_id AS copertina_id_88 
FROM 
  lmn_vetrina l0_ 
  INNER JOIN lmn_categoria l1_ ON l0_.categoria_id = l1_.id 
  INNER JOIN lmn_geo l2_ ON l0_.geo_id = l2_.id 
WHERE 
  l0_.url_scheda = ? 
  AND l1_.slug = ?
 Parameters: [om-salerno-wedding-planner, wedding_planner]
[Display runnable query]
 [ + - Explain query ]
2 0.87 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_premiums_vetrina l0_ WHERE l0_.vetrina_id = ? AND (? [...] 
SELECT 
  l0_.id AS id_0, 
  l0_.service_id AS service_id_1, 
  l0_.quantity AS quantity_2, 
  l0_.used AS used_3, 
  l0_.data_start AS data_start_4, 
  l0_.data_end AS data_end_5, 
  l0_.attivo AS attivo_6, 
  l0_.vetrina_id AS vetrina_id_7, 
  l0_.orderDetail_id AS orderDetail_id_8 
FROM 
  lmn_premiums_vetrina l0_ 
WHERE 
  l0_.vetrina_id = ? 
  AND (
    ? BETWEEN l0_.data_start 
    AND l0_.data_end
  ) 
  AND l0_.quantity > l0_.used
 Parameters: [13097, '2025-04-06 11:28:33']
[Display runnable query]
 [ + - Explain query ]
3 1.39 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_premiums_vetrina l0_ WHERE l0_.vetrina_id = ? AND [...] 
SELECT 
  l0_.id AS id_0, 
  l0_.service_id AS service_id_1, 
  l0_.quantity AS quantity_2, 
  l0_.used AS used_3, 
  l0_.data_start AS data_start_4, 
  l0_.data_end AS data_end_5, 
  l0_.attivo AS attivo_6, 
  l0_.vetrina_id AS vetrina_id_7, 
  l0_.orderDetail_id AS orderDetail_id_8 
FROM 
  lmn_premiums_vetrina l0_ 
WHERE 
  l0_.vetrina_id = ? 
  AND l0_.attivo = ? 
  AND l0_.service_id = ? 
  AND l0_.used < l0_.quantity 
  AND (
    ? BETWEEN l0_.data_start 
    AND l0_.data_end
  )
 Parameters: [13097, 1, vetrina_foto_limit, '2025-04-06 11:28:33']
[Display runnable query]
 [ + - Explain query ]
4 1.58 ms
+ - Shrink query SELECT l0_.id AS [...] FROM lmn_media_foto [...] WHERE l1_.id = ? AND [...] ORDER BY l0_.posizione [...] LIMIT 12 OFFSET 0 
SELECT 
  l0_.id AS id_0, 
  l0_.pubblico AS pubblico_1, 
  l0_.height AS height_2, 
  l0_.width AS width_3, 
  l0_.mime AS mime_4, 
  l0_.size AS size_5, 
  l0_.created_at AS created_at_6, 
  l0_.updated_at AS updated_at_7, 
  l0_.titolo AS titolo_8, 
  l0_.name AS name_9, 
  l0_.path AS path_10, 
  l0_.old_id AS old_id_11, 
  l0_.posizione AS posizione_12 
FROM 
  lmn_media_foto l0_ 
  INNER JOIN lmn_vetrina_foto_rel l2_ ON l0_.id = l2_.mediafoto_id 
  INNER JOIN lmn_vetrina l1_ ON l1_.id = l2_.vetrina_id 
WHERE 
  l1_.id = ? 
  AND l0_.pubblico = ? 
ORDER BY 
  l0_.posizione ASC 
LIMIT 
  12 OFFSET 0
 Parameters: [13097, 1]
[Display runnable query]
 [ + - Explain query ]
5 1.73 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_premiums_vetrina l0_ WHERE l0_.vetrina_id = ? AND [...] 
SELECT 
  l0_.id AS id_0, 
  l0_.service_id AS service_id_1, 
  l0_.quantity AS quantity_2, 
  l0_.used AS used_3, 
  l0_.data_start AS data_start_4, 
  l0_.data_end AS data_end_5, 
  l0_.attivo AS attivo_6, 
  l0_.vetrina_id AS vetrina_id_7, 
  l0_.orderDetail_id AS orderDetail_id_8 
FROM 
  lmn_premiums_vetrina l0_ 
WHERE 
  l0_.vetrina_id = ? 
  AND l0_.attivo = ? 
  AND l0_.service_id = ? 
  AND l0_.used < l0_.quantity 
  AND (
    ? BETWEEN l0_.data_start 
    AND l0_.data_end
  )
 Parameters: [13097, 1, vetrina_foto_limit, '2025-04-06 11:28:33']
[Display runnable query]
 [ + - Explain query ]
6 1.09 ms
+ - Shrink query SELECT count(l0_.id) AS sclr_0 FROM lmn_media_foto l0_ INNER [...] WHERE l1_.id = ? AND l0_.pubblico [...] 
SELECT 
  count(l0_.id) AS sclr_0 
FROM 
  lmn_media_foto l0_ 
  INNER JOIN lmn_vetrina_foto_rel l2_ ON l0_.id = l2_.mediafoto_id 
  INNER JOIN lmn_vetrina l1_ ON l1_.id = l2_.vetrina_id 
WHERE 
  l1_.id = ? 
  AND l0_.pubblico = 1
 Parameters: [13097]
[Display runnable query]
 [ + - Explain query ]
7 1.38 ms
+ - Shrink query SELECT l0_.id AS id_0, [...] FROM lmn_premiums_vetrina l0_ WHERE l0_.vetrina_id = ? AND [...] 
SELECT 
  l0_.id AS id_0, 
  l0_.service_id AS service_id_1, 
  l0_.quantity AS quantity_2, 
  l0_.used AS used_3, 
  l0_.data_start AS data_start_4, 
  l0_.data_end AS data_end_5, 
  l0_.attivo AS attivo_6, 
  l0_.vetrina_id AS vetrina_id_7, 
  l0_.orderDetail_id AS orderDetail_id_8 
FROM 
  lmn_premiums_vetrina l0_ 
WHERE 
  l0_.vetrina_id = ? 
  AND l0_.attivo = ? 
  AND l0_.service_id = ? 
  AND l0_.used < l0_.quantity 
  AND (
    ? BETWEEN l0_.data_start 
    AND l0_.data_end
  )
 Parameters: [13097, 1, vetrina_foto_limit, '2025-04-06 11:28:33']
[Display runnable query]
 [ + - Explain query ]
8 0.61 ms
+ - Shrink query SELECT t0.id AS id_1, t0.pubblico [...] FROM lmn_media_foto t0 WHERE t0.id = ? 
SELECT 
  t0.id AS id_1, 
  t0.pubblico AS pubblico_2, 
  t0.height AS height_3, 
  t0.width AS width_4, 
  t0.mime AS mime_5, 
  t0.size AS size_6, 
  t0.created_at AS created_at_7, 
  t0.updated_at AS updated_at_8, 
  t0.titolo AS titolo_9, 
  t0.name AS name_10, 
  t0.path AS path_11, 
  t0.old_id AS old_id_12, 
  t0.posizione AS posizione_13, 
  t0.album_id AS album_id_14 
FROM 
  lmn_media_foto t0 
WHERE 
  t0.id = ?
 Parameters: [100019]
[Display runnable query]
 [ + - Explain query ]

Database Connections

Key Value
default 
doctrine.dbal.default_connection

Entity Managers

Key Value
default 
doctrine.orm.default_entity_manager

Second Level Cache

Key Value
hits 
0
misses 
0
puts 
0

Mapping

Manager default

Class Mapping errors
Lmn\Admin\AuthBundle\Entity\User Valid
Lmn\OperatoriBundle\Entity\Cliente Valid
Lmn\UserBundle\Entity\User Valid
Lmn\CoreBundle\Entity\Nodo Valid
Lmn\OperatoriBundle\Entity\Vetrina Valid
Lmn\OperatoriBundle\Entity\Categoria Valid
Lmn\OperatoriBundle\Entity\Geo Valid
Lmn\OperatoriBundle\Entity\VetrinaRecapito Valid
Lmn\Cliente\PremiumBundle\Entity\VetrinaPremium Valid
Lmn\MediaBundle\Entity\Media Valid
Lmn\MediaBundle\Entity\MediaFoto Valid
Lmn\OperatoriBundle\Entity\VetrinaTipi Valid
Lmn\OperatoriBundle\Entity\CategoriaGeo Valid
Lmn\OperatoriBundle\Entity\VetrinaTop Valid
Lmn\MediaBundle\Entity\MediaAudio Valid
Lmn\MediaBundle\Entity\MediaVideo Valid
Lmn\Admin\UtilityBundle\Entity\PopUp Valid
Lmn\OperatoriBundle\Entity\Limitrofi Valid
Lmn\Cliente\PremiumBundle\Entity\PremiumOrderDetail Valid
Lmn\Admin\AuthBundle\Entity\Role Valid
Lmn\MediaBundle\Entity\MediaAlbum Valid
Lmn\CoreBundle\Entity\Tag Valid
Lmn\CoreBundle\Entity\Sezione Valid
Lmn\OrganizzazioneBundle\Entity\OrganizzazioneCategoria Valid
Lmn\Admin\UtilityBundle\Entity\PopUpUrl Valid
Lmn\Cliente\PremiumBundle\Entity\PremiumOrder Valid