GET https://search.jues.net/search/embeds/9?q=two%20sex

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
281.05 ms
(90.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
  147638
  192760
  260297
  373998
  387235
  392989
  393314
  399396
  405936
  406946
  412194
  420655
  431516
  440692
  444526
  447850
  449402
  454725
  461384
  461432
  466555
  468207
  469847
  474205
  475319
  483900
  485277
  493665
  494665
  496038
  497524
  497777
  499746
  499909
  500227
  504200
  505243
  507790
  508470
  514917
  516161
  520545
  521954
  523302
  527427
  530883
  540911
  542793
  546257
  549177
  551149
  552079
  552371
  555042
  560738
  568145
  570822
  571149
  582605
  582949
  583712
  583716
  589146
  589268
  593858
  594988
  599226
  599428
  603656
  608605
  611167
  611563
  614837
  620489
  621977
  624421
  625182
  628589
  651251
  652284
  654275
  654278
  654290
  669768
  669784
  671751
  674467
  676309
  677587
  696102
  706933
  720160
  721006
  721834
  728493
  730466
  735524
  748226
  750746
  752826
  753051
  754956
  756242
  757177
  757372
  772052
  777913
  781301
  782711
  788686
  798671
  800266
  800703
  800879
  804700
  808690
  810492
  813905
  818471
  822642
]
18.49 ms
(5.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
  504200
  521954
  523302
  483900
  497524
  520545
  669784
  599428
  611563
  777913
  782711
  772052
  750746
  752826
  614837
  461384
  494665
  431516
  822642
  447850
  552079
  568145
  651251
  677587
  706933
  671751
  621977
  788686
  798671
  804700
  748226
  810492
  405936
  461432
  508470
  393314
  474205
  560738
  583716
  542793
  551149
  552371
  582949
  676309
  720160
  582605
  628589
  611167
  589146
  593858
  800703
  753051
  808690
  412194
  469847
  147638
  420655
  500227
  449402
  454725
  583712
  696102
  654278
  625182
  599226
  608605
  603656
  620489
  730466
  756242
  721834
  260297
  468207
  499746
  493665
  514917
  555042
  549177
  570822
  589268
  757372
  392989
  813905
  507790
  505243
  530883
  496038
  571149
  540911
  546257
  669768
  674467
  594988
  624421
  800879
  754956
  781301
  728493
  735524
  757177
  721006
  466555
  475319
  499909
  527427
  516161
  485277
  497777
  387235
  818471
  654290
  800266
  192760
  373998
  399396
  406946
  440692
  444526
  654275
  652284
]
2.92 ms
(0.94%)
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
  147638
  192760
  260297
  373998
  387235
  392989
  393314
  399396
  405936
  406946
  412194
  420655
  431516
  440692
  444526
  447850
  449402
  454725
  461384
  461432
  466555
  468207
  469847
  474205
  475319
  483900
  485277
  493665
  494665
  496038
  497524
  497777
  499746
  499909
  500227
  504200
  505243
  507790
  508470
  514917
  516161
  520545
  521954
  523302
  527427
  530883
  540911
  542793
  546257
  549177
  551149
  552079
  552371
  555042
  560738
  568145
  570822
  571149
  582605
  582949
  583712
  583716
  589146
  589268
  593858
  594988
  599226
  599428
  603656
  608605
  611167
  611563
  614837
  620489
  621977
  624421
  625182
  628589
  651251
  652284
  654275
  654278
  654290
  669768
  669784
  671751
  674467
  676309
  677587
  696102
  706933
  720160
  721006
  721834
  728493
  730466
  735524
  748226
  750746
  752826
  753051
  754956
  756242
  757177
  757372
  772052
  777913
  781301
  782711
  788686
  798671
  800266
  800703
  800879
  804700
  808690
  810492
  813905
  818471
  822642
]
2.46 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "two sex"
]
2.39 ms
(0.77%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.21 ms
(0.71%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "two секс"
]
1.44 ms
(0.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "two секс"
]

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.