Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
198.55 ms
(87.50%)
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
  6698
  16646
  28591
  46788
  163149
  208177
  210072
  260297
  285846
  382450
  383244
  387186
  393016
  398325
  399697
  400421
  416311
  420377
  430822
  431205
  438562
  441181
  442131
  446954
  447485
  451611
  453652
  458744
  461575
  473931
  475899
  478343
  481276
  484849
  491084
  491767
  501770
  503822
  507405
  507877
  510642
  511747
  512252
  518995
  521342
  521861
  521876
  522539
  527737
  528373
  530328
  538432
  538996
  545710
  552184
  552192
  552695
  554265
  559083
  560562
  560653
  562319
  567738
  567835
  570380
  570418
  570478
  570505
  570626
  571572
  571620
  571913
  572121
  572124
  572142
  572501
  572798
  572801
  572822
  573095
  573688
  573789
  574490
  574825
  574920
  575080
  575100
  575503
  575769
  576072
  576098
  576293
  576405
  580772
  584436
  614518
  628081
  659105
  665515
  669771
  670258
  676914
  692028
  701296
  713216
  722537
  724726
  726962
  730735
  735002
  740205
  741481
  741652
  743328
  747568
  769750
  775571
  805012
  807144
  823792
]
17.17 ms
(7.57%)
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
  775571
  807144
  726962
  387186
  285846
  475899
  163149
  393016
  46788
  16646
  823792
  713216
  665515
  670258
  692028
  628081
  805012
  743328
  740205
  741481
  735002
  208177
  28591
  451611
  576098
  545710
  572798
  575100
  552695
  575080
  570505
  572142
  574490
  481276
  473931
  501770
  512252
  521342
  528373
  521861
  510642
  552184
  570380
  572822
  572801
  571620
  570478
  572121
  572501
  769750
  399697
  420377
  530328
  491084
  567835
  669771
  614518
  730735
  431205
  478343
  210072
  260297
  442131
  491767
  575503
  571572
  573688
  574825
  575769
  576072
  576293
  560562
  570418
  570626
  573789
  574920
  576405
  584436
  382450
  416311
  400421
  430822
  447485
  461575
  522539
  511747
  484849
  507405
  503822
  507877
  518995
  6698
  446954
  453652
  560653
  562319
  571913
  573095
  659105
  676914
  701296
  722537
  724726
  747568
  383244
  398325
  441181
  458744
  521876
  527737
  538432
  741652
  538996
  572124
  554265
  580772
  552192
  438562
  559083
  567738
]
4.33 ms
(1.91%)
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
  6698
  16646
  28591
  46788
  163149
  208177
  210072
  260297
  285846
  382450
  383244
  387186
  393016
  398325
  399697
  400421
  416311
  420377
  430822
  431205
  438562
  441181
  442131
  446954
  447485
  451611
  453652
  458744
  461575
  473931
  475899
  478343
  481276
  484849
  491084
  491767
  501770
  503822
  507405
  507877
  510642
  511747
  512252
  518995
  521342
  521861
  521876
  522539
  527737
  528373
  530328
  538432
  538996
  545710
  552184
  552192
  552695
  554265
  559083
  560562
  560653
  562319
  567738
  567835
  570380
  570418
  570478
  570505
  570626
  571572
  571620
  571913
  572121
  572124
  572142
  572501
  572798
  572801
  572822
  573095
  573688
  573789
  574490
  574825
  574920
  575080
  575100
  575503
  575769
  576072
  576098
  576293
  576405
  580772
  584436
  614518
  628081
  659105
  665515
  669771
  670258
  676914
  692028
  701296
  713216
  722537
  724726
  726962
  730735
  735002
  740205
  741481
  741652
  743328
  747568
  769750
  775571
  805012
  807144
  823792
]
1.83 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "парен девушк kissing"
]
1.73 ms
(0.76%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(0.76%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "boy girl kissing"
]
1.57 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "парен девушк kissing"
]

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.