Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.89 ms
(82.35%)
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
  408326
  410950
  419407
  420386
  420910
  423484
  423495
  425730
  430066
  430103
  434355
  436937
  437476
  438466
  442746
  443205
  443492
  443619
  446353
  446932
  447848
  448924
  449012
  449821
  451753
  453802
  455687
  457186
  457650
  457972
  459557
  459717
  460421
  460988
  462207
  462865
  469569
  472447
  475405
  477000
  481083
  485414
  487146
  487654
  487932
  488776
  488852
  490758
  491194
  493349
  494814
  496454
  499164
  499194
  499734
  501015
  502257
  510287
  510851
  515178
  516444
  516969
  520161
  521650
  522995
  523760
  525685
  527203
  527592
  527844
  528234
  529219
  536115
  544206
  552067
  552407
  558072
  561155
  562118
  565099
  567503
  567761
  570860
  573411
  574240
  575380
  575505
  576959
  577583
  581532
  583576
  585096
  588258
  599524
  599974
  601425
  601894
  602199
  603725
  604286
  615281
  616472
  617865
  618544
  619389
  619994
  630576
  646219
  646920
  649730
  655275
  716540
  751512
  760468
  761201
  775015
  810119
  813110
  814242
  814253
]
18.59 ms
(11.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
  581532
  487146
  446932
  419407
  430103
  446353
  443205
  443492
  448924
  575380
  438466
  447848
  515178
  430066
  408326
  567761
  460988
  436937
  457650
  655275
  574240
  615281
  462865
  521650
  420386
  618544
  423484
  443619
  601425
  434355
  490758
  501015
  477000
  449012
  576959
  455687
  522995
  814253
  813110
  751512
  481083
  562118
  603725
  493349
  510851
  410950
  649730
  499164
  494814
  544206
  457972
  488852
  601894
  604286
  516444
  575505
  567503
  561155
  570860
  619389
  588258
  619994
  599524
  617865
  423495
  552067
  459557
  525685
  499194
  469569
  814242
  646219
  630576
  775015
  453802
  487654
  523760
  496454
  485414
  573411
  810119
  520161
  761201
  449821
  488776
  527844
  616472
  516969
  577583
  602199
  459717
  491194
  510287
  420910
  565099
  599974
  462207
  502257
  646920
  472447
  529219
  585096
  475405
  442746
  457186
  527203
  583576
  760468
  425730
  437476
  528234
  499734
  451753
  527592
  460421
  558072
  487932
  536115
  716540
  552407
]
3.13 ms
(1.93%)
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
  408326
  410950
  419407
  420386
  420910
  423484
  423495
  425730
  430066
  430103
  434355
  436937
  437476
  438466
  442746
  443205
  443492
  443619
  446353
  446932
  447848
  448924
  449012
  449821
  451753
  453802
  455687
  457186
  457650
  457972
  459557
  459717
  460421
  460988
  462207
  462865
  469569
  472447
  475405
  477000
  481083
  485414
  487146
  487654
  487932
  488776
  488852
  490758
  491194
  493349
  494814
  496454
  499164
  499194
  499734
  501015
  502257
  510287
  510851
  515178
  516444
  516969
  520161
  521650
  522995
  523760
  525685
  527203
  527592
  527844
  528234
  529219
  536115
  544206
  552067
  552407
  558072
  561155
  562118
  565099
  567503
  567761
  570860
  573411
  574240
  575380
  575505
  576959
  577583
  581532
  583576
  585096
  588258
  599524
  599974
  601425
  601894
  602199
  603725
  604286
  615281
  616472
  617865
  618544
  619389
  619994
  630576
  646219
  646920
  649730
  655275
  716540
  751512
  760468
  761201
  775015
  810119
  813110
  814242
  814253
]
1.89 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.81 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "little девушк секс"
]
1.77 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "little girl fuck"
]
1.51 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "little девушк секс"
]

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.