GET https://search.jues.net/search/embeds/4?q=sport%20ass%20anal

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
141.24 ms
(78.75%)
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
  6863
  307633
  394808
  396501
  403424
  407799
  408278
  409948
  410687
  411201
  413768
  415963
  420212
  423493
  435054
  436314
  437474
  445533
  445646
  451735
  452886
  454679
  454788
  457904
  457943
  464857
  465613
  469294
  472237
  474279
  476119
  476142
  491603
  493245
  496160
  513482
  513488
  513557
  513826
  518624
  520969
  521837
  522970
  523851
  523863
  524939
  525442
  529272
  529995
  531677
  532743
  532781
  533015
  533218
  538498
  538870
  540943
  544861
  550060
  551431
  561659
  565491
  570219
  573191
  584913
  585959
  589045
  589472
  598194
  602014
  614718
  619645
  620575
  626144
  627708
  631187
  632358
  634849
  637755
  641003
  641070
  646244
  659164
  662870
  668533
  669207
  689012
  697449
  716409
  720223
  722214
  723735
  727666
  733896
  740982
  749329
  757368
  758599
  771349
  775178
  777074
  787332
  788835
  788838
  788851
  788852
  788864
  792171
  799767
  801881
  802049
  804498
  805936
  812979
  813235
  813496
  816938
  818516
  819104
  822306
]
28.06 ms
(15.65%)
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
  788864
  723735
  788835
  757368
  632358
  787332
  788838
  518624
  408278
  476142
  544861
  689012
  403424
  513557
  521837
  496160
  411201
  646244
  396501
  423493
  822306
  573191
  602014
  801881
  513826
  802049
  561659
  570219
  454679
  520969
  457904
  619645
  589045
  775178
  799767
  792171
  522970
  524939
  493245
  407799
  585959
  394808
  413768
  533218
  532781
  598194
  805936
  813496
  788852
  733896
  777074
  727666
  538498
  669207
  454788
  476119
  409948
  472237
  437474
  420212
  474279
  445646
  525442
  513488
  410687
  445533
  452886
  532743
  662870
  668533
  716409
  589472
  626144
  634849
  614718
  627708
  788851
  812979
  641003
  804498
  813235
  307633
  513482
  584913
  540943
  533015
  551431
  620575
  641070
  816938
  818516
  538870
  531677
  659164
  722214
  720223
  697449
  631187
  758599
  771349
  749329
  740982
  637755
  415963
  464857
  565491
  436314
  465613
  435054
  523863
  523851
  529272
  469294
  550060
  6863
  819104
  451735
  457943
  491603
  529995
]
2.90 ms
(1.62%)
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
  6863
  307633
  394808
  396501
  403424
  407799
  408278
  409948
  410687
  411201
  413768
  415963
  420212
  423493
  435054
  436314
  437474
  445533
  445646
  451735
  452886
  454679
  454788
  457904
  457943
  464857
  465613
  469294
  472237
  474279
  476119
  476142
  491603
  493245
  496160
  513482
  513488
  513557
  513826
  518624
  520969
  521837
  522970
  523851
  523863
  524939
  525442
  529272
  529995
  531677
  532743
  532781
  533015
  533218
  538498
  538870
  540943
  544861
  550060
  551431
  561659
  565491
  570219
  573191
  584913
  585959
  589045
  589472
  598194
  602014
  614718
  619645
  620575
  626144
  627708
  631187
  632358
  634849
  637755
  641003
  641070
  646244
  659164
  662870
  668533
  669207
  689012
  697449
  716409
  720223
  722214
  723735
  727666
  733896
  740982
  749329
  757368
  758599
  771349
  775178
  777074
  787332
  788835
  788838
  788851
  788852
  788864
  792171
  799767
  801881
  802049
  804498
  805936
  812979
  813235
  813496
  816938
  818516
  819104
  822306
]
2.09 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sport ass anal"
]
1.85 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "спортивная жоп анал"
]
1.56 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.