Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.44 ms
(85.09%)
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
  391557
  392600
  400513
  413090
  414594
  422203
  440537
  441003
  452329
  454185
  454527
  455343
  455392
  462705
  462711
  464771
  465434
  465534
  466310
  466756
  468363
  470560
  470596
  470654
  472609
  472691
  477135
  479128
  479143
  481254
  484405
  484586
  484607
  484629
  485985
  486813
  488954
  490396
  494184
  495326
  502885
  504211
  506142
  506865
  510771
  510855
  510877
  516477
  517816
  518912
  520872
  521134
  523674
  523833
  526450
  528355
  530289
  534134
  534683
  535441
  535445
  536431
  540799
  545535
  549720
  549825
  555116
  555119
  556901
  563246
  565303
  571399
  587846
  590331
  590498
  590613
  591131
  605742
  616152
  620215
  620228
  620258
  627064
  628661
  672903
  686383
  697249
  712563
  721074
  725170
  733319
  735929
  736307
  741690
  741751
  741759
  741764
  741772
  741777
  741778
  741781
  741788
  742349
  742385
  742407
  742556
  745952
  746713
  752131
  757541
  758281
  761147
  761604
  781753
  792643
  799917
  805140
  805666
  827220
  828553
]
14.70 ms
(8.48%)
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
  506865
  516477
  510855
  534683
  517816
  523833
  526450
  742385
  506142
  485985
  752131
  799917
  414594
  477135
  462705
  672903
  697249
  712563
  556901
  628661
  590331
  620258
  620228
  627064
  741772
  741777
  741778
  741788
  746713
  792643
  735929
  736307
  725170
  742349
  742556
  745952
  741781
  757541
  741759
  761147
  466756
  481254
  465434
  486813
  523674
  470596
  392600
  528355
  510877
  521134
  479143
  549825
  452329
  484607
  587846
  620215
  472691
  536431
  440537
  484586
  761604
  518912
  400513
  530289
  571399
  413090
  454185
  391557
  549720
  686383
  781753
  741690
  721074
  590498
  758281
  510771
  565303
  741751
  742407
  555116
  555119
  590613
  733319
  741764
  455343
  472609
  520872
  494184
  454527
  540799
  466310
  591131
  422203
  502885
  616152
  441003
  484629
  535441
  470560
  455392
  488954
  490396
  805666
  465534
  464771
  534134
  545535
  805140
  563246
  484405
  504211
  605742
  462711
  470654
  535445
  495326
  479128
  827220
  828553
  468363
]
2.69 ms
(1.55%)
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
  391557
  392600
  400513
  413090
  414594
  422203
  440537
  441003
  452329
  454185
  454527
  455343
  455392
  462705
  462711
  464771
  465434
  465534
  466310
  466756
  468363
  470560
  470596
  470654
  472609
  472691
  477135
  479128
  479143
  481254
  484405
  484586
  484607
  484629
  485985
  486813
  488954
  490396
  494184
  495326
  502885
  504211
  506142
  506865
  510771
  510855
  510877
  516477
  517816
  518912
  520872
  521134
  523674
  523833
  526450
  528355
  530289
  534134
  534683
  535441
  535445
  536431
  540799
  545535
  549720
  549825
  555116
  555119
  556901
  563246
  565303
  571399
  587846
  590331
  590498
  590613
  591131
  605742
  616152
  620215
  620228
  620258
  627064
  628661
  672903
  686383
  697249
  712563
  721074
  725170
  733319
  735929
  736307
  741690
  741751
  741759
  741764
  741772
  741777
  741778
  741781
  741788
  742349
  742385
  742407
  742556
  745952
  746713
  752131
  757541
  758281
  761147
  761604
  781753
  792643
  799917
  805140
  805666
  827220
  828553
]
2.39 ms
(1.38%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.23 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жена зрелая русская"
]
2.14 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен зрелая женщин русск"
]
1.68 ms
(0.97%)
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.