Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.97 ms
(87.18%)
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
  383415
  391190
  406445
  416016
  428940
  430607
  444192
  473692
  542953
  547187
  552002
  552145
  552151
  552186
  552192
  552222
  552226
  552243
  562201
  562256
  562280
  566618
  569868
  570006
  570015
  570245
  570246
  570256
  570299
  570351
  570375
  570385
  570498
  571510
  571643
  571652
  571885
  571913
  572085
  572151
  572483
  573046
  573577
  573598
  573695
  573826
  575632
  580271
  580673
  584893
  586932
  589346
  593239
  596625
  597811
  597825
  598039
  598547
  623175
  628021
  633908
  639243
  648595
  654576
  654650
  654706
  655652
  655673
  656475
  656948
  657401
  657638
  657701
  657712
  658301
  658566
  658690
  658740
  659524
  659544
  659655
  659774
  660546
  662833
  668729
  672677
  678551
  691879
  710491
  713251
  715103
  718658
  723392
  723451
  731893
  738925
  739914
  740482
  743157
  744796
  750360
  751287
  751376
  754264
  764054
  771772
  782520
  790242
  810752
  811131
  818111
  818199
  828059
  828161
  828392
  828504
]
11.99 ms
(6.84%)
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
  575632
  823395
  821981
  658690
  828161
  570245
  570256
  552145
  790242
  391190
  597811
  648595
  633908
  738925
  782520
  598039
  654706
  654576
  656475
  658740
  416016
  598547
  811131
  828392
  828504
  668729
  570351
  570299
  552186
  569868
  573695
  552243
  570015
  570385
  580271
  406445
  731893
  584893
  810752
  473692
  751376
  750360
  573826
  623175
  566618
  593239
  672677
  744796
  572483
  552192
  662833
  655673
  723392
  771772
  751287
  659544
  678551
  710491
  383415
  444192
  818111
  657638
  655652
  657401
  657701
  658566
  660546
  654650
  656948
  657712
  659524
  723451
  586932
  786797
  743157
  828059
  715103
  691879
  430607
  739914
  571510
  552002
  818199
  547187
  659774
  713251
  658301
  659655
  570375
  628021
  552226
  573577
  562280
  571913
  573598
  562256
  428940
  562201
  569904
  570246
  572151
  542953
  570006
  571643
  552151
  552222
  571885
  570498
  571652
  572085
  580673
  589346
  596625
  597825
  639243
  740482
  754264
  764054
  573046
  718658
]
3.48 ms
(1.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
  383415
  391190
  406445
  416016
  428940
  430607
  444192
  473692
  542953
  547187
  552002
  552145
  552151
  552186
  552192
  552222
  552226
  552243
  562201
  562256
  562280
  566618
  569868
  570006
  570015
  570245
  570246
  570256
  570299
  570351
  570375
  570385
  570498
  571510
  571643
  571652
  571885
  571913
  572085
  572151
  572483
  573046
  573577
  573598
  573695
  573826
  575632
  580271
  580673
  584893
  586932
  589346
  593239
  596625
  597811
  597825
  598039
  598547
  623175
  628021
  633908
  639243
  648595
  654576
  654650
  654706
  655652
  655673
  656475
  656948
  657401
  657638
  657701
  657712
  658301
  658566
  658690
  658740
  659524
  659544
  659655
  659774
  660546
  662833
  668729
  672677
  678551
  691879
  710491
  713251
  715103
  718658
  723392
  723451
  731893
  738925
  739914
  740482
  743157
  744796
  750360
  751287
  751376
  754264
  764054
  771772
  782520
  790242
  810752
  811131
  818111
  818199
  828059
  828161
  828392
  828504
]
2.11 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.93 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "маленькие сиськи девушка"
]
1.69 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "маленькая сиськ девушк"
]
1.30 ms
(0.74%)
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.