Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.83 ms
(85.19%)
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
  33715
  58636
  66217
  68618
  197442
  203742
  210349
  219957
  234067
  382085
  382318
  393274
  407830
  408435
  408912
  429491
  479724
  521449
  532577
  533506
  533820
  536490
  537741
  542858
  546477
  613819
  631332
  643975
  644200
  644255
  646248
  648742
  651253
  672378
  673125
  682602
  684917
  690461
  693064
  714169
  720528
  723750
  723983
  724261
  726325
  726580
  729674
  736029
  736051
  736459
  738081
  738104
  745196
  746673
  749362
  749376
  749393
  750843
  752221
  752252
  752259
  752353
  752896
  752924
  756369
  757447
  760112
  767484
  768411
  769326
  770536
  772329
  774627
  775523
  776685
  776867
  777811
  781343
  782636
  784180
  787335
  788152
  788349
  789053
  790808
  797861
  798311
  799144
  799160
  800714
  801237
  802409
  802574
  802634
  805949
  807623
  812980
  813851
  814557
  816955
  817021
  817710
  818171
  818287
  818593
  819081
  819250
  820015
  820142
  821108
  822814
  822919
  823130
  824654
  825521
  827886
  827905
  827911
]
13.31 ms
(8.29%)
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
  746673
  760112
  772329
  768411
  736051
  787335
  807623
  210349
  197442
  817710
  824654
  818171
  820142
  827905
  827911
  537741
  542858
  646248
  672378
  682602
  684917
  644200
  774627
  729674
  752896
  631332
  802574
  66217
  673125
  723750
  724261
  782636
  802634
  736459
  644255
  752221
  749362
  767484
  736029
  738104
  818287
  818593
  819250
  822814
  825521
  816955
  817021
  819081
  820015
  822919
  823130
  813851
  821108
  827886
  479724
  521449
  533506
  546477
  720528
  648742
  690461
  693064
  643975
  776867
  799144
  776744
  781343
  749376
  752353
  770536
  784180
  788152
  789053
  790808
  797861
  726580
  738081
  755279
  745196
  750843
  752252
  752259
  757447
  749393
  756369
  776685
  777811
  788349
  799160
  613819
  68618
  58636
  407830
  382318
  769326
  234067
  203742
  393274
  33715
  408435
  429491
  814557
  532577
  775523
  801237
  802409
  800714
  805949
  723983
  726325
  752924
  798311
  812980
  408912
  382085
  219957
  533820
  536490
  714169
  651253
]
3.43 ms
(2.14%)
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
  33715
  58636
  66217
  68618
  197442
  203742
  210349
  219957
  234067
  382085
  382318
  393274
  407830
  408435
  408912
  429491
  479724
  521449
  532577
  533506
  533820
  536490
  537741
  542858
  546477
  613819
  631332
  643975
  644200
  644255
  646248
  648742
  651253
  672378
  673125
  682602
  684917
  690461
  693064
  714169
  720528
  723750
  723983
  724261
  726325
  726580
  729674
  736029
  736051
  736459
  738081
  738104
  745196
  746673
  749362
  749376
  749393
  750843
  752221
  752252
  752259
  752353
  752896
  752924
  756369
  757447
  760112
  767484
  768411
  769326
  770536
  772329
  774627
  775523
  776685
  776867
  777811
  781343
  782636
  784180
  787335
  788152
  788349
  789053
  790808
  797861
  798311
  799144
  799160
  800714
  801237
  802409
  802574
  802634
  805949
  807623
  812980
  813851
  814557
  816955
  817021
  817710
  818171
  818287
  818593
  819081
  819250
  820015
  820142
  821108
  822814
  822919
  823130
  824654
  825521
  827886
  827905
  827911
]
2.25 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "жопы сиськи"
]
1.68 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп сиськ"
]
1.49 ms
(0.93%)
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.