Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
154.50 ms
(86.71%)
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
  20715
  23104
  24149
  149815
  382176
  385370
  385448
  385590
  385829
  386068
  386323
  389504
  392423
  396922
  400788
  409958
  411196
  416297
  418059
  418433
  418648
  419273
  420135
  420211
  421360
  422529
  422557
  422582
  422589
  422618
  422641
  422865
  422876
  423040
  423060
  423211
  423245
  423261
  423264
  423396
  423464
  428518
  429534
  429535
  429543
  429698
  429930
  435644
  440646
  443992
  444218
  445472
  446267
  446481
  447757
  447758
  456494
  456636
  456847
  457732
  458844
  459263
  462253
  462304
  465194
  471355
  475450
  485576
  489806
  490144
  492646
  494426
  497235
  506139
  510578
  518972
  520629
  528889
  530348
  540175
  546864
  550712
  551972
  551992
  552004
  552899
  552933
  554790
  559869
  572727
  580649
  583280
  591278
  608009
  608517
  613857
  614731
  619432
  630015
  652548
  683608
  694129
  696508
  712722
  720299
  721368
  735602
  740536
  748136
  748681
  761580
  762718
  765710
  773024
  775979
  785021
  789947
  808732
  813507
  817385
]
14.63 ms
(8.21%)
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
  149815
  696508
  420135
  20715
  382176
  422589
  444218
  429534
  429535
  411196
  419273
  497235
  552933
  550712
  652548
  608517
  614731
  630015
  619432
  785021
  775979
  808732
  735602
  748136
  386068
  416297
  518972
  418648
  409958
  489806
  423245
  422582
  485576
  552004
  385370
  392423
  23104
  420211
  423261
  421360
  435644
  443992
  465194
  445472
  458844
  462253
  510578
  551972
  551992
  552899
  583280
  591278
  608009
  459263
  422529
  429543
  471355
  446481
  385829
  396922
  428518
  429930
  456636
  447757
  456494
  462304
  475450
  492646
  520629
  530348
  559869
  572727
  580649
  694129
  721368
  789947
  813507
  765710
  761580
  748681
  740536
  762718
  773024
  400788
  422641
  418433
  554790
  546864
  613857
  720299
  817385
  447758
  490144
  683608
  712722
  423040
  446267
  422865
  423464
  423396
  422876
  494426
  386323
  385448
  385590
  24149
  389504
  423211
  440646
  422618
  423060
  423264
  418059
  429698
  422557
  456847
  457732
  528889
  506139
  540175
]
2.62 ms
(1.47%)
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
  20715
  23104
  24149
  149815
  382176
  385370
  385448
  385590
  385829
  386068
  386323
  389504
  392423
  396922
  400788
  409958
  411196
  416297
  418059
  418433
  418648
  419273
  420135
  420211
  421360
  422529
  422557
  422582
  422589
  422618
  422641
  422865
  422876
  423040
  423060
  423211
  423245
  423261
  423264
  423396
  423464
  428518
  429534
  429535
  429543
  429698
  429930
  435644
  440646
  443992
  444218
  445472
  446267
  446481
  447757
  447758
  456494
  456636
  456847
  457732
  458844
  459263
  462253
  462304
  465194
  471355
  475450
  485576
  489806
  490144
  492646
  494426
  497235
  506139
  510578
  518972
  520629
  528889
  530348
  540175
  546864
  550712
  551972
  551992
  552004
  552899
  552933
  554790
  559869
  572727
  580649
  583280
  591278
  608009
  608517
  613857
  614731
  619432
  630015
  652548
  683608
  694129
  696508
  712722
  720299
  721368
  735602
  740536
  748136
  748681
  761580
  762718
  765710
  773024
  775979
  785021
  789947
  808732
  813507
  817385
]
1.79 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "asian man"
]
1.76 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.45 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "азиатк мужчин"
]
1.44 ms
(0.81%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.