Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.63 ms
(82.30%)
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
  286389
  358566
  365885
  401049
  402677
  410090
  411030
  420467
  428418
  428643
  429713
  431954
  440624
  442168
  443716
  447489
  454273
  462539
  462548
  464531
  466159
  466316
  470161
  470322
  470340
  473240
  473969
  474007
  474044
  474567
  475801
  475916
  477398
  478009
  478332
  481291
  482743
  483377
  483388
  485565
  490923
  491084
  491210
  496219
  498003
  501892
  502092
  502222
  504279
  510624
  511739
  521144
  522662
  523535
  526432
  526434
  528178
  538207
  538406
  539126
  545725
  552216
  552580
  552592
  555689
  556848
  559374
  559715
  559717
  563448
  563449
  564431
  564661
  569070
  569097
  569134
  569140
  571629
  574828
  576046
  576337
  583997
  592758
  595870
  596604
  597528
  597940
  598552
  598813
  601958
  603661
  609263
  612509
  619870
  624616
  651940
  652172
  652202
  659258
  659305
  660307
  665771
  678374
  679091
  679120
  679700
  697333
  704044
  714486
  723540
  724440
  725314
  740226
  748336
  762513
  766274
  776285
  777241
  797799
  805216
]
23.94 ms
(12.74%)
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
  510624
  539126
  470161
  447489
  502092
  596604
  474007
  470322
  477398
  723540
  428418
  511739
  474567
  481291
  491084
  552580
  678374
  679700
  659258
  697333
  660307
  679091
  679120
  559717
  624616
  609263
  805216
  748336
  619870
  776285
  365885
  474044
  420467
  429713
  766274
  358566
  559715
  576337
  563448
  740226
  473240
  401049
  464531
  556848
  714486
  598552
  777241
  725314
  762513
  612509
  475916
  521144
  574828
  569140
  652172
  797799
  601958
  443716
  483388
  576046
  462539
  595870
  501892
  552592
  651940
  652202
  659305
  665771
  470340
  454273
  538406
  552216
  490923
  597940
  475801
  286389
  402677
  569097
  442168
  478009
  526434
  538207
  564661
  569070
  473969
  522662
  724440
  559374
  563449
  491210
  592758
  504279
  466316
  704044
  523535
  466159
  462548
  485565
  502222
  482743
  555689
  569134
  440624
  410090
  583997
  496219
  545725
  597528
  428643
  478332
  526432
  528178
  598813
  571629
  564431
  603661
  431954
  483377
  498003
  411030
]
2.50 ms
(1.33%)
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
  286389
  358566
  365885
  401049
  402677
  410090
  411030
  420467
  428418
  428643
  429713
  431954
  440624
  442168
  443716
  447489
  454273
  462539
  462548
  464531
  466159
  466316
  470161
  470322
  470340
  473240
  473969
  474007
  474044
  474567
  475801
  475916
  477398
  478009
  478332
  481291
  482743
  483377
  483388
  485565
  490923
  491084
  491210
  496219
  498003
  501892
  502092
  502222
  504279
  510624
  511739
  521144
  522662
  523535
  526432
  526434
  528178
  538207
  538406
  539126
  545725
  552216
  552580
  552592
  555689
  556848
  559374
  559715
  559717
  563448
  563449
  564431
  564661
  569070
  569097
  569134
  569140
  571629
  574828
  576046
  576337
  583997
  592758
  595870
  596604
  597528
  597940
  598552
  598813
  601958
  603661
  609263
  612509
  619870
  624616
  651940
  652172
  652202
  659258
  659305
  660307
  665771
  678374
  679091
  679120
  679700
  697333
  704044
  714486
  723540
  724440
  725314
  740226
  748336
  762513
  766274
  776285
  777241
  797799
  805216
]
2.10 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ебля руских жмж"
]
1.64 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс русск жмж секс втро"
]
1.43 ms
(0.76%)
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.