Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.02 ms
(81.64%)
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
  389700
  405468
  413277
  413971
  416751
  417889
  418009
  420226
  422958
  424530
  427187
  434075
  439772
  440426
  443089
  449557
  452953
  454523
  457003
  461004
  465820
  465954
  471464
  474680
  478090
  478575
  480400
  480707
  486341
  486413
  489489
  492338
  495568
  500241
  502369
  509554
  510103
  510880
  511376
  512508
  513782
  523130
  523427
  525243
  528386
  531075
  533697
  534280
  541650
  542189
  542956
  545803
  554742
  555016
  565150
  570118
  574244
  581968
  584474
  588264
  589656
  589681
  590079
  590796
  591784
  595510
  596900
  601559
  602371
  604316
  608037
  608407
  609958
  616336
  616800
  616807
  621125
  621472
  625437
  639742
  642751
  647897
  665672
  681660
  696518
  702061
  712694
  717852
  720480
  724178
  740118
  742817
  742887
  745928
  747194
  747209
  747222
  750115
  750788
  750789
  750790
  789878
  791358
  807927
  809293
  810663
  813532
  814235
  814245
  814746
]
18.94 ms
(12.37%)
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
  590079
  602371
  601559
  465954
  489489
  495568
  747209
  439772
  417889
  814245
  534280
  565150
  665672
  717852
  712694
  443089
  510880
  420226
  616807
  742817
  440426
  405468
  492338
  478575
  696518
  807927
  813532
  724178
  745928
  720480
  413277
  465820
  511376
  454523
  509554
  528386
  533697
  486413
  584474
  596900
  589681
  480400
  750789
  742887
  616336
  642751
  486341
  570118
  809293
  416751
  814746
  639742
  702061
  413971
  434075
  647897
  422958
  418009
  523427
  545803
  681660
  474680
  525243
  513782
  604316
  424530
  500241
  608407
  814235
  478090
  389700
  555016
  621472
  789878
  595510
  512508
  747222
  531075
  452953
  480707
  590796
  457003
  750790
  750115
  750788
  740118
  608037
  461004
  502369
  554742
  589656
  574244
  625437
  542189
  621125
  541650
  542956
  510103
  523130
  588264
  791358
  810663
  747194
  449557
  616800
  609958
  427187
  471464
  581968
  591784
]
2.29 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
  389700
  405468
  413277
  413971
  416751
  417889
  418009
  420226
  422958
  424530
  427187
  434075
  439772
  440426
  443089
  449557
  452953
  454523
  457003
  461004
  465820
  465954
  471464
  474680
  478090
  478575
  480400
  480707
  486341
  486413
  489489
  492338
  495568
  500241
  502369
  509554
  510103
  510880
  511376
  512508
  513782
  523130
  523427
  525243
  528386
  531075
  533697
  534280
  541650
  542189
  542956
  545803
  554742
  555016
  565150
  570118
  574244
  581968
  584474
  588264
  589656
  589681
  590079
  590796
  591784
  595510
  596900
  601559
  602371
  604316
  608037
  608407
  609958
  616336
  616800
  616807
  621125
  621472
  625437
  639742
  642751
  647897
  665672
  681660
  696518
  702061
  712694
  717852
  720480
  724178
  740118
  742817
  742887
  745928
  747194
  747209
  747222
  750115
  750788
  750789
  750790
  789878
  791358
  807927
  809293
  810663
  813532
  814235
  814245
  814746
]
2.14 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "любить анал"
]
1.78 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "люб анал"
]
1.61 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.36 ms
(0.89%)
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.