Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.60 ms
(83.42%)
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
  6976
  379330
  383356
  388219
  396106
  399016
  410657
  417482
  418450
  420345
  424791
  425316
  425353
  437855
  443649
  446198
  446856
  447904
  448121
  448215
  448864
  459527
  464650
  465605
  467632
  468754
  475724
  477464
  481143
  481151
  482727
  500431
  506143
  506762
  508179
  512057
  512781
  515329
  516666
  517932
  521805
  522883
  523190
  524846
  530500
  531136
  535505
  537654
  540572
  540575
  540785
  541202
  544827
  545611
  547523
  555847
  558437
  562796
  566035
  569929
  583503
  586398
  594584
  597121
  597246
  599994
  600296
  600355
  601040
  604497
  604574
  605461
  612726
  615961
  619199
  621426
  629330
  630280
  630765
  630866
  632021
  632978
  633124
  633796
  633806
  634115
  634116
  634153
  634198
  634782
  637143
  642060
  646025
  646242
  647830
  647879
  647952
  672710
  674968
  675002
  676024
  676097
  681298
  681313
  687257
  696579
  719841
  719857
  731663
  732319
  732326
  740779
  742428
  743836
  750060
  788570
  800331
  811826
  817096
  818793
]
17.95 ms
(10.22%)
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
  447904
  642060
  646242
  475724
  443649
  388219
  535505
  687257
  696579
  600355
  633124
  383356
  500431
  634115
  448864
  512781
  516666
  681298
  632021
  743836
  517932
  558437
  410657
  459527
  524846
  634782
  788570
  647830
  740779
  506143
  417482
  418450
  530500
  512057
  531136
  477464
  481143
  540575
  600296
  506762
  547523
  482727
  467632
  681313
  541202
  555847
  750060
  634116
  601040
  676024
  521805
  448215
  732326
  446856
  481151
  675002
  446198
  583503
  544827
  630765
  633806
  540785
  719841
  537654
  674968
  545611
  515329
  676097
  465605
  647879
  637143
  597246
  425353
  633796
  562796
  437855
  646025
  424791
  647952
  615961
  540572
  817096
  396106
  468754
  604497
  672710
  508179
  634153
  719857
  800331
  522883
  742428
  379330
  732319
  6976
  629330
  605461
  464650
  630280
  599994
  811826
  632978
  399016
  425316
  612726
  604574
  621426
  619199
  566035
  818793
  731663
  597121
  634198
  523190
  569929
  630866
  586398
  594584
  420345
  448121
]
3.58 ms
(2.03%)
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
  6976
  379330
  383356
  388219
  396106
  399016
  410657
  417482
  418450
  420345
  424791
  425316
  425353
  437855
  443649
  446198
  446856
  447904
  448121
  448215
  448864
  459527
  464650
  465605
  467632
  468754
  475724
  477464
  481143
  481151
  482727
  500431
  506143
  506762
  508179
  512057
  512781
  515329
  516666
  517932
  521805
  522883
  523190
  524846
  530500
  531136
  535505
  537654
  540572
  540575
  540785
  541202
  544827
  545611
  547523
  555847
  558437
  562796
  566035
  569929
  583503
  586398
  594584
  597121
  597246
  599994
  600296
  600355
  601040
  604497
  604574
  605461
  612726
  615961
  619199
  621426
  629330
  630280
  630765
  630866
  632021
  632978
  633124
  633796
  633806
  634115
  634116
  634153
  634198
  634782
  637143
  642060
  646025
  646242
  647830
  647879
  647952
  672710
  674968
  675002
  676024
  676097
  681298
  681313
  687257
  696579
  719841
  719857
  731663
  732319
  732326
  740779
  742428
  743836
  750060
  788570
  800331
  811826
  817096
  818793
]
2.13 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "bbc blowjob anal"
]
2.06 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "bbc минет оральн секс анал"
]
1.67 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "bbc минет оральн секс анал"
]

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.