Query Metrics

7 Database Queries
7 Different statements
383.34 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
360.05 ms
(93.93%)
1
SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  395450
  403948
  418562
  435602
  458552
  470621
  470659
  482770
  492296
  495889
  504028
  508102
  509365
  509949
  510309
  513809
  514346
  530197
  530208
  533152
  534102
  534901
  535865
  536009
  536132
  536824
  537417
  537990
  538619
  540561
  545159
  547529
  550274
  550303
  553443
  554072
  555725
  556239
  557587
  558094
  559311
  561016
  567613
  567617
  572978
  573134
  573454
  576252
  577128
  583346
  587117
  587523
  588035
  588096
  588328
  589277
  589307
  592142
  592306
  593798
  594063
  594412
  596603
  596818
  600331
  600699
  601986
  602269
  604563
  604687
  612152
  616138
  617387
  618334
  627493
  627495
  628569
  636483
  639528
  642951
  644008
  653051
  661920
  663155
  665332
  668140
  670557
  671256
  672774
  677534
  683078
  684693
  686384
  690726
  691171
  698238
  700476
  707415
  710827
  712948
  715862
  716153
  729856
  735777
  739787
  740058
  744777
  745486
  745789
  748395
  749753
  752458
  770365
  782455
  782555
  784168
  787054
  794272
  795368
  799774
]
13.02 ms
(3.40%)
1
SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  612152
  698238
  707415
  470621
  537990
  716153
  587523
  715862
  710827
  593798
  787054
  729856
  745789
  735777
  748395
  784168
  403948
  739787
  617387
  592142
  588096
  418562
  567613
  795368
  782455
  794272
  770365
  749753
  594063
  712948
  513809
  576252
  663155
  573454
  596818
  604563
  594412
  509365
  534102
  537417
  538619
  540561
  508102
  530197
  530208
  536824
  534901
  536132
  558094
  583346
  557587
  683078
  665332
  671256
  677534
  690726
  653051
  670557
  567617
  572978
  589307
  592306
  596603
  636483
  587117
  589277
  600699
  628569
  600331
  627493
  642951
  644008
  604687
  616138
  627495
  639528
  514346
  504028
  495889
  618334
  691171
  588328
  510309
  533152
  547529
  559311
  550274
  668140
  395450
  492296
  470659
  509949
  536009
  556239
  561016
  545159
  554072
  577128
  588035
  740058
  744777
  799774
  745486
  752458
  782555
  550303
  555725
  482770
  553443
  601986
  700476
  535865
  602269
  573134
  661920
  684693
  672774
  686384
  435602
  458552
]
3.21 ms
(0.84%)
1
SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  395450
  403948
  418562
  435602
  458552
  470621
  470659
  482770
  492296
  495889
  504028
  508102
  509365
  509949
  510309
  513809
  514346
  530197
  530208
  533152
  534102
  534901
  535865
  536009
  536132
  536824
  537417
  537990
  538619
  540561
  545159
  547529
  550274
  550303
  553443
  554072
  555725
  556239
  557587
  558094
  559311
  561016
  567613
  567617
  572978
  573134
  573454
  576252
  577128
  583346
  587117
  587523
  588035
  588096
  588328
  589277
  589307
  592142
  592306
  593798
  594063
  594412
  596603
  596818
  600331
  600699
  601986
  602269
  604563
  604687
  612152
  616138
  617387
  618334
  627493
  627495
  628569
  636483
  639528
  642951
  644008
  653051
  661920
  663155
  665332
  668140
  670557
  671256
  672774
  677534
  683078
  684693
  686384
  690726
  691171
  698238
  700476
  707415
  710827
  712948
  715862
  716153
  729856
  735777
  739787
  740058
  744777
  745486
  745789
  748395
  749753
  752458
  770365
  782455
  782555
  784168
  787054
  794272
  795368
  799774
]
2.11 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade mobile"
]
2.06 ms
(0.54%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.41%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск телефон"
]
1.31 ms
(0.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск телефон"
]

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

No loaded entities.