Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.46 ms
(85.70%)
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
  187786
  338258
  386042
  387285
  388960
  389459
  393072
  397504
  401537
  420715
  422046
  429440
  437150
  440927
  442842
  447253
  449694
  449738
  460134
  468362
  468369
  470350
  488476
  503722
  508442
  510803
  513839
  520769
  529389
  533167
  535545
  537943
  543165
  550921
  555064
  555256
  557826
  577274
  579835
  582197
  584027
  585450
  588388
  588396
  591718
  591803
  593615
  600718
  617112
  619210
  628019
  631718
  643369
  650136
  652734
  656487
  692962
  698765
  710545
  713933
  718818
  718826
  718850
  719392
  720521
  721230
  721910
  722159
  729960
  730486
  732845
  734269
  734273
  738327
  742747
  753780
  756875
  757301
  767681
  775424
  782729
  783205
  785739
  787272
  788296
  791330
  791650
  793658
  794434
  795351
  796480
  796660
  796809
  800524
  802285
  803078
  804551
  804723
  810073
  811952
  817441
  817736
  818605
  819264
  819332
  819388
  819395
  819404
  820057
  823860
  823954
  823974
  824409
  824455
  824700
  824943
  825472
  825936
  826634
  826850
]
12.09 ms
(7.71%)
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
  742747
  783205
  787272
  468369
  440927
  449738
  520769
  537943
  388960
  389459
  442842
  437150
  488476
  449694
  460134
  577274
  582197
  721230
  631718
  782729
  795351
  804551
  791330
  730486
  756875
  338258
  393072
  420715
  721910
  650136
  555064
  803078
  738327
  387285
  187786
  468362
  470350
  510803
  513839
  422046
  429440
  447253
  508442
  386042
  397504
  401537
  817441
  824943
  825936
  826634
  817736
  819395
  819404
  823954
  824409
  824700
  826850
  818605
  819388
  825472
  819264
  819332
  820057
  823860
  823974
  824455
  503722
  529389
  535545
  533167
  555256
  584027
  543165
  550921
  579835
  656487
  710545
  713933
  718818
  718826
  718850
  719392
  692962
  720521
  722159
  652734
  698765
  557826
  591718
  593615
  600718
  591803
  617112
  628019
  643369
  585450
  588388
  588396
  619210
  775424
  788296
  796480
  804723
  811952
  785739
  791650
  793658
  794434
  796660
  796809
  800524
  802285
  810073
  729960
  732845
  734269
  734273
  753780
  757301
  767681
]
3.42 ms
(2.18%)
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
  187786
  338258
  386042
  387285
  388960
  389459
  393072
  397504
  401537
  420715
  422046
  429440
  437150
  440927
  442842
  447253
  449694
  449738
  460134
  468362
  468369
  470350
  488476
  503722
  508442
  510803
  513839
  520769
  529389
  533167
  535545
  537943
  543165
  550921
  555064
  555256
  557826
  577274
  579835
  582197
  584027
  585450
  588388
  588396
  591718
  591803
  593615
  600718
  617112
  619210
  628019
  631718
  643369
  650136
  652734
  656487
  692962
  698765
  710545
  713933
  718818
  718826
  718850
  719392
  720521
  721230
  721910
  722159
  729960
  730486
  732845
  734269
  734273
  738327
  742747
  753780
  756875
  757301
  767681
  775424
  782729
  783205
  785739
  787272
  788296
  791330
  791650
  793658
  794434
  795351
  796480
  796660
  796809
  800524
  802285
  803078
  804551
  804723
  810073
  811952
  817441
  817736
  818605
  819264
  819332
  819388
  819395
  819404
  820057
  823860
  823954
  823974
  824409
  824455
  824700
  824943
  825472
  825936
  826634
  826850
]
2.07 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother creampie"
]
1.92 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.66 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин creampie"
]
1.29 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин creampie"
]

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.