Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.12 ms
(84.28%)
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
  81174
  92249
  231164
  384013
  384525
  396973
  404318
  405978
  419558
  424546
  425535
  433406
  436539
  443482
  444211
  445216
  445306
  452676
  453895
  454862
  457684
  473605
  478979
  479229
  480378
  482993
  483882
  486201
  489357
  492310
  499785
  505933
  507584
  508298
  509390
  512033
  513156
  519735
  522669
  523303
  534951
  535893
  543876
  549267
  553607
  560105
  564855
  573319
  574125
  583405
  586068
  611039
  611296
  613784
  616858
  625088
  625141
  629667
  635208
  639282
  643423
  645965
  649293
  653491
  662191
  671316
  671516
  677135
  679067
  679532
  682494
  682846
  687374
  688307
  688336
  693355
  697289
  700065
  703308
  705102
  711755
  713105
  721211
  722071
  723524
  727716
  728162
  730477
  737971
  743196
  746708
  747417
  761959
  762090
  762243
  768155
  768861
  771489
  772850
  778323
  778326
  779925
  783794
  783858
  788444
  795371
  800408
  801784
  802892
  807792
  812720
  813596
  813938
  814084
  814091
  819185
  819963
  822665
  825078
  827250
]
12.52 ms
(8.43%)
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
  771489
  762243
  727716
  747417
  772850
  625141
  700065
  713105
  722071
  800408
  801784
  807792
  424546
  574125
  687374
  688336
  783858
  743196
  499785
  814084
  814091
  827250
  486201
  523303
  549267
  679532
  697289
  671516
  639282
  768861
  384525
  445216
  445306
  522669
  564855
  443482
  507584
  384013
  433406
  723524
  813596
  819185
  478979
  535893
  505933
  534951
  492310
  543876
  662191
  682846
  693355
  649293
  711755
  677135
  721211
  553607
  573319
  586068
  611296
  613784
  629667
  611039
  635208
  616858
  643423
  783794
  812720
  778323
  778326
  779925
  788444
  802892
  728162
  761959
  762090
  746708
  730477
  737971
  768155
  703308
  795371
  81174
  436539
  405978
  425535
  452676
  457684
  473605
  625088
  454862
  480378
  483882
  519735
  489357
  508298
  513156
  404318
  819963
  419558
  92249
  231164
  396973
  444211
  825078
  822665
  813938
  453895
  482993
  479229
  509390
  512033
  560105
  583405
  645965
  679067
  682494
  705102
  688307
  653491
  671316
]
3.89 ms
(2.62%)
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
  81174
  92249
  231164
  384013
  384525
  396973
  404318
  405978
  419558
  424546
  425535
  433406
  436539
  443482
  444211
  445216
  445306
  452676
  453895
  454862
  457684
  473605
  478979
  479229
  480378
  482993
  483882
  486201
  489357
  492310
  499785
  505933
  507584
  508298
  509390
  512033
  513156
  519735
  522669
  523303
  534951
  535893
  543876
  549267
  553607
  560105
  564855
  573319
  574125
  583405
  586068
  611039
  611296
  613784
  616858
  625088
  625141
  629667
  635208
  639282
  643423
  645965
  649293
  653491
  662191
  671316
  671516
  677135
  679067
  679532
  682494
  682846
  687374
  688307
  688336
  693355
  697289
  700065
  703308
  705102
  711755
  713105
  721211
  722071
  723524
  727716
  728162
  730477
  737971
  743196
  746708
  747417
  761959
  762090
  762243
  768155
  768861
  771489
  772850
  778323
  778326
  779925
  783794
  783858
  788444
  795371
  800408
  801784
  802892
  807792
  812720
  813596
  813938
  814084
  814091
  819185
  819963
  822665
  825078
  827250
]
1.90 ms
(1.28%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(1.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк спящ"
]
1.72 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girl sleep"
]
1.52 ms
(1.03%)
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.