Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
127.80 ms
(84.80%)
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
  33686
  53510
  123199
  157617
  166116
  185044
  185834
  209171
  251363
  282430
  325863
  365938
  370875
  381769
  381917
  382371
  384181
  384935
  385220
  385412
  385758
  386371
  386576
  386846
  387346
  387470
  388020
  388543
  390255
  390634
  390702
  390892
  392423
  393526
  394713
  395891
  396024
  396171
  396371
  397092
  397381
  397908
  398126
  398461
  400468
  401468
  401492
  402090
  402926
  403216
  404019
  406636
  407682
  408299
  408420
  409103
  411923
  411925
  414933
  416346
  417452
  428659
  428663
  430392
  431228
  431672
  433558
  433997
  447113
  447683
  448631
  450390
  452526
  453105
  455954
  458118
  458660
  458742
  460127
  464744
  465753
  467917
  470451
  474376
  475286
  481297
  481309
  490944
  493126
  500472
  503121
  504948
  505660
  507856
  509916
  512647
  519576
  537457
  539058
  543819
  552213
  555076
  555984
  557981
  562306
  563048
  571631
  573663
  573961
  573972
  576323
  660272
  664317
  677903
  695113
  710054
  746304
  750061
  756499
  767957
]
11.47 ms
(7.61%)
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
  555984
  470451
  390634
  503121
  450390
  452526
  573961
  431228
  398461
  447683
  660272
  576323
  756499
  393526
  431672
  400468
  433558
  433997
  388543
  397908
  401492
  458660
  493126
  386846
  386576
  385412
  166116
  390255
  417452
  428663
  411923
  458118
  563048
  390892
  458742
  481309
  402926
  507856
  365938
  33686
  388020
  384935
  385220
  397092
  664317
  677903
  710054
  746304
  385758
  390702
  402090
  404019
  409103
  573972
  573663
  481297
  401468
  408299
  539058
  505660
  53510
  209171
  382371
  767957
  396024
  504948
  537457
  464744
  403216
  467917
  519576
  386371
  157617
  448631
  571631
  750061
  474376
  396371
  408420
  460127
  394713
  428659
  500472
  123199
  455954
  384181
  398126
  447113
  465753
  325863
  512647
  509916
  381769
  387346
  695113
  370875
  414933
  475286
  416346
  282430
  251363
  397381
  557981
  407682
  430392
  411925
  543819
  562306
  552213
  555076
  453105
  395891
  490944
  185044
  185834
  392423
  381917
  387470
  396171
  406636
]
4.49 ms
(2.98%)
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
  33686
  53510
  123199
  157617
  166116
  185044
  185834
  209171
  251363
  282430
  325863
  365938
  370875
  381769
  381917
  382371
  384181
  384935
  385220
  385412
  385758
  386371
  386576
  386846
  387346
  387470
  388020
  388543
  390255
  390634
  390702
  390892
  392423
  393526
  394713
  395891
  396024
  396171
  396371
  397092
  397381
  397908
  398126
  398461
  400468
  401468
  401492
  402090
  402926
  403216
  404019
  406636
  407682
  408299
  408420
  409103
  411923
  411925
  414933
  416346
  417452
  428659
  428663
  430392
  431228
  431672
  433558
  433997
  447113
  447683
  448631
  450390
  452526
  453105
  455954
  458118
  458660
  458742
  460127
  464744
  465753
  467917
  470451
  474376
  475286
  481297
  481309
  490944
  493126
  500472
  503121
  504948
  505660
  507856
  509916
  512647
  519576
  537457
  539058
  543819
  552213
  555076
  555984
  557981
  562306
  563048
  571631
  573663
  573961
  573972
  576323
  660272
  664317
  677903
  695113
  710054
  746304
  750061
  756499
  767957
]
1.85 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "кунилингус-лижет-пизду-с-разговорами мамо4"
]
1.83 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "куннилингус оральн секс куннилингус оральн секс разговор мамо4"
]
1.68 ms
(1.12%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "куннилингус оральн секс куннилингус оральн секс разговор мамо4"
]
1.59 ms
(1.05%)
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.