Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.91 ms
(88.02%)
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
  426666
  470851
  493427
  514274
  514380
  514568
  516845
  524404
  531887
  541870
  550324
  551589
  552998
  558219
  558804
  559094
  559100
  562920
  576428
  578093
  581089
  583694
  590740
  599513
  601349
  601675
  605281
  605844
  606565
  618415
  618540
  618853
  619774
  621524
  624857
  626165
  626734
  633722
  645194
  649087
  650213
  652766
  657562
  657631
  657966
  662066
  662080
  666476
  667230
  670782
  671523
  671591
  675784
  677028
  686860
  687318
  692383
  693403
  693567
  706411
  709947
  714140
  716583
  717620
  719040
  719602
  721118
  721137
  721206
  721310
  721341
  721364
  725891
  729065
  730674
  731933
  733847
  733852
  741950
  745385
  747938
  754487
  754541
  754574
  755389
  760453
  760925
  763236
  769907
  771141
  774447
  777506
  777667
  786050
  787179
  787219
  788167
  788175
  788247
  788750
  789949
  790038
  796986
  797854
  797916
  798014
  799784
  800010
  801036
  802596
  806064
  806878
  808379
  811075
  811311
  811629
  812907
  814083
  814282
  815123
]
12.24 ms
(6.74%)
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
  755389
  769907
  760925
  721137
  788175
  789949
  657631
  605844
  618853
  774447
  814083
  815123
  559100
  551589
  562920
  692383
  719040
  721364
  657562
  621524
  797916
  799784
  806064
  811629
  777506
  777667
  788167
  729065
  745385
  760453
  808379
  811075
  725891
  730674
  754487
  754541
  606565
  786050
  787179
  811311
  493427
  670782
  650213
  814282
  531887
  541870
  578093
  649087
  675784
  716583
  719602
  686860
  666476
  601349
  619774
  624857
  599513
  626734
  800010
  801036
  763236
  733852
  754574
  721341
  790038
  812907
  426666
  470851
  514274
  514380
  524404
  671591
  645194
  693403
  657966
  677028
  721310
  605281
  618415
  618540
  788247
  788750
  787219
  796986
  798014
  802596
  806878
  731933
  733847
  747938
  771141
  741950
  633722
  797854
  516845
  514568
  581089
  550324
  590740
  626165
  601675
  558804
  558219
  583694
  559094
  576428
  552998
  652766
  662066
  671523
  717620
  721118
  662080
  667230
  706411
  714140
  721206
  687318
  693567
  709947
]
2.72 ms
(1.50%)
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
  426666
  470851
  493427
  514274
  514380
  514568
  516845
  524404
  531887
  541870
  550324
  551589
  552998
  558219
  558804
  559094
  559100
  562920
  576428
  578093
  581089
  583694
  590740
  599513
  601349
  601675
  605281
  605844
  606565
  618415
  618540
  618853
  619774
  621524
  624857
  626165
  626734
  633722
  645194
  649087
  650213
  652766
  657562
  657631
  657966
  662066
  662080
  666476
  667230
  670782
  671523
  671591
  675784
  677028
  686860
  687318
  692383
  693403
  693567
  706411
  709947
  714140
  716583
  717620
  719040
  719602
  721118
  721137
  721206
  721310
  721341
  721364
  725891
  729065
  730674
  731933
  733847
  733852
  741950
  745385
  747938
  754487
  754541
  754574
  755389
  760453
  760925
  763236
  769907
  771141
  774447
  777506
  777667
  786050
  787179
  787219
  788167
  788175
  788247
  788750
  789949
  790038
  796986
  797854
  797916
  798014
  799784
  800010
  801036
  802596
  806064
  806878
  808379
  811075
  811311
  811629
  812907
  814083
  814282
  815123
]
1.89 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "татуированные крошки"
]
1.83 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "татуированные крошк"
]
1.58 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.82%)
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.