Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
174.14 ms
(85.44%)
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
  386134
  387014
  390001
  390667
  390980
  393391
  399152
  401049
  407124
  410602
  415209
  418963
  421164
  424751
  431335
  431643
  434358
  446948
  447565
  448489
  450988
  451663
  457203
  458530
  458922
  459656
  460608
  462349
  463079
  463825
  466404
  470568
  470992
  471392
  472956
  473242
  474520
  474557
  483006
  484667
  484719
  490011
  490897
  491925
  491931
  495070
  496613
  500477
  504139
  506295
  508786
  509552
  510581
  514660
  517859
  525287
  525348
  525634
  526440
  529792
  530369
  532666
  532893
  533186
  533746
  534986
  535434
  536666
  544502
  559228
  566246
  566264
  566664
  574021
  582277
  586679
  587852
  588068
  599002
  599052
  600011
  603244
  604550
  606608
  613859
  614029
  615909
  619747
  623262
  631243
  634546
  637553
  640691
  641930
  641978
  650785
  653596
  653726
  659385
  663370
  663437
  663441
  664957
  667290
  667476
  675008
  702621
  718698
  732777
  733217
  744360
  748242
  759731
  781990
  792655
  803074
  809478
  815204
  815789
  816086
]
20.03 ms
(9.83%)
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
  401049
  587852
  631243
  390980
  451663
  424751
  566246
  640691
  781990
  410602
  393391
  599002
  815789
  470568
  559228
  659385
  663437
  803074
  600011
  615909
  457203
  653726
  748242
  447565
  387014
  458530
  470992
  431643
  634546
  744360
  399152
  390667
  509552
  532893
  533186
  792655
  732777
  458922
  460608
  490897
  510581
  586679
  809478
  525348
  702621
  604550
  514660
  815204
  496613
  606608
  446948
  491931
  733217
  434358
  534986
  415209
  472956
  525287
  466404
  526440
  574021
  759731
  463079
  484667
  431335
  484719
  474520
  544502
  390001
  588068
  533746
  529792
  675008
  641978
  462349
  473242
  500477
  421164
  463825
  495070
  582277
  483006
  667290
  614029
  599052
  508786
  407124
  530369
  386134
  637553
  471392
  474557
  448489
  603244
  532666
  566264
  667476
  664957
  653596
  623262
  490011
  566664
  663370
  650785
  718698
  450988
  506295
  536666
  418963
  535434
  619747
  663441
  613859
  491925
  641930
  816086
  459656
  525634
  504139
  517859
]
2.65 ms
(1.30%)
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
  386134
  387014
  390001
  390667
  390980
  393391
  399152
  401049
  407124
  410602
  415209
  418963
  421164
  424751
  431335
  431643
  434358
  446948
  447565
  448489
  450988
  451663
  457203
  458530
  458922
  459656
  460608
  462349
  463079
  463825
  466404
  470568
  470992
  471392
  472956
  473242
  474520
  474557
  483006
  484667
  484719
  490011
  490897
  491925
  491931
  495070
  496613
  500477
  504139
  506295
  508786
  509552
  510581
  514660
  517859
  525287
  525348
  525634
  526440
  529792
  530369
  532666
  532893
  533186
  533746
  534986
  535434
  536666
  544502
  559228
  566246
  566264
  566664
  574021
  582277
  586679
  587852
  588068
  599002
  599052
  600011
  603244
  604550
  606608
  613859
  614029
  615909
  619747
  623262
  631243
  634546
  637553
  640691
  641930
  641978
  650785
  653596
  653726
  659385
  663370
  663437
  663441
  664957
  667290
  667476
  675008
  702621
  718698
  732777
  733217
  744360
  748242
  759731
  781990
  792655
  803074
  809478
  815204
  815789
  816086
]
2.04 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "куннилингус оральн секс дилд"
]
1.79 ms
(0.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "куни самотык"
]
1.63 ms
(0.80%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "куннилингус оральн секс дилд"
]
1.53 ms
(0.75%)
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.