Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.42 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 1.96 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"Ðüð┐ð¥ÐÇÐéð©ð▓ð¢ÐïðÁ ð┤ðÁð▓ÐâÐêð║ð© ðÂð%ÔǪ"
]
3 11.76 ms
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
  536823
  537728
  539052
  543295
  548003
  701350
  713049
  643434
  611211
  779674
  790881
  763395
  402134
  505339
  557931
  669337
  548745
  470311
  586932
  737628
  730802
  820650
  576090
  549557
  702162
  548723
  593113
  730867
  737114
  702165
  536659
  261061
  120415
  540492
  568124
  541707
  714455
  676982
  545475
  571219
  586832
  598923
  590762
  604068
  728230
  603910
  633518
  388696
  505326
  525278
  404360
  823173
  821184
  464522
  520164
  528034
  538255
  515547
  552337
  564024
  564771
  567741
  548628
  549551
  564440
  564799
  571997
  573651
  551270
  552181
  572197
  714491
  684995
  576319
  586138
  594305
  619130
  591319
  595398
  602568
  604063
  620285
  587247
  810572
  761980
  604043
  604114
  715077
  397128
  408824
  400986
  404696
  516737
  490987
  507669
  585129
  820346
  822502
  823309
  827957
  463706
  515070
  527250
  515543
  541735
  557629
  560476
  560574
  564619
  564769
  569859
  570188
  570576
  558450
  559032
  577359
  551248
  555791
  561721
  564000
]
4 2.83 ms
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
  120415
  261061
  388696
  397128
  400986
  402134
  404360
  404696
  408824
  463706
  464522
  470311
  490987
  505326
  505339
  507669
  515070
  515543
  515547
  516737
  520164
  525278
  527250
  528034
  536659
  536823
  537728
  538255
  539052
  540492
  541707
  541735
  543295
  545475
  548003
  548628
  548723
  548745
  549551
  549557
  551248
  551270
  552181
  552337
  555791
  557629
  557931
  558450
  559032
  560476
  560574
  561721
  564000
  564024
  564440
  564619
  564769
  564771
  564799
  567741
  568124
  569859
  570188
  570576
  571219
  571997
  572197
  573651
  576090
  576319
  577359
  585129
  586138
  586832
  586932
  587247
  590762
  591319
  593113
  594305
  595398
  598923
  602568
  603910
  604043
  604063
  604068
  604114
  611211
  619130
  620285
  633518
  643434
  669337
  676982
  684995
  701350
  702162
  702165
  713049
  714455
  714491
  715077
  728230
  730802
  730867
  737114
  737628
  761980
  763395
  779674
  790881
  810572
  820346
  820650
  821184
  823173
  823309
  827957
]
5 158.28 ms
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
  120415
  261061
  388696
  397128
  400986
  402134
  404360
  404696
  408824
  463706
  464522
  470311
  490987
  505326
  505339
  507669
  515070
  515543
  515547
  516737
  520164
  525278
  527250
  528034
  536659
  536823
  537728
  538255
  539052
  540492
  541707
  541735
  543295
  545475
  548003
  548628
  548723
  548745
  549551
  549557
  551248
  551270
  552181
  552337
  555791
  557629
  557931
  558450
  559032
  560476
  560574
  561721
  564000
  564024
  564440
  564619
  564769
  564771
  564799
  567741
  568124
  569859
  570188
  570576
  571219
  571997
  572197
  573651
  576090
  576319
  577359
  585129
  586138
  586832
  586932
  587247
  590762
  591319
  593113
  594305
  595398
  598923
  602568
  603910
  604043
  604063
  604068
  604114
  611211
  619130
  620285
  633518
  643434
  669337
  676982
  684995
  701350
  702162
  702165
  713049
  714455
  714491
  715077
  728230
  730802
  730867
  737114
  737628
  761980
  763395
  779674
  790881
  810572
  820346
  820650
  821184
  823173
  823309
  827957
]
6 1.68 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "спортивная девушк"
]
7 1.69 ms
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.