Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.72 ms
(82.16%)
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
  157617
  191495
  381805
  397679
  414430
  415889
  416037
  418578
  426265
  426271
  431015
  432674
  444449
  449100
  449862
  452304
  453996
  473454
  473719
  475702
  488359
  508891
  509112
  510291
  514921
  515319
  516464
  517633
  528424
  531776
  531781
  536711
  547458
  554620
  571192
  577343
  580184
  596405
  603542
  612057
  623382
  628518
  628628
  628747
  630370
  632824
  633609
  648760
  650596
  650685
  671780
  678910
  701621
  707392
  713507
  716317
  718047
  724109
  724580
  726497
  726498
  726698
  737182
  738093
  738487
  740824
  742005
  748403
  749516
  751751
  752686
  755496
  756045
  757483
  758633
  759129
  761273
  762036
  765573
  766417
  770338
  770515
  770932
  774393
  778151
  778423
  778555
  781767
  784255
  784969
  785003
  785041
  788485
  788878
  794650
  799140
  800473
  800967
  804800
  805392
  807259
  808036
  808979
  809391
  810365
  811343
  812068
  812790
  813201
  813202
  813818
  814057
  815830
  817242
  818938
  824007
  824955
  825373
  825442
  826971
]
18.11 ms
(11.13%)
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
  781767
  809391
  191495
  473719
  444449
  416037
  718047
  432674
  449100
  452304
  488359
  531776
  508891
  510291
  596405
  812790
  418578
  426265
  431015
  453996
  426271
  414430
  815830
  825442
  826971
  813818
  818938
  824007
  824955
  825373
  449862
  473454
  516464
  517633
  536711
  514921
  515319
  509112
  528424
  531781
  475702
  547458
  577343
  554620
  571192
  580184
  650596
  650685
  707392
  716317
  648760
  671780
  678910
  701621
  713507
  628518
  628628
  603542
  628747
  612057
  630370
  632824
  623382
  785003
  788485
  799140
  805392
  812068
  813201
  778423
  784255
  784969
  794650
  800967
  808036
  808979
  724109
  726497
  726698
  738487
  759129
  770932
  788878
  800473
  807259
  810365
  811343
  740824
  756045
  761273
  766417
  770338
  724580
  737182
  749516
  751751
  752686
  755496
  765573
  774393
  742005
  726498
  738093
  748403
  757483
  758633
  762036
  770515
  633609
  778151
  778555
  785041
  804800
  813202
  397679
  814057
  157617
  381805
  415889
  817242
]
2.96 ms
(1.82%)
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
  157617
  191495
  381805
  397679
  414430
  415889
  416037
  418578
  426265
  426271
  431015
  432674
  444449
  449100
  449862
  452304
  453996
  473454
  473719
  475702
  488359
  508891
  509112
  510291
  514921
  515319
  516464
  517633
  528424
  531776
  531781
  536711
  547458
  554620
  571192
  577343
  580184
  596405
  603542
  612057
  623382
  628518
  628628
  628747
  630370
  632824
  633609
  648760
  650596
  650685
  671780
  678910
  701621
  707392
  713507
  716317
  718047
  724109
  724580
  726497
  726498
  726698
  737182
  738093
  738487
  740824
  742005
  748403
  749516
  751751
  752686
  755496
  756045
  757483
  758633
  759129
  761273
  762036
  765573
  766417
  770338
  770515
  770932
  774393
  778151
  778423
  778555
  781767
  784255
  784969
  785003
  785041
  788485
  788878
  794650
  799140
  800473
  800967
  804800
  805392
  807259
  808036
  808979
  809391
  810365
  811343
  812068
  812790
  813201
  813202
  813818
  814057
  815830
  817242
  818938
  824007
  824955
  825373
  825442
  826971
]
2.06 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "masturbation latina"
]
2.03 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мастурбац латинская"
]
1.95 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.93 ms
(1.19%)
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.