GET https://search.jues.net/search/embeds/10?q=doggy%20teen%20russian

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.31 ms
(86.38%)
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
  382585
  388280
  389124
  390938
  391675
  402730
  412827
  418133
  422477
  425157
  426075
  426703
  427819
  432380
  432719
  433600
  435401
  443877
  445187
  451557
  453640
  455351
  456222
  456573
  457974
  458063
  458156
  458755
  461333
  461443
  462236
  463331
  463935
  467588
  468222
  470160
  478168
  479178
  481409
  481444
  484301
  484318
  486327
  490328
  495331
  496732
  498910
  502334
  505370
  511487
  512458
  512662
  516527
  518807
  521432
  522087
  524070
  526101
  527810
  533770
  537393
  541251
  541400
  541807
  542173
  544083
  552228
  556474
  558205
  565189
  565496
  573661
  581082
  586638
  586838
  589029
  595882
  600105
  601930
  604342
  604406
  613983
  622887
  624315
  626842
  634950
  645031
  646656
  648622
  651723
  653270
  656488
  656907
  659164
  661658
  673178
  677339
  677344
  678916
  680730
  680808
  685449
  685832
  686271
  686414
  692040
  702150
  705476
  715654
  721680
  723178
  740357
  776397
  781011
  782527
  793892
  805172
  810812
  816607
]
13.20 ms
(7.64%)
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
  604342
  443877
  479178
  484318
  481409
  586638
  432380
  433600
  458156
  463331
  402730
  435401
  461333
  382585
  388280
  391675
  412827
  453640
  461443
  458755
  486327
  512458
  505370
  512662
  527810
  490328
  541807
  565189
  581082
  556474
  565496
  678916
  558205
  586838
  604406
  426703
  427819
  432719
  456222
  457974
  462236
  468222
  418133
  422477
  463935
  467588
  481444
  390938
  445187
  456573
  470160
  478168
  425157
  426075
  451557
  511487
  496732
  498910
  518807
  522087
  541251
  516527
  526101
  484301
  521432
  524070
  455351
  589029
  458063
  541400
  389124
  816607
  533770
  495331
  502334
  537393
  542173
  552228
  544083
  573661
  646656
  651723
  653270
  656488
  659164
  677339
  715654
  645031
  648622
  661658
  686271
  686414
  692040
  702150
  721680
  656907
  673178
  677344
  680730
  680808
  685449
  685832
  705476
  723178
  595882
  626842
  600105
  601930
  613983
  622887
  624315
  634950
  793892
  805172
  810812
  776397
  781011
  782527
  740357
  754040
]
2.62 ms
(1.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "doggy teen russian"
]
2.40 ms
(1.39%)
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
  382585
  388280
  389124
  390938
  391675
  402730
  412827
  418133
  422477
  425157
  426075
  426703
  427819
  432380
  432719
  433600
  435401
  443877
  445187
  451557
  453640
  455351
  456222
  456573
  457974
  458063
  458156
  458755
  461333
  461443
  462236
  463331
  463935
  467588
  468222
  470160
  478168
  479178
  481409
  481444
  484301
  484318
  486327
  490328
  495331
  496732
  498910
  502334
  505370
  511487
  512458
  512662
  516527
  518807
  521432
  522087
  524070
  526101
  527810
  533770
  537393
  541251
  541400
  541807
  542173
  544083
  552228
  556474
  558205
  565189
  565496
  573661
  581082
  586638
  586838
  589029
  595882
  600105
  601930
  604342
  604406
  613983
  622887
  624315
  626842
  634950
  645031
  646656
  648622
  651723
  653270
  656488
  656907
  659164
  661658
  673178
  677339
  677344
  678916
  680730
  680808
  685449
  685832
  686271
  686414
  692040
  702150
  705476
  715654
  721680
  723178
  740357
  776397
  781011
  782527
  793892
  805172
  810812
  816607
]
1.95 ms
(1.13%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "рак teen русск"
]
1.76 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рак teen русск"
]
1.61 ms
(0.93%)
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.