Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.61 ms
(79.89%)
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
  391147
  417408
  418165
  421580
  421591
  423499
  424116
  424199
  424387
  425339
  432637
  439710
  441290
  442634
  443069
  445646
  446849
  446872
  447828
  449697
  452456
  453734
  455687
  456458
  456695
  456809
  457683
  458471
  459865
  461848
  462760
  462854
  463858
  465239
  465863
  466392
  466808
  467731
  471991
  473051
  474279
  476520
  481343
  483321
  484228
  485998
  496495
  502616
  504906
  510126
  510478
  510855
  510881
  513371
  514357
  514402
  516256
  517405
  518231
  521102
  523021
  525411
  525682
  526241
  536949
  540656
  548254
  550841
  558206
  558886
  559548
  560442
  562763
  562964
  564001
  564541
  566854
  568981
  569546
  571257
  572961
  584779
  587397
  588649
  590076
  590759
  591082
  598190
  599002
  614833
  616869
  620116
  624127
  624320
  639873
  672897
  712774
  723131
  730599
  731552
  740787
  743488
  765279
  765313
  773856
  782516
  784167
  787471
  788355
  788806
  790409
  790844
  795698
  796184
  797110
  797119
  806802
  809413
  813084
  818247
]
19.03 ms
(12.71%)
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
  456458
  462854
  417408
  462760
  513371
  510881
  510126
  795698
  743488
  514402
  461848
  517405
  740787
  562763
  584779
  818247
  442634
  466808
  496495
  712774
  806802
  790409
  796184
  797119
  773856
  639873
  418165
  787471
  559548
  571257
  572961
  730599
  439710
  504906
  510855
  423499
  425339
  443069
  459865
  510478
  465863
  569546
  624320
  453734
  525411
  731552
  616869
  540656
  536949
  788355
  525682
  432637
  452456
  466392
  446872
  481343
  564001
  620116
  809413
  424116
  447828
  473051
  424199
  441290
  518231
  502616
  614833
  784167
  564541
  624127
  550841
  765313
  723131
  813084
  456695
  521102
  590759
  463858
  421580
  484228
  797110
  458471
  446849
  449697
  455687
  548254
  456809
  457683
  485998
  560442
  568981
  562964
  599002
  590076
  587397
  474279
  421591
  445646
  471991
  424387
  514357
  672897
  765279
  391147
  591082
  526241
  566854
  558886
  598190
  782516
  483321
  516256
  523021
  558206
  788806
  465239
  588649
  790844
  467731
  476520
]
3.71 ms
(2.48%)
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
  391147
  417408
  418165
  421580
  421591
  423499
  424116
  424199
  424387
  425339
  432637
  439710
  441290
  442634
  443069
  445646
  446849
  446872
  447828
  449697
  452456
  453734
  455687
  456458
  456695
  456809
  457683
  458471
  459865
  461848
  462760
  462854
  463858
  465239
  465863
  466392
  466808
  467731
  471991
  473051
  474279
  476520
  481343
  483321
  484228
  485998
  496495
  502616
  504906
  510126
  510478
  510855
  510881
  513371
  514357
  514402
  516256
  517405
  518231
  521102
  523021
  525411
  525682
  526241
  536949
  540656
  548254
  550841
  558206
  558886
  559548
  560442
  562763
  562964
  564001
  564541
  566854
  568981
  569546
  571257
  572961
  584779
  587397
  588649
  590076
  590759
  591082
  598190
  599002
  614833
  616869
  620116
  624127
  624320
  639873
  672897
  712774
  723131
  730599
  731552
  740787
  743488
  765279
  765313
  773856
  782516
  784167
  787471
  788355
  788806
  790409
  790844
  795698
  796184
  797110
  797119
  806802
  809413
  813084
  818247
]
2.31 ms
(1.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal cum pov"
]
1.99 ms
(1.33%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал cum пов"
]
1.48 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал cum пов"
]

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.