Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.72 ms
(85.29%)
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
  397294
  398774
  400592
  400923
  401757
  417888
  421394
  431805
  439825
  441004
  443971
  447751
  448414
  450338
  452474
  452634
  456198
  469432
  473766
  473969
  474264
  475000
  478548
  486084
  489417
  491457
  511481
  513780
  517841
  521253
  522190
  530698
  534112
  534600
  534748
  535639
  539020
  540846
  541686
  544186
  544535
  545449
  547400
  547471
  547527
  549799
  552500
  556346
  561730
  566845
  567122
  568546
  568893
  568938
  569260
  571166
  571357
  572709
  576225
  578392
  582303
  584348
  590562
  592323
  594531
  595545
  598874
  600540
  603847
  605850
  609772
  615663
  617592
  619783
  626684
  628258
  643671
  655601
  655811
  660467
  666434
  669721
  671020
  685478
  685502
  688404
  709922
  713927
  715584
  715808
  720328
  720442
  720883
  730038
  731213
  735112
  739531
  746555
  752709
  756822
  767315
  767326
  777940
  778935
  778949
  781585
  787952
  789871
  790069
  793202
  793982
  800303
  800531
  804327
  810125
  818753
  825955
  826624
  827601
  827883
]
13.30 ms
(8.81%)
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
  810125
  752709
  715808
  789871
  804327
  400923
  400592
  671020
  800531
  767315
  598874
  522190
  544186
  576225
  582303
  547400
  715584
  655601
  666434
  567122
  605850
  617592
  628258
  592323
  787952
  790069
  767326
  735112
  730038
  746555
  603847
  800303
  552500
  572709
  615663
  619783
  398774
  793202
  441004
  535639
  818753
  556346
  731213
  827601
  826624
  521253
  568893
  571357
  720442
  720328
  781585
  793982
  756822
  534600
  541686
  401757
  713927
  452474
  569260
  549799
  590562
  443971
  517841
  827883
  534112
  539020
  584348
  688404
  685478
  685502
  655811
  669721
  595545
  777940
  397294
  545449
  566845
  660467
  709922
  643671
  778935
  720883
  473969
  475000
  448414
  469432
  474264
  489417
  609772
  540846
  600540
  626684
  578392
  568546
  431805
  447751
  478548
  417888
  491457
  513780
  825955
  561730
  473766
  439825
  534748
  456198
  530698
  544535
  778949
  450338
  547527
  452634
  511481
  568938
  547471
  571166
  594531
  739531
  486084
  421394
]
2.47 ms
(1.63%)
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
  397294
  398774
  400592
  400923
  401757
  417888
  421394
  431805
  439825
  441004
  443971
  447751
  448414
  450338
  452474
  452634
  456198
  469432
  473766
  473969
  474264
  475000
  478548
  486084
  489417
  491457
  511481
  513780
  517841
  521253
  522190
  530698
  534112
  534600
  534748
  535639
  539020
  540846
  541686
  544186
  544535
  545449
  547400
  547471
  547527
  549799
  552500
  556346
  561730
  566845
  567122
  568546
  568893
  568938
  569260
  571166
  571357
  572709
  576225
  578392
  582303
  584348
  590562
  592323
  594531
  595545
  598874
  600540
  603847
  605850
  609772
  615663
  617592
  619783
  626684
  628258
  643671
  655601
  655811
  660467
  666434
  669721
  671020
  685478
  685502
  688404
  709922
  713927
  715584
  715808
  720328
  720442
  720883
  730038
  731213
  735112
  739531
  746555
  752709
  756822
  767315
  767326
  777940
  778935
  778949
  781585
  787952
  789871
  790069
  793202
  793982
  800303
  800531
  804327
  810125
  818753
  825955
  826624
  827601
  827883
]
1.84 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "анал частное худая"
]
1.64 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал любительск худая"
]
1.55 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал любительск худая"
]
1.40 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.