Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
142.65 ms
(86.20%)
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
  31941
  165669
  317898
  334474
  366044
  385682
  386128
  387541
  387868
  396362
  398799
  405682
  418565
  423861
  429125
  429311
  429494
  432734
  441892
  443188
  443852
  453487
  453591
  453850
  453860
  453871
  456194
  456633
  457725
  459256
  462662
  472303
  473323
  474224
  475875
  477385
  478403
  478922
  479377
  480469
  482156
  485089
  485946
  485991
  486172
  486816
  486924
  490162
  490325
  490659
  492819
  493456
  493962
  494574
  495491
  495496
  495855
  503764
  504232
  504327
  506568
  507131
  507627
  509054
  520624
  522506
  523552
  530557
  532157
  533992
  536157
  537614
  537626
  537788
  541903
  541904
  541910
  544199
  547967
  552862
  553150
  553154
  553188
  553201
  553502
  553600
  555646
  555660
  556998
  557016
  557547
  559467
  565883
  567461
  567803
  597836
  645335
  662117
  669277
  673560
  673574
  686627
  691538
  692122
  693234
  694417
  698618
  702375
  702376
  702382
  721677
  732827
  739792
  747629
  753781
  780712
  795375
  805653
  811889
]
13.67 ms
(8.26%)
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
  443852
  565883
  555660
  472303
  492819
  503764
  532157
  537626
  553201
  553150
  702376
  669277
  553188
  493962
  544199
  504232
  507131
  485946
  507627
  522506
  490162
  396362
  486816
  559467
  691538
  694417
  317898
  478403
  386128
  366044
  486172
  520624
  811889
  441892
  530557
  537614
  533992
  490659
  541904
  547967
  541910
  557547
  662117
  693234
  673560
  553154
  805653
  739792
  165669
  456633
  536157
  645335
  698618
  747629
  753781
  482156
  477385
  504327
  398799
  405682
  429494
  443188
  418565
  453871
  506568
  597836
  453850
  480469
  429125
  453487
  453860
  485991
  385682
  721677
  686627
  692122
  780712
  795375
  732827
  453591
  432734
  495496
  523552
  526388
  509054
  541903
  553600
  567461
  553502
  462662
  485089
  459256
  334474
  387541
  429311
  456194
  457725
  473323
  474224
  486924
  490325
  537788
  555646
  567803
  702382
  702375
  423861
  387868
  31941
  479377
  475875
  478922
  494574
  495491
  495855
  493456
  552862
  557016
  673574
  556998
]
2.31 ms
(1.40%)
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
  31941
  165669
  317898
  334474
  366044
  385682
  386128
  387541
  387868
  396362
  398799
  405682
  418565
  423861
  429125
  429311
  429494
  432734
  441892
  443188
  443852
  453487
  453591
  453850
  453860
  453871
  456194
  456633
  457725
  459256
  462662
  472303
  473323
  474224
  475875
  477385
  478403
  478922
  479377
  480469
  482156
  485089
  485946
  485991
  486172
  486816
  486924
  490162
  490325
  490659
  492819
  493456
  493962
  494574
  495491
  495496
  495855
  503764
  504232
  504327
  506568
  507131
  507627
  509054
  520624
  522506
  523552
  530557
  532157
  533992
  536157
  537614
  537626
  537788
  541903
  541904
  541910
  544199
  547967
  552862
  553150
  553154
  553188
  553201
  553502
  553600
  555646
  555660
  556998
  557016
  557547
  559467
  565883
  567461
  567803
  597836
  645335
  662117
  669277
  673560
  673574
  686627
  691538
  692122
  693234
  694417
  698618
  702375
  702376
  702382
  721677
  732827
  739792
  747629
  753781
  780712
  795375
  805653
  811889
]
1.88 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "скрытая съемка камеро…"
]
1.75 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "скрыт камер камер"
]
1.64 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.58 ms
(0.95%)
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.