Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.20 ms
(80.32%)
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
  346141
  391393
  415978
  416032
  416738
  420394
  420835
  424593
  427539
  428223
  428231
  431485
  439056
  441110
  441131
  442510
  445727
  446407
  446778
  447315
  448791
  451358
  452540
  452637
  459203
  459429
  460716
  466731
  466991
  468680
  469087
  470405
  473213
  475052
  475335
  475646
  478510
  481935
  483711
  497667
  497693
  500324
  500327
  505137
  505597
  505599
  505800
  506321
  507956
  510532
  512346
  513576
  514085
  514257
  515571
  529988
  531823
  533519
  533554
  534567
  536377
  536783
  540928
  541278
  541755
  542124
  542709
  547236
  547467
  547485
  547847
  547855
  556338
  556876
  561273
  571166
  576493
  584183
  586557
  587407
  588514
  590281
  590299
  595145
  596610
  599834
  602241
  609582
  618259
  628106
  630564
  632046
  632588
  634026
  634068
  636982
  639729
  639762
  646884
  647914
  649546
  649579
  656921
  660410
  666490
  666880
  669026
  670357
  672954
  678099
  709628
  728385
  736302
  741247
  748961
  752626
  788181
  788767
  805144
  825514
]
18.76 ms
(12.75%)
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
  447315
  468680
  510532
  415978
  473213
  500324
  531823
  709628
  634068
  420835
  547855
  618259
  788181
  736302
  428231
  515571
  541278
  556338
  561273
  672954
  678099
  752626
  741247
  748961
  639729
  497667
  646884
  649546
  825514
  459429
  547236
  576493
  670357
  584183
  634026
  636982
  586557
  590299
  505597
  505599
  427539
  439056
  500327
  536377
  542124
  540928
  666490
  571166
  596610
  431485
  470405
  505800
  507956
  346141
  424593
  445727
  506321
  514257
  469087
  541755
  656921
  669026
  391393
  536783
  666880
  441110
  441131
  428223
  446778
  452637
  475646
  481935
  448791
  466731
  478510
  512346
  547847
  556876
  599834
  728385
  788767
  460716
  416032
  483711
  632588
  632046
  513576
  533519
  534567
  529988
  542709
  547467
  547485
  660410
  649579
  647914
  590281
  639762
  805144
  416738
  420394
  442510
  446407
  451358
  466991
  475052
  514085
  497693
  505137
  533554
  475335
  587407
  602241
  588514
  609582
  630564
  595145
  628106
  459203
  452540
]
2.32 ms
(1.57%)
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
  346141
  391393
  415978
  416032
  416738
  420394
  420835
  424593
  427539
  428223
  428231
  431485
  439056
  441110
  441131
  442510
  445727
  446407
  446778
  447315
  448791
  451358
  452540
  452637
  459203
  459429
  460716
  466731
  466991
  468680
  469087
  470405
  473213
  475052
  475335
  475646
  478510
  481935
  483711
  497667
  497693
  500324
  500327
  505137
  505597
  505599
  505800
  506321
  507956
  510532
  512346
  513576
  514085
  514257
  515571
  529988
  531823
  533519
  533554
  534567
  536377
  536783
  540928
  541278
  541755
  542124
  542709
  547236
  547467
  547485
  547847
  547855
  556338
  556876
  561273
  571166
  576493
  584183
  586557
  587407
  588514
  590281
  590299
  595145
  596610
  599834
  602241
  609582
  618259
  628106
  630564
  632046
  632588
  634026
  634068
  636982
  639729
  639762
  646884
  647914
  649546
  649579
  656921
  660410
  666490
  666880
  669026
  670357
  672954
  678099
  709628
  728385
  736302
  741247
  748961
  752626
  788181
  788767
  805144
  825514
]
2.15 ms
(1.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "фистинг девушк"
]
2.09 ms
(1.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fisting girls"
]
1.88 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.