Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
205.10 ms
(56.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade perfect"
]
136.59 ms
(37.35%)
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
  400619
  426104
  426939
  427797
  432537
  436645
  436900
  440986
  443502
  449469
  452737
  452853
  454763
  465232
  472267
  474381
  492016
  493114
  495165
  499169
  502613
  527095
  529774
  529880
  530462
  538717
  538772
  540904
  545303
  556678
  567564
  569798
  577226
  584260
  584508
  586040
  587204
  588618
  589904
  589923
  589927
  589928
  590031
  590068
  590110
  590124
  601873
  602321
  608121
  608536
  610342
  616615
  620805
  621073
  621079
  622510
  626041
  642426
  644478
  658173
  661694
  678656
  678924
  682920
  700928
  704019
  709169
  723236
  727561
  735637
  736404
  739290
  739773
  739960
  740502
  744569
  746785
  751760
  755005
  755637
  756859
  757853
  758092
  758101
  758300
  759460
  759610
  760568
  761838
  762703
  762712
  764772
  765669
  765678
  766266
  767813
  768756
  770945
  771660
  773302
  776581
  778124
  780352
  781609
  783851
  784471
  785440
  785731
  786902
  788618
  792441
  792975
  796055
  799243
  801145
  801653
  801718
  812614
  819144
  825689
]
13.49 ms
(3.69%)
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
  620805
  644478
  590031
  601873
  608536
  610342
  622510
  586040
  588618
  589923
  616615
  642426
  801653
  767813
  621079
  700928
  704019
  587204
  801145
  792441
  426939
  449469
  493114
  584508
  658173
  709169
  678924
  545303
  589904
  621073
  590110
  626041
  796055
  602321
  426104
  776581
  427797
  432537
  436645
  819144
  825689
  452737
  472267
  492016
  499169
  502613
  538772
  527095
  530462
  538717
  495165
  529774
  577226
  540904
  567564
  584260
  723236
  661694
  682920
  556678
  589927
  589928
  780352
  812614
  778124
  781609
  783851
  784471
  786902
  792975
  735637
  736404
  739773
  746785
  756859
  785731
  801718
  727561
  739290
  758101
  759610
  761838
  762712
  764772
  768756
  770945
  739960
  740502
  744569
  751760
  755005
  759460
  762703
  766266
  755637
  765669
  765678
  771660
  757853
  758092
  758300
  760568
  773302
  785440
  788618
  799243
  400619
  436900
  452853
  465232
  443502
  454763
  474381
  440986
  529880
  678656
  569798
  608121
  590068
  590124
]
3.50 ms
(0.96%)
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
  400619
  426104
  426939
  427797
  432537
  436645
  436900
  440986
  443502
  449469
  452737
  452853
  454763
  465232
  472267
  474381
  492016
  493114
  495165
  499169
  502613
  527095
  529774
  529880
  530462
  538717
  538772
  540904
  545303
  556678
  567564
  569798
  577226
  584260
  584508
  586040
  587204
  588618
  589904
  589923
  589927
  589928
  590031
  590068
  590110
  590124
  601873
  602321
  608121
  608536
  610342
  616615
  620805
  621073
  621079
  622510
  626041
  642426
  644478
  658173
  661694
  678656
  678924
  682920
  700928
  704019
  709169
  723236
  727561
  735637
  736404
  739290
  739773
  739960
  740502
  744569
  746785
  751760
  755005
  755637
  756859
  757853
  758092
  758101
  758300
  759460
  759610
  760568
  761838
  762703
  762712
  764772
  765669
  765678
  766266
  767813
  768756
  770945
  771660
  773302
  776581
  778124
  780352
  781609
  783851
  784471
  785440
  785731
  786902
  788618
  792441
  792975
  796055
  799243
  801145
  801653
  801718
  812614
  819144
  825689
]
2.88 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск perfect"
]
2.08 ms
(0.57%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.02 ms
(0.55%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск perfect"
]

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.