Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.50 ms
(84.92%)
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
  33309
  383985
  386638
  389218
  390382
  390569
  391076
  391582
  391703
  391955
  400845
  400862
  405074
  407768
  408313
  411121
  411338
  413520
  421781
  422353
  422358
  423641
  424435
  425993
  426518
  428150
  430297
  432872
  443405
  451523
  454110
  454192
  455008
  459347
  459946
  462101
  462324
  462690
  465343
  466014
  466913
  468199
  468647
  469453
  470309
  473472
  473891
  474079
  477714
  479989
  480903
  485679
  485684
  485732
  485768
  487340
  488118
  496548
  497497
  502279
  512687
  514878
  514906
  515076
  515925
  515986
  518006
  518957
  522191
  524860
  527131
  527144
  529315
  529390
  540727
  542247
  549697
  549698
  549706
  554880
  556620
  563146
  568053
  570958
  583572
  589192
  593344
  595783
  597477
  599525
  601342
  604955
  614365
  626885
  724412
  728194
  735910
  741726
  741779
  742414
  744987
  748238
  748463
  751513
  757110
  760859
  770102
  794240
  794247
  794795
  795483
  797525
  798948
  807980
  808155
  809272
  812367
  819701
  825039
  827473
]
18.13 ms
(9.65%)
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
  614365
  390569
  443405
  425993
  413520
  827473
  459347
  474079
  485684
  515925
  497497
  514878
  512687
  540727
  487340
  549697
  599525
  593344
  601342
  794247
  798948
  748238
  748463
  757110
  797525
  741726
  744987
  724412
  735910
  391955
  424435
  432872
  400862
  383985
  411338
  454110
  477714
  386638
  391076
  407768
  391703
  428150
  480903
  485679
  488118
  527131
  390382
  400845
  422358
  466014
  514906
  529315
  515986
  518006
  563146
  549706
  589192
  809272
  728194
  466913
  454192
  473891
  430297
  451523
  405074
  455008
  794240
  795483
  742414
  770102
  741779
  751513
  794795
  391582
  473472
  469453
  568053
  812367
  459946
  468199
  485732
  515076
  527144
  542247
  570958
  583572
  597477
  808155
  807980
  760859
  556620
  462324
  422353
  496548
  595783
  524860
  522191
  462101
  518957
  502279
  554880
  470309
  626885
  479989
  549698
  604955
  529390
  421781
  33309
  389218
  408313
  411121
  426518
  423641
  819701
  825039
  462690
  465343
  468647
  485768
]
2.86 ms
(1.52%)
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
  33309
  383985
  386638
  389218
  390382
  390569
  391076
  391582
  391703
  391955
  400845
  400862
  405074
  407768
  408313
  411121
  411338
  413520
  421781
  422353
  422358
  423641
  424435
  425993
  426518
  428150
  430297
  432872
  443405
  451523
  454110
  454192
  455008
  459347
  459946
  462101
  462324
  462690
  465343
  466014
  466913
  468199
  468647
  469453
  470309
  473472
  473891
  474079
  477714
  479989
  480903
  485679
  485684
  485732
  485768
  487340
  488118
  496548
  497497
  502279
  512687
  514878
  514906
  515076
  515925
  515986
  518006
  518957
  522191
  524860
  527131
  527144
  529315
  529390
  540727
  542247
  549697
  549698
  549706
  554880
  556620
  563146
  568053
  570958
  583572
  589192
  593344
  595783
  597477
  599525
  601342
  604955
  614365
  626885
  724412
  728194
  735910
  741726
  741779
  742414
  744987
  748238
  748463
  751513
  757110
  760859
  770102
  794240
  794247
  794795
  795483
  797525
  798948
  807980
  808155
  809272
  812367
  819701
  825039
  827473
]
2.28 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "толстушки в чулках кончают"
]
1.77 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "полная чулк нижн бел сперм"
]
1.60 ms
(0.85%)
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.