Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
185.00 ms
(84.22%)
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
  469
  13428
  105845
  212012
  285684
  369890
  382194
  383726
  384258
  385475
  386939
  387765
  392043
  392665
  395344
  395439
  398477
  400540
  411197
  411462
  418148
  420719
  425113
  426020
  426798
  439350
  441353
  441796
  443210
  444078
  445642
  445818
  453479
  453690
  453761
  456153
  456224
  456972
  458068
  458934
  460711
  465196
  466904
  467082
  467907
  473476
  476093
  480994
  482711
  490413
  492013
  493277
  493285
  495646
  497184
  499953
  500004
  507104
  507249
  507281
  515619
  516493
  516633
  518379
  518506
  519600
  521137
  523457
  535263
  535437
  537963
  539735
  539940
  549165
  550240
  553715
  558894
  567307
  575840
  579612
  581376
  581577
  585438
  588710
  596580
  597690
  605234
  615515
  617250
  618118
  620828
  644192
  646702
  675123
  675139
  675441
  675692
  675725
  683420
  685073
  688523
  697457
  697765
  705326
  728075
  735902
  742754
  761598
  765920
  766114
  768615
  769460
  778532
  780771
  784510
  794112
  797134
  806596
  813472
  814499
]
15.52 ms
(7.07%)
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
  523457
  516633
  617250
  766114
  453479
  495646
  769460
  675692
  558894
  535263
  644192
  392665
  476093
  480994
  575840
  768615
  395344
  507104
  439350
  675139
  392043
  465196
  742754
  398477
  597690
  444078
  518379
  445818
  411462
  105845
  456224
  539735
  697457
  443210
  453761
  515619
  426798
  780771
  685073
  735902
  605234
  441796
  458934
  467082
  383726
  369890
  384258
  697765
  705326
  794112
  778532
  813472
  765920
  728075
  385475
  646702
  458068
  675123
  467907
  675441
  473476
  585438
  615515
  453690
  500004
  507281
  521137
  518506
  441353
  411197
  482711
  507249
  539940
  460711
  567307
  456972
  456153
  519600
  493285
  499953
  581376
  382194
  806596
  784510
  445642
  549165
  212012
  285684
  581577
  420719
  596580
  516493
  618118
  425113
  620828
  426020
  493277
  400540
  814499
  797134
  469
  386939
  387765
  13428
  537963
  490413
  395439
  683420
  688523
  675725
  466904
  550240
  588710
  761598
  492013
  553715
  497184
  535437
  418148
  579612
]
11.16 ms
(5.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
3.13 ms
(1.42%)
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
  469
  13428
  105845
  212012
  285684
  369890
  382194
  383726
  384258
  385475
  386939
  387765
  392043
  392665
  395344
  395439
  398477
  400540
  411197
  411462
  418148
  420719
  425113
  426020
  426798
  439350
  441353
  441796
  443210
  444078
  445642
  445818
  453479
  453690
  453761
  456153
  456224
  456972
  458068
  458934
  460711
  465196
  466904
  467082
  467907
  473476
  476093
  480994
  482711
  490413
  492013
  493277
  493285
  495646
  497184
  499953
  500004
  507104
  507249
  507281
  515619
  516493
  516633
  518379
  518506
  519600
  521137
  523457
  535263
  535437
  537963
  539735
  539940
  549165
  550240
  553715
  558894
  567307
  575840
  579612
  581376
  581577
  585438
  588710
  596580
  597690
  605234
  615515
  617250
  618118
  620828
  644192
  646702
  675123
  675139
  675441
  675692
  675725
  683420
  685073
  688523
  697457
  697765
  705326
  728075
  735902
  742754
  761598
  765920
  766114
  768615
  769460
  778532
  780771
  784510
  794112
  797134
  806596
  813472
  814499
]
2.24 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "раком в трус"
]
1.47 ms
(0.67%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рак в трусик нижн бел"
]
1.14 ms
(0.52%)
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.