Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.17 ms
(58.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал фистинг домашн любительск"
]
126.52 ms
(34.59%)
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
  151179
  389794
  396071
  412830
  412852
  416527
  416531
  416680
  416690
  416746
  421993
  428171
  431439
  432929
  441203
  441853
  446031
  448115
  449377
  450889
  466427
  471455
  474596
  480502
  485527
  487200
  490232
  493486
  493763
  500341
  500734
  508891
  514235
  514744
  514879
  515974
  520797
  529714
  530368
  531844
  531856
  531888
  534536
  536393
  540945
  541277
  541317
  541392
  541421
  545395
  545428
  545439
  545453
  548153
  562784
  564293
  573207
  575589
  575859
  576951
  581098
  583713
  586999
  594491
  595847
  609889
  613032
  628105
  634746
  658787
  658816
  660047
  662856
  664166
  680252
  695559
  703574
  711615
  713508
  717514
  717520
  717542
  728215
  740922
  740932
  744047
  745082
  745092
  745111
  749221
  749243
  749255
  751727
  752612
  752623
  752630
  752642
  752651
  752666
  752669
  752711
  759370
  761752
  766943
  770210
  770225
  770269
  770821
  770864
  778172
  778230
  782844
  784775
  786850
  791885
  796905
  806938
  809371
  811771
  827489
]
19.42 ms
(5.31%)
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
  752666
  770210
  752651
  759370
  428171
  548153
  541277
  520797
  515974
  531856
  466427
  575859
  703574
  717542
  662856
  717520
  680252
  613032
  782844
  786850
  811771
  784775
  740932
  749221
  766943
  770864
  728215
  151179
  594491
  575589
  573207
  446031
  485527
  508891
  416680
  432929
  581098
  595847
  770225
  441203
  450889
  396071
  412852
  431439
  449377
  493763
  531844
  541392
  545395
  660047
  711615
  628105
  740922
  806938
  761752
  751727
  770269
  749243
  412830
  441853
  536393
  514235
  500734
  500341
  634746
  471455
  487200
  389794
  416746
  474596
  770821
  717514
  421993
  416527
  416531
  416690
  827489
  480502
  448115
  534536
  514879
  529714
  530368
  493486
  545453
  541421
  540945
  541317
  658787
  658816
  586999
  778172
  778230
  791885
  744047
  745092
  745111
  752612
  752669
  752711
  745082
  752623
  749255
  752630
  752642
  609889
  809371
  562784
  545439
  514744
  545428
  576951
  490232
  531888
  564293
  583713
  695559
  664166
  713508
  796905
]
2.16 ms
(0.59%)
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
  151179
  389794
  396071
  412830
  412852
  416527
  416531
  416680
  416690
  416746
  421993
  428171
  431439
  432929
  441203
  441853
  446031
  448115
  449377
  450889
  466427
  471455
  474596
  480502
  485527
  487200
  490232
  493486
  493763
  500341
  500734
  508891
  514235
  514744
  514879
  515974
  520797
  529714
  530368
  531844
  531856
  531888
  534536
  536393
  540945
  541277
  541317
  541392
  541421
  545395
  545428
  545439
  545453
  548153
  562784
  564293
  573207
  575589
  575859
  576951
  581098
  583713
  586999
  594491
  595847
  609889
  613032
  628105
  634746
  658787
  658816
  660047
  662856
  664166
  680252
  695559
  703574
  711615
  713508
  717514
  717520
  717542
  728215
  740922
  740932
  744047
  745082
  745092
  745111
  749221
  749243
  749255
  751727
  752612
  752623
  752630
  752642
  752651
  752666
  752669
  752711
  759370
  761752
  766943
  770210
  770225
  770269
  770821
  770864
  778172
  778230
  782844
  784775
  786850
  791885
  796905
  806938
  809371
  811771
  827489
]
2.04 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "анал фистинг домашн любительск"
]
1.84 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "анал фистинг дома"
]
1.63 ms
(0.44%)
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.