Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
208.59 ms
(58.82%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
124.37 ms
(35.07%)
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
  29108
  53683
  61866
  91254
  132421
  156877
  181360
  183601
  198253
  231260
  308832
  330565
  358849
  381782
  382834
  383437
  383829
  384958
  387126
  387785
  389202
  389283
  389708
  390249
  391266
  393393
  393497
  396994
  397249
  401614
  401632
  403685
  407025
  407534
  416299
  422293
  422316
  432200
  444655
  447040
  448763
  449093
  452334
  457624
  459847
  464381
  464390
  470912
  473492
  474306
  478028
  481662
  485681
  488354
  498451
  498765
  511506
  521275
  522241
  530470
  536745
  538829
  540416
  547024
  547052
  558810
  564715
  565519
  567388
  568133
  568291
  568922
  571537
  572764
  579260
  588275
  591111
  601757
  607184
  617634
  626184
  645264
  665461
  667901
  680657
  684298
  698386
  699235
  727685
  735761
  748437
  751590
  753415
  755080
  775396
  777898
  780254
  781966
  787101
  792786
  797106
  799996
  801019
  801497
  806694
  807210
  808422
  808424
  808733
  810215
  811620
  811971
  812166
  819108
  822921
  826323
  828200
  828857
  828861
  828870
]
13.16 ms
(3.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
  384958
  387126
  401614
  407025
  389708
  393393
  389202
  826323
  808733
  828857
  448763
  522241
  819108
  540416
  536745
  547024
  808422
  801497
  607184
  781966
  389283
  383437
  383829
  91254
  156877
  132421
  231260
  181360
  183601
  381782
  29108
  61866
  390249
  391266
  396994
  416299
  422316
  422293
  432200
  822921
  478028
  481662
  530470
  538829
  568291
  579260
  568133
  699235
  591111
  588275
  801019
  810215
  775396
  780254
  806694
  727685
  735761
  755080
  787101
  799996
  807210
  808424
  751590
  753415
  748437
  601757
  698386
  777898
  792786
  797106
  811620
  812166
  53683
  382834
  393497
  401632
  403685
  407534
  198253
  358849
  308832
  330565
  397249
  828200
  828870
  828861
  811971
  457624
  459847
  464381
  387785
  444655
  447040
  449093
  464390
  452334
  485681
  498451
  498765
  511506
  521275
  470912
  473492
  474306
  488354
  558810
  547052
  564715
  572764
  567388
  680657
  684298
  645264
  665461
  667901
  565519
  568922
  571537
  617634
  626184
]
2.83 ms
(0.80%)
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
  29108
  53683
  61866
  91254
  132421
  156877
  181360
  183601
  198253
  231260
  308832
  330565
  358849
  381782
  382834
  383437
  383829
  384958
  387126
  387785
  389202
  389283
  389708
  390249
  391266
  393393
  393497
  396994
  397249
  401614
  401632
  403685
  407025
  407534
  416299
  422293
  422316
  432200
  444655
  447040
  448763
  449093
  452334
  457624
  459847
  464381
  464390
  470912
  473492
  474306
  478028
  481662
  485681
  488354
  498451
  498765
  511506
  521275
  522241
  530470
  536745
  538829
  540416
  547024
  547052
  558810
  564715
  565519
  567388
  568133
  568291
  568922
  571537
  572764
  579260
  588275
  591111
  601757
  607184
  617634
  626184
  645264
  665461
  667901
  680657
  684298
  698386
  699235
  727685
  735761
  748437
  751590
  753415
  755080
  775396
  777898
  780254
  781966
  787101
  792786
  797106
  799996
  801019
  801497
  806694
  807210
  808422
  808424
  808733
  810215
  811620
  811971
  812166
  819108
  822921
  826323
  828200
  828857
  828861
  828870
]
2.08 ms
(0.59%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "черноволосая boobs"
]
2.05 ms
(0.58%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "brunette boobs"
]
1.51 ms
(0.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "черноволосая boobs"
]

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.