Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.07 ms
(82.14%)
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
  398958
  401956
  409113
  415241
  415846
  422155
  424873
  425531
  428814
  430444
  430828
  433669
  439214
  439620
  439621
  439672
  439730
  439787
  440614
  443563
  443737
  445201
  445393
  446088
  446299
  450319
  450336
  450766
  452297
  453304
  453438
  455265
  457856
  460159
  460924
  461016
  465356
  466180
  466757
  468072
  470031
  475249
  475263
  477579
  479144
  481650
  483001
  483152
  483417
  484554
  484562
  484581
  484653
  484775
  485271
  486198
  486536
  486678
  488074
  489275
  489471
  489947
  492298
  496100
  499883
  503066
  504411
  504922
  507047
  508701
  509164
  509384
  514295
  517114
  517240
  519936
  520407
  520445
  523141
  524296
  526008
  526087
  528089
  531064
  532022
  532079
  542969
  543088
  549650
  549822
  555182
  556470
  557499
  560211
  560512
  561468
  561478
  561515
  562964
  565153
  565659
  572653
  577491
  578067
  580913
  582468
  586980
  588078
  589574
  591632
  603852
  613319
  617040
  621352
  626367
  667647
  798684
  807399
  807953
  808060
]
19.76 ms
(11.84%)
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
  483152
  499883
  617040
  621352
  439620
  443737
  445201
  422155
  468072
  514295
  520407
  484653
  486678
  520445
  532022
  439621
  439672
  439730
  555182
  582468
  509164
  486536
  443563
  450336
  453304
  457856
  450319
  509384
  517114
  531064
  532079
  484775
  488074
  489947
  542969
  549650
  561468
  556470
  557499
  560512
  572653
  543088
  549822
  562964
  578067
  603852
  591632
  586980
  808060
  466180
  475263
  428814
  445393
  479144
  460924
  465356
  466757
  452297
  470031
  450766
  477579
  517240
  526008
  484562
  485271
  489471
  503066
  519936
  561515
  430828
  484581
  483417
  496100
  486198
  589574
  475249
  430444
  484554
  528089
  401956
  492298
  415241
  424873
  455265
  461016
  523141
  524296
  508701
  483001
  580913
  565659
  667647
  560211
  626367
  588078
  613319
  807953
  807399
  798684
  433669
  415846
  440614
  439214
  481650
  439787
  489275
  526087
  507047
  561478
  565153
  504922
  504411
  425531
  409113
  446299
  446088
  460159
  398958
  453438
  577491
]
2.90 ms
(1.74%)
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
  398958
  401956
  409113
  415241
  415846
  422155
  424873
  425531
  428814
  430444
  430828
  433669
  439214
  439620
  439621
  439672
  439730
  439787
  440614
  443563
  443737
  445201
  445393
  446088
  446299
  450319
  450336
  450766
  452297
  453304
  453438
  455265
  457856
  460159
  460924
  461016
  465356
  466180
  466757
  468072
  470031
  475249
  475263
  477579
  479144
  481650
  483001
  483152
  483417
  484554
  484562
  484581
  484653
  484775
  485271
  486198
  486536
  486678
  488074
  489275
  489471
  489947
  492298
  496100
  499883
  503066
  504411
  504922
  507047
  508701
  509164
  509384
  514295
  517114
  517240
  519936
  520407
  520445
  523141
  524296
  526008
  526087
  528089
  531064
  532022
  532079
  542969
  543088
  549650
  549822
  555182
  556470
  557499
  560211
  560512
  561468
  561478
  561515
  562964
  565153
  565659
  572653
  577491
  578067
  580913
  582468
  586980
  588078
  589574
  591632
  603852
  613319
  617040
  621352
  626367
  667647
  798684
  807399
  807953
  808060
]
2.18 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf boy sleep"
]
1.70 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf парен спящ"
]
1.59 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf парен спящ"
]

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.