Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.80 ms
(81.21%)
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
  384342
  385095
  386756
  389304
  389525
  397888
  398160
  416969
  420266
  424562
  426793
  437878
  443423
  443682
  444136
  448098
  454151
  466040
  467817
  474760
  481913
  486565
  487096
  498104
  500472
  507401
  511009
  512302
  515568
  523314
  526107
  535089
  536096
  543198
  546732
  556987
  558056
  559698
  559914
  565155
  565351
  568826
  570204
  572813
  573676
  576307
  591273
  596653
  618899
  635236
  645268
  652567
  654439
  656710
  659306
  659579
  666590
  668401
  679143
  680616
  681621
  688106
  694537
  699788
  705702
  708807
  716996
  718479
  718655
  719139
  721767
  724475
  726918
  727814
  732167
  736824
  740331
  742035
  743877
  747574
  747904
  750546
  753800
  755178
  759668
  760942
  762739
  764524
  771610
  775826
  784198
  785922
  786513
  794733
  799463
  800068
  800956
  802666
  802871
  804053
  804563
  804783
  807513
  808054
  808790
  813355
  813713
  814779
  815371
  815447
  815941
  817008
  817190
  818369
  818413
  820617
  821771
  822207
  823018
  826972
]
22.11 ms
(13.42%)
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
  721767
  800956
  802666
  804563
  808054
  474760
  437878
  565351
  558056
  543198
  656710
  526107
  817190
  820617
  822207
  823018
  818369
  818413
  821771
  826972
  536096
  481913
  546732
  652567
  699788
  666590
  680616
  694537
  654439
  679143
  705702
  708807
  718479
  559698
  559914
  576307
  635236
  596653
  618899
  800068
  804783
  813355
  740331
  742035
  750546
  753800
  762739
  747574
  755178
  760942
  732167
  743877
  759668
  736824
  716996
  785922
  786513
  802871
  804053
  808790
  398160
  498104
  454151
  535089
  444136
  486565
  719139
  500472
  556987
  511009
  515568
  386756
  815371
  817008
  813713
  815941
  507401
  565155
  645268
  681621
  668401
  688106
  799463
  727814
  747904
  726918
  771610
  775826
  794733
  443423
  443682
  384342
  397888
  426793
  448098
  466040
  467817
  512302
  416969
  815447
  764524
  724475
  659306
  659579
  814779
  487096
  572813
  718655
  807513
  424562
  420266
  573676
  568826
  570204
  591273
  784198
  523314
  385095
  389304
  389525
]
2.90 ms
(1.76%)
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
  384342
  385095
  386756
  389304
  389525
  397888
  398160
  416969
  420266
  424562
  426793
  437878
  443423
  443682
  444136
  448098
  454151
  466040
  467817
  474760
  481913
  486565
  487096
  498104
  500472
  507401
  511009
  512302
  515568
  523314
  526107
  535089
  536096
  543198
  546732
  556987
  558056
  559698
  559914
  565155
  565351
  568826
  570204
  572813
  573676
  576307
  591273
  596653
  618899
  635236
  645268
  652567
  654439
  656710
  659306
  659579
  666590
  668401
  679143
  680616
  681621
  688106
  694537
  699788
  705702
  708807
  716996
  718479
  718655
  719139
  721767
  724475
  726918
  727814
  732167
  736824
  740331
  742035
  743877
  747574
  747904
  750546
  753800
  755178
  759668
  760942
  762739
  764524
  771610
  775826
  784198
  785922
  786513
  794733
  799463
  800068
  800956
  802666
  802871
  804053
  804563
  804783
  807513
  808054
  808790
  813355
  813713
  814779
  815371
  815447
  815941
  817008
  817190
  818369
  818413
  820617
  821771
  822207
  823018
  826972
]
1.68 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "licking tits"
]
1.67 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "лиза сиськ"
]
1.38 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.22 ms
(0.74%)
1
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.