GET https://search.jues.net/search/embeds/2?q=beach%20solo

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.94 ms
(86.21%)
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
  423916
  427057
  454516
  454707
  457638
  465432
  468925
  488213
  497125
  501475
  516024
  516035
  528985
  528988
  529571
  529997
  530094
  530405
  533824
  534335
  534353
  534628
  534634
  534635
  535391
  537615
  541669
  541750
  542112
  542721
  544980
  545761
  550013
  552711
  552713
  558106
  558145
  563107
  576480
  577007
  581276
  582014
  584593
  599402
  599406
  606079
  611485
  613158
  614844
  614848
  619094
  621041
  633034
  634345
  634369
  640872
  640904
  647219
  650258
  651163
  651651
  652299
  652357
  661000
  661330
  661378
  669874
  670762
  680741
  680931
  680933
  680937
  680945
  680946
  680950
  680968
  680969
  692713
  692751
  696776
  703228
  713167
  732923
  732926
  738433
  739220
  749359
  749576
  749829
  750935
  752148
  763740
  768057
  768969
  776082
  776637
  781413
  781919
  786198
  792871
  798805
  798825
  798842
  803684
  803839
  803841
  804263
  804353
  804416
  804605
  804652
  804899
  810644
  811869
  811897
  812241
  812285
  812286
  812485
  813899
]
13.97 ms
(7.58%)
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
  534634
  528985
  534628
  529571
  541750
  582014
  552711
  552713
  651651
  661330
  669874
  680931
  670762
  692751
  703228
  661000
  680969
  599406
  613158
  786198
  804416
  750935
  812285
  781919
  804263
  804899
  696776
  516035
  534635
  530094
  535391
  542112
  542721
  652357
  652299
  651163
  680950
  680968
  634369
  599402
  619094
  606079
  614848
  812241
  803684
  803839
  749829
  732923
  465432
  680741
  558106
  752148
  501475
  427057
  454516
  497125
  530405
  534353
  541669
  576480
  558145
  647219
  661378
  680933
  680945
  692713
  713167
  792871
  811897
  739220
  768057
  768969
  798842
  804353
  634345
  537615
  488213
  584593
  545761
  550013
  650258
  680946
  633034
  640904
  611485
  621041
  640872
  776637
  811869
  812485
  803841
  804652
  781413
  798805
  812286
  763740
  738433
  749359
  732926
  614844
  776082
  798825
  528988
  454707
  529997
  534335
  749576
  804605
  810644
  457638
  516024
  423916
  813899
  468925
  533824
  544980
  577007
  563107
  581276
  680937
]
4.30 ms
(2.33%)
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
  423916
  427057
  454516
  454707
  457638
  465432
  468925
  488213
  497125
  501475
  516024
  516035
  528985
  528988
  529571
  529997
  530094
  530405
  533824
  534335
  534353
  534628
  534634
  534635
  535391
  537615
  541669
  541750
  542112
  542721
  544980
  545761
  550013
  552711
  552713
  558106
  558145
  563107
  576480
  577007
  581276
  582014
  584593
  599402
  599406
  606079
  611485
  613158
  614844
  614848
  619094
  621041
  633034
  634345
  634369
  640872
  640904
  647219
  650258
  651163
  651651
  652299
  652357
  661000
  661330
  661378
  669874
  670762
  680741
  680931
  680933
  680937
  680945
  680946
  680950
  680968
  680969
  692713
  692751
  696776
  703228
  713167
  732923
  732926
  738433
  739220
  749359
  749576
  749829
  750935
  752148
  763740
  768057
  768969
  776082
  776637
  781413
  781919
  786198
  792871
  798805
  798825
  798842
  803684
  803839
  803841
  804263
  804353
  804416
  804605
  804652
  804899
  810644
  811869
  811897
  812241
  812285
  812286
  812485
  813899
]
1.92 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beach solo"
]
1.83 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пляж природ соло"
]
1.62 ms
(0.88%)
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.