Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.27 ms
(83.12%)
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
  118237
  154157
  346188
  382404
  383742
  388642
  391994
  393326
  394639
  400791
  414077
  414292
  416697
  419891
  432674
  435539
  440995
  445470
  446002
  448090
  448431
  452574
  456240
  460209
  466475
  466639
  467195
  468665
  471455
  471654
  473437
  484809
  487200
  493535
  500290
  506105
  511864
  512442
  512543
  520797
  525603
  527409
  529347
  530503
  531107
  531871
  532727
  534534
  534537
  534563
  534586
  536470
  537864
  541278
  545294
  545428
  547474
  547490
  550900
  553646
  555008
  564514
  568261
  568514
  573204
  578319
  583665
  583921
  591021
  592440
  597239
  599834
  599922
  601789
  609639
  617807
  622693
  628094
  628112
  629934
  632121
  632623
  639071
  641685
  651674
  656904
  660399
  662046
  662423
  669362
  671049
  672939
  680195
  701445
  715790
  722388
  722393
  722428
  728385
  733582
  735195
  737605
  738814
  743890
  745026
  748961
  752767
  761429
  761646
  770225
  770276
  782806
  788767
  792706
  799007
  799693
  802114
  806543
  808331
  825878
]
18.16 ms
(11.08%)
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
  722388
  487200
  383742
  435539
  745026
  715790
  651674
  440995
  393326
  701445
  532727
  414077
  382404
  530503
  573204
  547474
  599834
  743890
  728385
  629934
  446002
  553646
  799007
  394639
  609639
  388642
  656904
  799693
  752767
  770276
  802114
  471654
  391994
  445470
  597239
  737605
  599922
  547490
  506105
  792706
  555008
  419891
  460209
  500290
  448090
  825878
  511864
  512543
  662046
  536470
  534563
  641685
  118237
  448431
  537864
  346188
  550900
  806543
  761646
  617807
  722393
  545428
  583921
  432674
  738814
  578319
  466639
  473437
  628112
  529347
  671049
  416697
  534586
  525603
  672939
  466475
  592440
  471455
  568514
  400791
  601789
  622693
  770225
  154157
  531871
  628094
  788767
  468665
  520797
  512442
  639071
  782806
  733582
  735195
  808331
  414292
  541278
  660399
  748961
  632623
  456240
  527409
  662423
  467195
  484809
  669362
  591021
  761429
  632121
  680195
  583665
  493535
  531107
  452574
  534537
  534534
  545294
  722428
  564514
  568261
]
2.93 ms
(1.79%)
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
  118237
  154157
  346188
  382404
  383742
  388642
  391994
  393326
  394639
  400791
  414077
  414292
  416697
  419891
  432674
  435539
  440995
  445470
  446002
  448090
  448431
  452574
  456240
  460209
  466475
  466639
  467195
  468665
  471455
  471654
  473437
  484809
  487200
  493535
  500290
  506105
  511864
  512442
  512543
  520797
  525603
  527409
  529347
  530503
  531107
  531871
  532727
  534534
  534537
  534563
  534586
  536470
  537864
  541278
  545294
  545428
  547474
  547490
  550900
  553646
  555008
  564514
  568261
  568514
  573204
  578319
  583665
  583921
  591021
  592440
  597239
  599834
  599922
  601789
  609639
  617807
  622693
  628094
  628112
  629934
  632121
  632623
  639071
  641685
  651674
  656904
  660399
  662046
  662423
  669362
  671049
  672939
  680195
  701445
  715790
  722388
  722393
  722428
  728385
  733582
  735195
  737605
  738814
  743890
  745026
  748961
  752767
  761429
  761646
  770225
  770276
  782806
  788767
  792706
  799007
  799693
  802114
  806543
  808331
  825878
]
1.77 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal fisting stockings"
]
1.71 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал фистинг чулк нижн бел"
]
1.60 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.51 ms
(0.92%)
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.