GET https://search.jues.net/search/embeds/7?q=sex%20machine%20teens

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.74 ms
(85.39%)
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
  410682
  413381
  413398
  413406
  413432
  414116
  415877
  416600
  418144
  421052
  428280
  430066
  432268
  435689
  438464
  439427
  443086
  443234
  443236
  443239
  443244
  446547
  447318
  449208
  450357
  452430
  456705
  458099
  462942
  465054
  466443
  466739
  469124
  469198
  470633
  471155
  471357
  471455
  475406
  479544
  479726
  480209
  482280
  482291
  486776
  487535
  497401
  501958
  511893
  514115
  514867
  517710
  518183
  518185
  518210
  518915
  520763
  522161
  530387
  532739
  537250
  538669
  540348
  542904
  543864
  545117
  545390
  548538
  548550
  560405
  560408
  560425
  560427
  570721
  574685
  579337
  582377
  590349
  591217
  593470
  594113
  596693
  602614
  604229
  606817
  616315
  624942
  625177
  628094
  631330
  644276
  709917
  716394
  716496
  728370
  734840
  738471
  738496
  739165
  744939
  750121
  752636
  752664
  755079
  765668
  766825
  803557
  806580
  806688
  808327
]
17.11 ms
(8.82%)
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
  738471
  766825
  728370
  738496
  739165
  752636
  752664
  765668
  475406
  466443
  471155
  446547
  518185
  518915
  518183
  487535
  522161
  438464
  413406
  443236
  428280
  439427
  415877
  458099
  469124
  482280
  462942
  514867
  540348
  511893
  479544
  479726
  560427
  579337
  543864
  570721
  542904
  560405
  582377
  709917
  545117
  625177
  628094
  590349
  604229
  594113
  606817
  803557
  755079
  806688
  734840
  744939
  750121
  631330
  413398
  421052
  443234
  416600
  480209
  470633
  430066
  497401
  443239
  413381
  435689
  456705
  466739
  447318
  452430
  486776
  517710
  518210
  574685
  716496
  616315
  591217
  624942
  807580
  808327
  432268
  443086
  449208
  413432
  410682
  482291
  465054
  530387
  537250
  548550
  596693
  644276
  593470
  716394
  471455
  414116
  418144
  450357
  532739
  501958
  560425
  545390
  602614
  806580
  443244
  514115
  560408
  548538
  471357
  469198
  520763
  538669
]
3.42 ms
(1.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
  410682
  413381
  413398
  413406
  413432
  414116
  415877
  416600
  418144
  421052
  428280
  430066
  432268
  435689
  438464
  439427
  443086
  443234
  443236
  443239
  443244
  446547
  447318
  449208
  450357
  452430
  456705
  458099
  462942
  465054
  466443
  466739
  469124
  469198
  470633
  471155
  471357
  471455
  475406
  479544
  479726
  480209
  482280
  482291
  486776
  487535
  497401
  501958
  511893
  514115
  514867
  517710
  518183
  518185
  518210
  518915
  520763
  522161
  530387
  532739
  537250
  538669
  540348
  542904
  543864
  545117
  545390
  548538
  548550
  560405
  560408
  560425
  560427
  570721
  574685
  579337
  582377
  590349
  591217
  593470
  594113
  596693
  602614
  604229
  606817
  616315
  624942
  625177
  628094
  631330
  644276
  709917
  716394
  716496
  728370
  734840
  738471
  738496
  739165
  744939
  750121
  752636
  752664
  755079
  765668
  766825
  803557
  806580
  806688
  808327
]
2.07 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сексмашин teens"
]
1.96 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex machine teens"
]
1.90 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.88 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сексмашин teens"
]

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.