Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.59 ms
(80.98%)
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
  378046
  403909
  405921
  406171
  417212
  420192
  420559
  420561
  423375
  425351
  428415
  431446
  432337
  434702
  434712
  446894
  447885
  448445
  453358
  460736
  461576
  461591
  467559
  467581
  474748
  476106
  476259
  477210
  478973
  480429
  481134
  481147
  482824
  485269
  491776
  492215
  493192
  509713
  510588
  510747
  513126
  515131
  517841
  518206
  520448
  523109
  523212
  530024
  530694
  530696
  534027
  536648
  536665
  537210
  537648
  537919
  541646
  541721
  542196
  543425
  545519
  545602
  551225
  551941
  556029
  558134
  558191
  559162
  560299
  561814
  565364
  565366
  565367
  566079
  566112
  567208
  567909
  568305
  568999
  569682
  570426
  571199
  576049
  576113
  577356
  577435
  582821
  583507
  583670
  583700
  583725
  586886
  587651
  588499
  598686
  599862
  600271
  600337
  601094
  601324
  602532
  605453
  606275
  607132
  613832
  619439
  623199
  628117
  630221
  632692
  639716
  640770
  640772
  642775
  647830
  647952
  649546
  656009
  674968
  674995
]
22.49 ms
(13.14%)
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
  642775
  520448
  565366
  606275
  453358
  481134
  513126
  477210
  586886
  542196
  420561
  601324
  566079
  656009
  623199
  476259
  570426
  567909
  576049
  545602
  417212
  461591
  492215
  420559
  551941
  640772
  523109
  482824
  600337
  428415
  420192
  537919
  556029
  565367
  583670
  478973
  510588
  605453
  607132
  481147
  559162
  545519
  561814
  583725
  598686
  588499
  640770
  467559
  425351
  518206
  378046
  405921
  434702
  565364
  582821
  480429
  517841
  406171
  446894
  569682
  649546
  560299
  541721
  567208
  576113
  476106
  403909
  509713
  523212
  536648
  674968
  639716
  571199
  630221
  536665
  537648
  474748
  551225
  647952
  600271
  613832
  461576
  510747
  583507
  448445
  647830
  628117
  602532
  447885
  485269
  434712
  599862
  432337
  632692
  566112
  460736
  587651
  601094
  558134
  493192
  530694
  530024
  537210
  674995
  515131
  467581
  541646
  577435
  619439
  530696
  577356
  568999
  491776
  534027
  583700
  431446
  568305
  543425
  558191
  423375
]
3.08 ms
(1.80%)
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
  378046
  403909
  405921
  406171
  417212
  420192
  420559
  420561
  423375
  425351
  428415
  431446
  432337
  434702
  434712
  446894
  447885
  448445
  453358
  460736
  461576
  461591
  467559
  467581
  474748
  476106
  476259
  477210
  478973
  480429
  481134
  481147
  482824
  485269
  491776
  492215
  493192
  509713
  510588
  510747
  513126
  515131
  517841
  518206
  520448
  523109
  523212
  530024
  530694
  530696
  534027
  536648
  536665
  537210
  537648
  537919
  541646
  541721
  542196
  543425
  545519
  545602
  551225
  551941
  556029
  558134
  558191
  559162
  560299
  561814
  565364
  565366
  565367
  566079
  566112
  567208
  567909
  568305
  568999
  569682
  570426
  571199
  576049
  576113
  577356
  577435
  582821
  583507
  583670
  583700
  583725
  586886
  587651
  588499
  598686
  599862
  600271
  600337
  601094
  601324
  602532
  605453
  606275
  607132
  613832
  619439
  623199
  628117
  630221
  632692
  639716
  640770
  640772
  642775
  647830
  647952
  649546
  656009
  674968
  674995
]
2.33 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "маленькая задница мжм…"
]
1.76 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "маленькая жоп мжм секс втро"
]
1.55 ms
(0.91%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.34 ms
(0.78%)
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.