Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
214.31 ms
(52.20%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen соло close up"
]
170.07 ms
(41.43%)
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
  383406
  384054
  389897
  392839
  397569
  413234
  416527
  416581
  416599
  416693
  416703
  419833
  419834
  420900
  423435
  424011
  424239
  425243
  425607
  427367
  427914
  428848
  432335
  434903
  436046
  436900
  438710
  439033
  439135
  439323
  439396
  443516
  447847
  449940
  452729
  452840
  453216
  457807
  462681
  478029
  489326
  493717
  493834
  504075
  507956
  510554
  513816
  516596
  521145
  530969
  531588
  534538
  536100
  538024
  538540
  539287
  540891
  542705
  542711
  544132
  544140
  558402
  562578
  564514
  565480
  568471
  570130
  572655
  587285
  592330
  594303
  594389
  595484
  596606
  602694
  618231
  618447
  621252
  627252
  642048
  644036
  650727
  651059
  655297
  656197
  656842
  658796
  667033
  674220
  679445
  686138
  694660
  703277
  709562
  709693
  713298
  722428
  723474
  727265
  736813
  745457
  750539
  757514
  765684
  766867
  766939
  768246
  776524
  778721
  782543
  782547
  785781
  786088
  787808
  792092
  793292
  803105
  803504
  806597
  824158
]
17.41 ms
(4.24%)
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
  642048
  644036
  703277
  787808
  793292
  397569
  420900
  427367
  436900
  542705
  658796
  427914
  478029
  565480
  542711
  568471
  489326
  507956
  587285
  416599
  570130
  621252
  383406
  434903
  438710
  540891
  493717
  504075
  530969
  538540
  510554
  534538
  536100
  538024
  531588
  539287
  493834
  544140
  558402
  562578
  544132
  650727
  651059
  656842
  667033
  674220
  686138
  713298
  722428
  655297
  656197
  679445
  694660
  709562
  564514
  572655
  618447
  595484
  596606
  592330
  594303
  776524
  782547
  806597
  803105
  782543
  786088
  727265
  757514
  766939
  736813
  766867
  745457
  750539
  765684
  768246
  602694
  618231
  627252
  723474
  778721
  785781
  792092
  803504
  439323
  392839
  436046
  428848
  516596
  439135
  416703
  443516
  521145
  513816
  594389
  709693
  416581
  439033
  416693
  423435
  384054
  389897
  413234
  424011
  416527
  419834
  439396
  419833
  424239
  425243
  432335
  425607
  824158
  447847
  462681
  452729
  452840
  449940
  453216
  457807
]
3.13 ms
(0.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
  383406
  384054
  389897
  392839
  397569
  413234
  416527
  416581
  416599
  416693
  416703
  419833
  419834
  420900
  423435
  424011
  424239
  425243
  425607
  427367
  427914
  428848
  432335
  434903
  436046
  436900
  438710
  439033
  439135
  439323
  439396
  443516
  447847
  449940
  452729
  452840
  453216
  457807
  462681
  478029
  489326
  493717
  493834
  504075
  507956
  510554
  513816
  516596
  521145
  530969
  531588
  534538
  536100
  538024
  538540
  539287
  540891
  542705
  542711
  544132
  544140
  558402
  562578
  564514
  565480
  568471
  570130
  572655
  587285
  592330
  594303
  594389
  595484
  596606
  602694
  618231
  618447
  621252
  627252
  642048
  644036
  650727
  651059
  655297
  656197
  656842
  658796
  667033
  674220
  679445
  686138
  694660
  703277
  709562
  709693
  713298
  722428
  723474
  727265
  736813
  745457
  750539
  757514
  765684
  766867
  766939
  768246
  776524
  778721
  782543
  782547
  785781
  786088
  787808
  792092
  793292
  803105
  803504
  806597
  824158
]
2.21 ms
(0.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen solo close-up"
]
1.76 ms
(0.43%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen соло close up"
]

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.