Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
261.63 ms
(89.64%)
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
  6941
  76852
  92307
  124494
  132148
  162000
  187824
  188398
  310758
  352189
  384769
  386320
  394162
  394941
  398882
  400837
  402425
  412733
  421471
  421814
  426024
  426703
  428038
  429901
  432552
  432656
  434342
  436694
  440087
  441353
  441566
  444859
  444915
  454541
  458965
  464705
  466175
  469420
  469587
  476781
  477541
  478446
  485344
  492161
  500620
  518957
  521127
  526054
  526241
  528878
  529897
  534595
  535450
  536444
  541776
  546785
  547029
  555149
  558622
  560931
  563076
  564876
  580595
  584229
  586400
  587449
  593787
  597901
  606651
  607325
  626862
  635398
  641847
  644285
  646868
  656610
  656942
  670338
  673536
  680434
  680454
  694308
  694479
  696376
  700257
  700327
  702402
  713193
  714630
  718657
  719026
  720604
  723197
  723209
  729333
  733677
  752783
  756789
  761691
  761759
  764157
  765589
  778494
  781011
  782039
  783275
  784221
  789151
  795425
  798666
  800803
  801263
  803906
  810301
  815024
  817200
  817208
  824035
  824457
  826290
]
20.43 ms
(7.00%)
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
  765589
  729333
  756789
  700327
  783275
  795425
  810301
  526054
  555149
  607325
  521127
  535450
  826290
  580595
  593787
  606651
  162000
  478446
  564876
  352189
  436694
  485344
  402425
  394941
  310758
  398882
  432656
  441353
  440087
  412733
  441566
  469420
  500620
  464705
  584229
  92307
  6941
  421814
  426024
  434342
  528878
  541776
  656610
  444915
  429901
  426703
  798666
  492161
  764157
  723197
  782039
  526241
  558622
  563076
  586400
  428038
  761691
  784221
  386320
  518957
  536444
  432552
  476781
  700257
  187824
  696376
  421471
  466175
  76852
  824457
  824035
  817200
  817208
  547029
  673536
  694479
  626862
  587449
  778494
  781011
  789151
  800803
  761759
  752783
  733677
  801263
  803906
  534595
  444859
  477541
  400837
  384769
  469587
  124494
  132148
  188398
  394162
  815024
  454541
  458965
  529897
  656942
  680434
  702402
  713193
  719026
  723209
  646868
  680454
  714630
  670338
  694308
  718657
  720604
  546785
  560931
  597901
  635398
  641847
  644285
]
2.86 ms
(0.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
  6941
  76852
  92307
  124494
  132148
  162000
  187824
  188398
  310758
  352189
  384769
  386320
  394162
  394941
  398882
  400837
  402425
  412733
  421471
  421814
  426024
  426703
  428038
  429901
  432552
  432656
  434342
  436694
  440087
  441353
  441566
  444859
  444915
  454541
  458965
  464705
  466175
  469420
  469587
  476781
  477541
  478446
  485344
  492161
  500620
  518957
  521127
  526054
  526241
  528878
  529897
  534595
  535450
  536444
  541776
  546785
  547029
  555149
  558622
  560931
  563076
  564876
  580595
  584229
  586400
  587449
  593787
  597901
  606651
  607325
  626862
  635398
  641847
  644285
  646868
  656610
  656942
  670338
  673536
  680434
  680454
  694308
  694479
  696376
  700257
  700327
  702402
  713193
  714630
  718657
  719026
  720604
  723197
  723209
  729333
  733677
  752783
  756789
  761691
  761759
  764157
  765589
  778494
  781011
  782039
  783275
  784221
  789151
  795425
  798666
  800803
  801263
  803906
  810301
  815024
  817200
  817208
  824035
  824457
  826290
]
1.98 ms
(0.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "трусик нижн бел анал"
]
1.89 ms
(0.65%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "трусик нижн бел анал"
]
1.62 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "panties anal"
]
1.47 ms
(0.50%)
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.