Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.56 ms
(54.49%)
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
  61597
  181252
  379619
  381884
  382326
  382878
  382942
  385780
  386876
  390012
  393483
  397557
  398247
  401541
  401856
  402007
  403411
  407322
  407409
  411721
  411883
  413984
  417081
  417757
  424011
  424847
  432490
  436732
  438118
  444376
  445669
  446012
  446316
  447847
  448698
  449082
  449389
  450030
  450773
  453232
  459359
  459622
  459863
  459899
  459917
  460425
  461923
  462075
  462907
  464254
  464457
  464529
  465460
  465484
  466224
  466999
  467682
  467818
  470258
  470691
  472178
  472924
  476397
  478347
  478656
  479178
  480513
  483592
  484777
  485327
  486136
  487176
  491124
  493087
  493972
  495732
  498616
  502061
  504005
  505578
  509346
  510305
  514854
  516074
  522547
  524844
  528500
  530112
  533731
  548039
  565302
  565865
  577725
  599674
  601074
  615390
  636463
  661954
  665199
  665303
  665436
  680279
  693419
  700825
  713247
  717837
  725244
  728937
  746713
  748362
  759714
  759762
  761815
  768375
  770176
  770563
  777932
  782460
  810112
  812385
]
151.44 ms
(38.82%)
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
  61597
  181252
  379619
  381884
  382326
  382878
  382942
  385780
  386876
  390012
  393483
  397557
  398247
  401541
  401856
  402007
  403411
  407322
  407409
  411721
  411883
  413984
  417081
  417757
  424011
  424847
  432490
  436732
  438118
  444376
  445669
  446012
  446316
  447847
  448698
  449082
  449389
  450030
  450773
  453232
  459359
  459622
  459863
  459899
  459917
  460425
  461923
  462075
  462907
  464254
  464457
  464529
  465460
  465484
  466224
  466999
  467682
  467818
  470258
  470691
  472178
  472924
  476397
  478347
  478656
  479178
  480513
  483592
  484777
  485327
  486136
  487176
  491124
  493087
  493972
  495732
  498616
  502061
  504005
  505578
  509346
  510305
  514854
  516074
  522547
  524844
  528500
  530112
  533731
  548039
  565302
  565865
  577725
  599674
  601074
  615390
  636463
  661954
  665199
  665303
  665436
  680279
  693419
  700825
  713247
  717837
  725244
  728937
  746713
  748362
  759714
  759762
  761815
  768375
  770176
  770563
  777932
  782460
  810112
  812385
]
18.40 ms
(4.72%)
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
  446316
  450773
  465460
  466224
  480513
  530112
  510305
  498616
  528500
  493087
  577725
  548039
  665303
  680279
  693419
  713247
  700825
  565302
  615390
  810112
  777932
  812385
  746713
  748362
  725244
  761815
  402007
  411721
  436732
  460425
  397557
  407409
  432490
  459899
  476397
  486136
  491124
  505578
  509346
  484777
  487176
  522547
  181252
  61597
  403411
  417081
  445669
  459359
  478656
  450030
  472924
  446012
  449082
  449389
  453232
  464254
  533731
  601074
  599674
  782460
  768375
  770563
  759714
  759762
  770176
  728937
  438118
  459622
  470258
  417757
  459917
  462075
  464529
  493972
  524844
  495732
  407322
  393483
  470691
  385780
  382878
  382942
  379619
  381884
  382326
  390012
  386876
  398247
  401856
  401541
  411883
  413984
  424011
  444376
  424847
  447847
  448698
  465484
  479178
  478347
  459863
  461923
  467818
  472178
  502061
  504005
  514854
  516074
  462907
  464457
  466999
  467682
  483592
  485327
  665199
  665436
  717837
  661954
  565865
  636463
]
2.18 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "секс толстые женщины"
]
1.96 ms
(0.50%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс толстая"
]
1.82 ms
(0.47%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс толстая"
]
1.76 ms
(0.45%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.