Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
168.53 ms
(87.13%)
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
  153618
  382713
  384416
  390966
  393865
  398019
  405507
  429561
  446286
  460205
  466733
  468629
  469061
  478107
  480553
  481874
  482207
  485887
  486252
  510287
  513728
  518312
  523352
  527151
  527249
  532094
  540363
  557527
  569415
  570150
  571508
  574561
  584872
  588262
  599589
  599795
  601234
  629844
  630233
  682181
  704716
  721140
  724227
  730059
  730085
  732065
  733614
  733817
  736154
  737064
  737072
  738861
  741303
  743392
  743986
  744796
  744925
  745034
  746772
  747919
  747927
  752896
  755002
  756311
  760613
  768912
  769993
  771599
  772713
  777439
  779705
  784304
  785662
  789972
  789982
  792564
  793538
  794980
  795144
  797769
  797781
  797844
  799386
  800257
  801334
  803007
  803289
  803548
  804591
  804961
  805440
  806944
  807411
  807792
  808127
  809723
  810642
  813788
  813789
  814344
  814626
  815288
  815352
  815678
  816941
  817174
  817539
  817942
  818550
  819482
  820120
  820334
  821007
  821010
  822585
  823001
  823051
  823243
]
13.93 ms
(7.20%)
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
  797769
  797844
  800257
  801334
  803007
  804961
  805440
  806944
  807411
  737064
  744796
  747927
  730059
  730085
  733614
  744925
  746772
  752896
  755002
  769993
  771220
  732065
  741303
  743986
  745034
  771599
  771983
  724227
  733817
  736154
  737072
  738861
  747919
  756311
  760613
  768912
  772713
  704716
  777439
  779705
  785662
  789972
  789982
  792564
  793538
  795144
  797781
  799386
  803289
  803548
  804591
  807792
  808127
  810642
  390966
  384416
  599589
  405507
  468629
  480553
  446286
  527151
  518312
  682181
  571508
  601234
  784304
  469061
  393865
  478107
  481874
  523352
  513728
  486252
  510287
  527249
  466733
  569415
  429561
  153618
  398019
  813789
  821010
  482207
  460205
  540363
  485887
  599795
  630233
  743392
  721140
  794980
  382713
  814626
  532094
  570150
  584872
  574561
  557527
  588262
  629844
  809723
  813788
  814344
  815288
  815352
  815678
  816941
  817174
  817539
  817942
  818550
  819482
  820120
  820334
  821007
  822585
  823001
  823051
  823243
]
3.79 ms
(1.96%)
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
  153618
  382713
  384416
  390966
  393865
  398019
  405507
  429561
  446286
  460205
  466733
  468629
  469061
  478107
  480553
  481874
  482207
  485887
  486252
  510287
  513728
  518312
  523352
  527151
  527249
  532094
  540363
  557527
  569415
  570150
  571508
  574561
  584872
  588262
  599589
  599795
  601234
  629844
  630233
  682181
  704716
  721140
  724227
  730059
  730085
  732065
  733614
  733817
  736154
  737064
  737072
  738861
  741303
  743392
  743986
  744796
  744925
  745034
  746772
  747919
  747927
  752896
  755002
  756311
  760613
  768912
  769993
  771599
  772713
  777439
  779705
  784304
  785662
  789972
  789982
  792564
  793538
  794980
  795144
  797769
  797781
  797844
  799386
  800257
  801334
  803007
  803289
  803548
  804591
  804961
  805440
  806944
  807411
  807792
  808127
  809723
  810642
  813788
  813789
  814344
  814626
  815288
  815352
  815678
  816941
  817174
  817539
  817942
  818550
  819482
  820120
  820334
  821007
  821010
  822585
  823001
  823051
  823243
]
2.12 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.00 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "tattoo mom"
]
1.63 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "татуированные mom"
]
1.41 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "татуированные mom"
]

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.