Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
113.16 ms
(84.54%)
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
  72519
  81412
  281380
  311393
  330409
  337264
  350861
  383097
  383164
  386695
  387533
  390139
  395990
  398138
  401389
  410808
  412137
  415537
  418543
  419055
  432312
  461474
  506238
  510877
  513477
  522238
  523021
  529460
  535094
  535806
  537178
  537212
  542729
  550442
  552385
  552903
  553701
  556176
  563382
  566240
  584956
  586978
  590182
  591919
  596559
  599361
  614621
  618289
  624028
  630026
  655503
  663309
  678608
  697731
  710819
  710925
  718850
  719821
  723541
  724685
  724688
  726920
  728866
  730165
  731125
  733447
  733584
  734007
  734025
  736500
  740005
  740187
  742973
  746693
  755615
  760302
  761426
  763474
  764749
  765034
  766293
  766966
  767346
  767781
  767805
  771357
  772307
  772353
  772361
  772826
  775008
  777508
  779533
  779547
  779759
  780233
  780281
  782787
  783682
  783724
  783748
  783831
  784686
  786457
  787116
  787213
  787253
  787273
  788090
  790127
  790131
  790577
  793352
  793793
  796017
  800046
  805096
  809541
]
12.13 ms
(9.06%)
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
  410808
  513477
  510877
  523021
  522238
  599361
  81412
  772353
  281380
  387533
  783724
  772307
  736500
  783748
  350861
  432312
  461474
  596559
  330409
  506238
  535806
  537178
  552385
  553701
  563382
  718850
  655503
  697731
  710925
  663309
  710819
  584956
  586978
  624028
  591919
  777508
  786457
  787116
  790577
  800046
  779533
  780281
  783682
  787273
  788090
  790127
  809541
  742973
  746693
  755615
  767805
  772826
  782787
  784686
  787213
  790131
  805096
  724688
  734007
  740187
  764749
  766966
  724685
  733584
  734025
  760302
  765378
  728866
  740005
  767346
  767781
  772361
  764819
  719821
  779759
  780233
  398138
  337264
  401389
  552903
  796017
  383097
  311393
  390139
  537212
  535094
  793793
  730165
  733447
  731125
  618289
  386695
  72519
  395990
  723541
  556176
  590182
  775008
  783831
  787253
  765034
  630026
  383164
  415537
  550442
  614621
  418543
  419055
  412137
  529460
  542729
  566240
  678608
  779547
  793352
  726920
  763474
  771357
  761426
  766293
]
2.45 ms
(1.83%)
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
  72519
  81412
  281380
  311393
  330409
  337264
  350861
  383097
  383164
  386695
  387533
  390139
  395990
  398138
  401389
  410808
  412137
  415537
  418543
  419055
  432312
  461474
  506238
  510877
  513477
  522238
  523021
  529460
  535094
  535806
  537178
  537212
  542729
  550442
  552385
  552903
  553701
  556176
  563382
  566240
  584956
  586978
  590182
  591919
  596559
  599361
  614621
  618289
  624028
  630026
  655503
  663309
  678608
  697731
  710819
  710925
  718850
  719821
  723541
  724685
  724688
  726920
  728866
  730165
  731125
  733447
  733584
  734007
  734025
  736500
  740005
  740187
  742973
  746693
  755615
  760302
  761426
  763474
  764749
  765034
  766293
  766966
  767346
  767781
  767805
  771357
  772307
  772353
  772361
  772826
  775008
  777508
  779533
  779547
  779759
  780233
  780281
  782787
  783682
  783724
  783748
  783831
  784686
  786457
  787116
  787213
  787253
  787273
  788090
  790127
  790131
  790577
  793352
  793793
  796017
  800046
  805096
  809541
]
1.83 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "в рот кончи"
]
1.55 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "в рот сперм"
]
1.47 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "в рот сперм"
]
1.26 ms
(0.94%)
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.