Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
224.05 ms
(57.41%)
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
  736784
  714888
  739164
  766608
  415827
  796157
  730342
  657159
  711728
  583539
  777195
  795299
  742723
  397592
  555267
  794895
  766220
  759571
  559401
  818542
  791924
  441780
  726887
  433353
  425450
  728517
  598088
  801269
  725142
  759927
  585214
  3671
  781590
  784313
  422207
  795297
  479071
  468343
  451499
  738000
  447022
  764595
  794915
  425601
  797218
  441782
  777728
  799910
  457240
  718119
  495223
  812722
  492293
  765792
  764148
  716090
  549102
  674307
  496975
  639355
  827431
  724123
  543532
  778424
  776981
  765227
  493775
  475901
  719929
  536995
  554576
  727738
  440781
  506069
  566980
  391087
  131512
  733548
  612927
  720065
  460585
  726282
  472592
  779804
  775640
  730391
  768392
  566405
  718102
  425531
  777750
  715549
  788371
  776922
  761579
  733284
  726989
  680284
  588393
  502718
  391251
  492009
  504038
  476172
  477128
  493172
  680312
  748971
  400487
  401491
  441845
  777953
  797206
  468357
  729907
  430526
  560005
  420333
  446525
  705471
]
155.66 ms
(39.88%)
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
  3671
  131512
  391087
  391251
  397592
  400487
  401491
  415827
  420333
  422207
  425450
  425531
  425601
  430526
  433353
  440781
  441780
  441782
  441845
  446525
  447022
  451499
  457240
  460585
  468343
  468357
  472592
  475901
  476172
  477128
  479071
  492009
  492293
  493172
  493775
  495223
  496975
  502718
  504038
  506069
  536995
  543532
  549102
  554576
  555267
  559401
  560005
  566405
  566980
  583539
  585214
  588393
  598088
  612927
  639355
  657159
  674307
  680284
  680312
  705471
  711728
  714888
  715549
  716090
  718102
  718119
  719929
  720065
  724123
  725142
  726282
  726887
  726989
  727738
  728517
  729907
  730342
  730391
  733284
  733548
  736784
  738000
  739164
  742723
  748971
  759571
  759927
  761579
  764148
  765227
  765792
  766220
  766608
  768392
  775640
  776922
  776981
  777195
  777728
  777750
  777953
  778424
  779804
  781590
  784313
  788371
  791924
  794895
  794915
  795297
  795299
  796157
  797206
  797218
  799910
  801269
  812722
  818542
  827431
]
2.54 ms
(0.65%)
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
  3671
  131512
  391087
  391251
  397592
  400487
  401491
  415827
  420333
  422207
  425450
  425531
  425601
  430526
  433353
  440781
  441780
  441782
  441845
  446525
  447022
  451499
  457240
  460585
  468343
  468357
  472592
  475901
  476172
  477128
  479071
  492009
  492293
  493172
  493775
  495223
  496975
  502718
  504038
  506069
  536995
  543532
  549102
  554576
  555267
  559401
  560005
  566405
  566980
  583539
  585214
  588393
  598088
  612927
  639355
  657159
  674307
  680284
  680312
  705471
  711728
  714888
  715549
  716090
  718102
  718119
  719929
  720065
  724123
  725142
  726282
  726887
  726989
  727738
  728517
  729907
  730342
  730391
  733284
  733548
  736784
  738000
  739164
  742723
  748971
  759571
  759927
  761579
  764148
  765227
  765792
  766220
  766608
  768392
  775640
  776922
  776981
  777195
  777728
  777750
  777953
  778424
  779804
  781590
  784313
  788371
  791924
  794895
  794915
  795297
  795299
  796157
  797206
  797218
  799910
  801269
  812722
  818542
  827431
]
2.16 ms
(0.55%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс мам женщин домашн любительск"
]
2.08 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "секс с мамой дома"
]
1.94 ms
(0.50%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.87 ms
(0.48%)
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.