Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
419.58 ms
(54.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hard секс mature"
]
211.32 ms
(27.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hard fuck mature"
]
125.11 ms
(16.12%)
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
  40835
  187203
  388557
  391978
  395880
  398940
  400162
  401053
  404608
  411540
  411688
  411744
  418759
  439475
  451486
  462256
  465923
  466721
  466919
  467949
  468348
  469351
  471678
  476303
  478510
  480886
  493220
  493578
  504889
  505819
  537846
  552837
  555128
  563234
  563870
  563945
  564103
  590724
  592462
  599497
  607385
  607814
  610058
  612845
  619520
  619637
  634138
  639825
  647682
  651370
  672894
  674129
  680284
  693441
  698458
  708591
  714175
  714183
  720099
  720455
  720536
  720906
  721002
  722107
  725241
  726532
  727507
  727866
  728441
  731247
  732982
  740000
  744240
  746559
  750265
  750920
  753550
  759980
  761302
  761784
  764231
  765713
  765835
  770159
  775820
  776404
  777151
  778281
  785438
  786199
  788592
  790367
  794239
  794877
  799111
  800394
  800426
  800515
  801839
  802310
  802351
  803242
  804427
  805199
  805341
  807327
  808470
  809503
  810098
  811691
  815978
  817276
  817785
  817963
  818802
  824258
  824353
  824920
  826650
  826682
]
14.80 ms
(1.91%)
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
  610058
  799111
  802310
  401053
  824258
  462256
  465923
  537846
  563234
  720099
  592462
  726532
  759980
  785438
  619520
  451486
  398940
  467949
  607385
  468348
  714183
  808470
  411540
  504889
  395880
  824353
  404608
  818802
  824920
  698458
  708591
  722107
  612845
  776404
  786199
  802351
  790367
  764231
  714175
  720536
  801839
  391978
  411744
  493578
  680284
  811691
  778281
  803242
  725241
  740000
  744240
  770159
  800394
  727866
  732982
  750920
  765713
  817963
  817785
  815978
  563945
  693441
  720906
  788592
  794877
  761784
  800426
  805199
  731247
  765835
  750265
  746559
  639825
  794239
  466721
  493220
  804427
  388557
  471678
  807327
  634138
  826682
  476303
  564103
  672894
  619637
  800515
  805341
  727507
  721002
  810098
  563870
  555128
  647682
  418759
  400162
  775820
  809503
  777151
  187203
  411688
  478510
  728441
  651370
  753550
  761302
  439475
  469351
  552837
  674129
  590724
  599497
  480886
  505819
  40835
  826650
  817276
  466919
  720455
  607814
]
2.09 ms
(0.27%)
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
  40835
  187203
  388557
  391978
  395880
  398940
  400162
  401053
  404608
  411540
  411688
  411744
  418759
  439475
  451486
  462256
  465923
  466721
  466919
  467949
  468348
  469351
  471678
  476303
  478510
  480886
  493220
  493578
  504889
  505819
  537846
  552837
  555128
  563234
  563870
  563945
  564103
  590724
  592462
  599497
  607385
  607814
  610058
  612845
  619520
  619637
  634138
  639825
  647682
  651370
  672894
  674129
  680284
  693441
  698458
  708591
  714175
  714183
  720099
  720455
  720536
  720906
  721002
  722107
  725241
  726532
  727507
  727866
  728441
  731247
  732982
  740000
  744240
  746559
  750265
  750920
  753550
  759980
  761302
  761784
  764231
  765713
  765835
  770159
  775820
  776404
  777151
  778281
  785438
  786199
  788592
  790367
  794239
  794877
  799111
  800394
  800426
  800515
  801839
  802310
  802351
  803242
  804427
  805199
  805341
  807327
  808470
  809503
  810098
  811691
  815978
  817276
  817785
  817963
  818802
  824258
  824353
  824920
  826650
  826682
]
1.77 ms
(0.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hard секс mature"
]
1.44 ms
(0.19%)
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.