Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.30 ms
(86.09%)
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
  79293
  128784
  276646
  385564
  386322
  386965
  388819
  392974
  395410
  396399
  397345
  400128
  400839
  404503
  407993
  408435
  409390
  410855
  411654
  412518
  413233
  414220
  417904
  418134
  419847
  421735
  423462
  425005
  426318
  426808
  428920
  430696
  432889
  440788
  443707
  447303
  447638
  447745
  448052
  448077
  448177
  450237
  453106
  454302
  454310
  456398
  456742
  460346
  460986
  461162
  462554
  465209
  465983
  467342
  467365
  467380
  467386
  468470
  468693
  469493
  469646
  472066
  472399
  472557
  473470
  474302
  477116
  477399
  478999
  479138
  479780
  479878
  482262
  482664
  482909
  485017
  486805
  487297
  490187
  497253
  498218
  498355
  501716
  502753
  503822
  507487
  508582
  512409
  513267
  513704
  518285
  519256
  519484
  521452
  523048
  528817
  546925
  552168
  559393
  560535
  560594
  568361
  569915
  570437
  570994
  591975
  601958
  634858
  654329
  656453
  717944
  719159
  730199
  732029
  757090
  761829
  775564
  775601
  790469
  803386
]
14.67 ms
(8.13%)
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
  388819
  396399
  400128
  400839
  440788
  419847
  413233
  417904
  423462
  418134
  425005
  428920
  432889
  410855
  411654
  430696
  453106
  465209
  474302
  477116
  479780
  482664
  486805
  450237
  456398
  460346
  467342
  472399
  490187
  487297
  518285
  502753
  507487
  523048
  498218
  461162
  467365
  468693
  469493
  546925
  560535
  569915
  570437
  552168
  559393
  560594
  570994
  568361
  634858
  601958
  757090
  732029
  761829
  717944
  790469
  407993
  421735
  447745
  456742
  472066
  473470
  395410
  397345
  404503
  409390
  426808
  462554
  477399
  479138
  479878
  412518
  448052
  460986
  467380
  478999
  414220
  426318
  443707
  447638
  454302
  454310
  472557
  482262
  447303
  448077
  448177
  465983
  467386
  468470
  469646
  501716
  519256
  482909
  513704
  519484
  512409
  485017
  497253
  498355
  503822
  508582
  513267
  521452
  528817
  386322
  385564
  128784
  392974
  276646
  79293
  386965
  408435
  654329
  656453
  719159
  591975
  775564
  775601
  803386
  730199
]
3.02 ms
(1.67%)
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
  79293
  128784
  276646
  385564
  386322
  386965
  388819
  392974
  395410
  396399
  397345
  400128
  400839
  404503
  407993
  408435
  409390
  410855
  411654
  412518
  413233
  414220
  417904
  418134
  419847
  421735
  423462
  425005
  426318
  426808
  428920
  430696
  432889
  440788
  443707
  447303
  447638
  447745
  448052
  448077
  448177
  450237
  453106
  454302
  454310
  456398
  456742
  460346
  460986
  461162
  462554
  465209
  465983
  467342
  467365
  467380
  467386
  468470
  468693
  469493
  469646
  472066
  472399
  472557
  473470
  474302
  477116
  477399
  478999
  479138
  479780
  479878
  482262
  482664
  482909
  485017
  486805
  487297
  490187
  497253
  498218
  498355
  501716
  502753
  503822
  507487
  508582
  512409
  513267
  513704
  518285
  519256
  519484
  521452
  523048
  528817
  546925
  552168
  559393
  560535
  560594
  568361
  569915
  570437
  570994
  591975
  601958
  634858
  654329
  656453
  717944
  719159
  730199
  732029
  757090
  761829
  775564
  775601
  790469
  803386
]
2.21 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "вылизывает после"
]
1.89 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "лиза посл"
]
1.70 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(0.89%)
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.