GET https://search.jues.net/search/embeds/5?q=public%2018%20teen

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.02 ms
(86.13%)
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
  282494
  385111
  385267
  385909
  387423
  388401
  392216
  393660
  396786
  397104
  397475
  398577
  398882
  401317
  401939
  413258
  415254
  434709
  435664
  441430
  441567
  448543
  453790
  456469
  466061
  468603
  484070
  490982
  491487
  492553
  497454
  499774
  506548
  509892
  510687
  514946
  526136
  526765
  527507
  527514
  527550
  528985
  528988
  529061
  534127
  535664
  537686
  537958
  539099
  540705
  540922
  542453
  552171
  560696
  568478
  573839
  575647
  576051
  576316
  579455
  594381
  595458
  595501
  595873
  598013
  598539
  605329
  606792
  617653
  618072
  618449
  627835
  631311
  646439
  647634
  650692
  656938
  659282
  670760
  680200
  684393
  685523
  685525
  685531
  687718
  690346
  690446
  690455
  691911
  696004
  698435
  707278
  711422
  736841
  743188
  745142
  751500
  753339
  753360
  753761
  754214
  757017
  770577
  776918
  777643
  783748
  784260
  785404
  788309
  791770
  794924
  805228
  807545
  813599
  817400
  817596
  817602
  817673
  828593
]
14.65 ms
(7.93%)
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
  828593
  711422
  385267
  534127
  691911
  556732
  807545
  783748
  398577
  568478
  595873
  401939
  528985
  527514
  656938
  777643
  745142
  491487
  468603
  484070
  526136
  680200
  595501
  753339
  753360
  388401
  605329
  751500
  392216
  529061
  415254
  510687
  595458
  598013
  435664
  618449
  490982
  492553
  817602
  817400
  817596
  817673
  542453
  687718
  646439
  757017
  736841
  743188
  753761
  385909
  685531
  618072
  805228
  631311
  499774
  552171
  627835
  788309
  560696
  684393
  647634
  690346
  690446
  698435
  707278
  794924
  770577
  776918
  785404
  401317
  535664
  540922
  670760
  690455
  573839
  594381
  617653
  576051
  506548
  527507
  528988
  526765
  539099
  650692
  385111
  397475
  791770
  393660
  387423
  397104
  398882
  434709
  441567
  466061
  453790
  537958
  514946
  598539
  441430
  396786
  456469
  282494
  413258
  497454
  448543
  537686
  540705
  575647
  579455
  685523
  685525
  696004
  606792
  813599
  576316
  659282
  754214
  784260
  527550
  509892
]
3.13 ms
(1.69%)
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
  282494
  385111
  385267
  385909
  387423
  388401
  392216
  393660
  396786
  397104
  397475
  398577
  398882
  401317
  401939
  413258
  415254
  434709
  435664
  441430
  441567
  448543
  453790
  456469
  466061
  468603
  484070
  490982
  491487
  492553
  497454
  499774
  506548
  509892
  510687
  514946
  526136
  526765
  527507
  527514
  527550
  528985
  528988
  529061
  534127
  535664
  537686
  537958
  539099
  540705
  540922
  542453
  552171
  560696
  568478
  573839
  575647
  576051
  576316
  579455
  594381
  595458
  595501
  595873
  598013
  598539
  605329
  606792
  617653
  618072
  618449
  627835
  631311
  646439
  647634
  650692
  656938
  659282
  670760
  680200
  684393
  685523
  685525
  685531
  687718
  690346
  690446
  690455
  691911
  696004
  698435
  707278
  711422
  736841
  743188
  745142
  751500
  753339
  753360
  753761
  754214
  757017
  770577
  776918
  777643
  783748
  784260
  785404
  788309
  791770
  794924
  805228
  807545
  813599
  817400
  817596
  817602
  817673
  828593
]
2.47 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public 18 teen"
]
1.95 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на 18 улиц teen"
]
1.84 ms
(1.00%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на 18 улиц teen"
]

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.