GET https://search.jues.net/search/embeds/5?q=sex%20muscle

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
159.70 ms
(86.55%)
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
  12090
  13229
  16744
  24289
  24724
  29242
  31134
  32874
  34645
  37495
  38637
  56639
  67112
  96862
  101841
  111630
  116603
  122554
  123554
  129791
  131975
  145053
  150507
  154497
  170942
  185011
  186988
  187819
  191336
  191361
  191509
  191599
  194903
  200708
  205205
  207775
  214139
  214663
  232973
  233862
  239542
  266184
  308331
  318318
  335196
  382202
  382213
  382344
  382362
  382746
  382943
  383088
  383592
  384232
  384520
  384872
  384888
  385342
  385605
  385851
  386092
  386648
  386778
  386879
  387723
  387953
  388121
  388149
  388519
  388951
  389385
  389594
  391221
  392459
  393469
  393694
  393701
  394190
  394282
  395275
  395428
  395504
  396242
  396543
  396697
  396859
  396954
  397170
  397255
  397307
  397808
  397851
  397927
  398260
  398674
  399405
  399757
  401925
  410056
  417879
  417884
  419126
  421259
  425866
  451497
  540497
  544342
  549369
  552049
  560070
  560090
  587026
  612062
  619211
  630861
  634492
  667160
  688675
  698526
  809487
]
14.66 ms
(7.95%)
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
  382344
  389385
  233862
  396242
  111630
  417884
  401925
  397307
  417879
  549369
  612062
  630861
  194903
  101841
  397851
  391221
  397808
  382943
  145053
  214139
  32874
  16744
  388519
  387723
  540497
  395504
  384872
  308331
  382213
  24724
  131975
  388149
  419126
  560090
  552049
  688675
  187819
  191361
  451497
  383088
  383592
  154497
  191336
  185011
  395275
  34645
  31134
  387953
  398260
  399757
  619211
  809487
  38637
  116603
  200708
  232973
  388121
  394190
  37495
  386778
  382202
  56639
  667160
  587026
  122554
  335196
  191509
  266184
  205205
  393694
  396543
  123554
  129791
  382362
  386648
  385851
  67112
  150507
  186988
  170942
  29242
  388951
  389594
  399405
  425866
  560070
  397255
  239542
  393469
  396859
  13229
  385605
  394282
  318318
  12090
  386879
  634492
  207775
  421259
  384520
  385342
  24289
  396697
  396954
  397927
  544342
  698526
  96862
  384232
  398674
  397170
  410056
  386092
  382746
  384888
  214663
  191599
  393701
  392459
  395428
]
3.42 ms
(1.85%)
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
  12090
  13229
  16744
  24289
  24724
  29242
  31134
  32874
  34645
  37495
  38637
  56639
  67112
  96862
  101841
  111630
  116603
  122554
  123554
  129791
  131975
  145053
  150507
  154497
  170942
  185011
  186988
  187819
  191336
  191361
  191509
  191599
  194903
  200708
  205205
  207775
  214139
  214663
  232973
  233862
  239542
  266184
  308331
  318318
  335196
  382202
  382213
  382344
  382362
  382746
  382943
  383088
  383592
  384232
  384520
  384872
  384888
  385342
  385605
  385851
  386092
  386648
  386778
  386879
  387723
  387953
  388121
  388149
  388519
  388951
  389385
  389594
  391221
  392459
  393469
  393694
  393701
  394190
  394282
  395275
  395428
  395504
  396242
  396543
  396697
  396859
  396954
  397170
  397255
  397307
  397808
  397851
  397927
  398260
  398674
  399405
  399757
  401925
  410056
  417879
  417884
  419126
  421259
  425866
  451497
  540497
  544342
  549369
  552049
  560070
  560090
  587026
  612062
  619211
  630861
  634492
  667160
  688675
  698526
  809487
]
1.82 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex muscle"
]
1.77 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс мускулистые"
]
1.46 ms
(0.79%)
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.