Query Metrics

8 Database Queries
8 Different statements
282.22 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.57 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 1.66 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "зять ххх тещу"
]
3 13.53 ms
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
  233193
  382802
  365881
  418900
  385974
  397874
  395943
  183634
  728451
  387856
  718501
  233710
  398935
  619235
  188263
  520021
  395579
  395142
  395601
  587558
  774187
  407396
  391392
  561583
  542781
  665508
  232940
  411347
  391574
  188373
  808866
  392952
  739955
  396425
  385469
  397873
  40835
  276696
  789552
  397878
  506833
  187903
  188136
  486253
  520681
  390610
  187418
  150798
  157194
  514757
  383094
  3971
  413456
  604154
  409310
  722301
  391576
  187611
  710587
  561589
  193874
  384967
  391656
  801860
  466173
  405411
  411750
  563044
  792660
  386189
  388762
  411933
  411615
  476264
  406593
  34486
  726539
  411696
  589665
  397861
  444255
  404684
  409241
  257966
  89362
  617639
  366050
  32999
  410237
  464460
  389623
  411697
  470996
  667012
  788772
  385543
  392779
  358449
  391077
  466026
  239599
  397223
  411572
  717711
  386534
  443822
  382295
  392054
  485460
  188262
  44909
  407378
  465789
  789532
  24855
  382184
  406574
  407703
  411596
  559057
]
4 3.11 ms
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
  3971
  24855
  32999
  34486
  40835
  44909
  89362
  150798
  157194
  183634
  187418
  187611
  187903
  188136
  188262
  188263
  188373
  193874
  232940
  233193
  233710
  239599
  257966
  276696
  358449
  365881
  366050
  382184
  382295
  382802
  383094
  384967
  385469
  385543
  385974
  386189
  386534
  387856
  388762
  389623
  390610
  391077
  391392
  391574
  391576
  391656
  392054
  392779
  392952
  395142
  395579
  395601
  395943
  396425
  397223
  397861
  397873
  397874
  397878
  398935
  404684
  405411
  406574
  406593
  407378
  407396
  407703
  409241
  409310
  410237
  411347
  411572
  411596
  411615
  411696
  411697
  411750
  411933
  413456
  418900
  443822
  444255
  464460
  465789
  466026
  466173
  470996
  476264
  485460
  486253
  506833
  514757
  520021
  520681
  542781
  559057
  561583
  561589
  563044
  587558
  589665
  604154
  617639
  619235
  665508
  667012
  710587
  717711
  718501
  722301
  726539
  728451
  739955
  774187
  788772
  789532
  789552
  792660
  801860
  808866
]
5 242.51 ms
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
  3971
  24855
  32999
  34486
  40835
  44909
  89362
  150798
  157194
  183634
  187418
  187611
  187903
  188136
  188262
  188263
  188373
  193874
  232940
  233193
  233710
  239599
  257966
  276696
  358449
  365881
  366050
  382184
  382295
  382802
  383094
  384967
  385469
  385543
  385974
  386189
  386534
  387856
  388762
  389623
  390610
  391077
  391392
  391574
  391576
  391656
  392054
  392779
  392952
  395142
  395579
  395601
  395943
  396425
  397223
  397861
  397873
  397874
  397878
  398935
  404684
  405411
  406574
  406593
  407378
  407396
  407703
  409241
  409310
  410237
  411347
  411572
  411596
  411615
  411696
  411697
  411750
  411933
  413456
  418900
  443822
  444255
  464460
  465789
  466026
  466173
  470996
  476264
  485460
  486253
  506833
  514757
  520021
  520681
  542781
  559057
  561583
  561589
  563044
  587558
  589665
  604154
  617639
  619235
  665508
  667012
  710587
  717711
  718501
  722301
  726539
  728451
  739955
  774187
  788772
  789532
  789552
  792660
  801860
  808866
]
6 1.48 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "парен ххх зрелая женщин"
]
7 1.27 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "парен ххх зрелая женщин"
]
8 17.08 ms
SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?
Parameters:
[
  "зять ххх тещу"
  "зять ххх тещу"
  "зять ххх тещу"
  20
]

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.