GET https://search.jues.net/search/embeds/3?q=yoga%20girl

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
125.59 ms
(83.80%)
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
  39114
  80285
  120208
  307310
  307339
  383681
  383795
  384094
  384772
  384872
  386240
  386856
  387716
  391405
  394309
  396217
  397330
  397832
  398901
  401533
  402483
  403132
  409075
  417162
  418253
  421444
  422910
  427143
  427818
  429434
  435883
  447775
  452784
  453963
  455827
  456044
  460017
  461208
  463604
  465166
  466707
  472819
  477267
  478803
  483681
  493853
  512202
  515048
  521018
  526812
  529919
  532416
  532486
  541091
  553732
  554725
  556582
  559383
  565996
  582072
  582704
  584373
  586073
  613355
  639061
  641534
  645300
  668694
  683758
  690648
  694411
  699245
  709627
  710506
  716001
  716932
  723368
  723369
  724869
  737146
  737734
  740790
  751802
  755521
  757069
  757145
  758554
  764423
  765433
  765768
  768856
  770216
  770958
  771038
  777142
  778027
  778109
  779377
  783764
  786005
  787283
  788221
  789747
  790170
  796236
  798293
  798433
  799140
  801649
  803120
  803969
  804259
  805187
  810349
  810794
  811741
  812587
  814791
  820021
  821444
]
14.31 ms
(9.55%)
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
  764423
  810794
  771038
  788221
  384772
  554725
  401533
  80285
  820021
  463604
  584373
  699245
  779377
  801649
  803969
  810349
  812587
  765433
  778027
  409075
  821444
  798433
  723368
  461208
  716001
  586073
  777142
  799140
  477267
  532486
  427143
  452784
  515048
  529919
  559383
  690648
  716932
  751802
  768856
  740790
  710506
  394309
  421444
  418253
  427818
  483681
  383681
  384872
  39114
  391405
  402483
  814791
  645300
  639061
  778109
  811741
  397832
  512202
  532416
  668694
  613355
  805187
  757145
  770958
  737734
  755521
  386240
  478803
  307310
  422910
  553732
  803120
  455827
  383795
  397330
  694411
  641534
  798293
  789747
  724869
  787283
  403132
  493853
  307339
  398901
  453963
  456044
  460017
  757069
  737146
  396217
  435883
  429434
  120208
  582072
  447775
  783764
  770216
  384094
  417162
  556582
  565996
  796236
  765768
  790170
  386856
  466707
  465166
  541091
  758554
  709627
  786005
  387716
  521018
  472819
  526812
  582704
  723369
  683758
  804259
]
3.34 ms
(2.23%)
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
  39114
  80285
  120208
  307310
  307339
  383681
  383795
  384094
  384772
  384872
  386240
  386856
  387716
  391405
  394309
  396217
  397330
  397832
  398901
  401533
  402483
  403132
  409075
  417162
  418253
  421444
  422910
  427143
  427818
  429434
  435883
  447775
  452784
  453963
  455827
  456044
  460017
  461208
  463604
  465166
  466707
  472819
  477267
  478803
  483681
  493853
  512202
  515048
  521018
  526812
  529919
  532416
  532486
  541091
  553732
  554725
  556582
  559383
  565996
  582072
  582704
  584373
  586073
  613355
  639061
  641534
  645300
  668694
  683758
  690648
  694411
  699245
  709627
  710506
  716001
  716932
  723368
  723369
  724869
  737146
  737734
  740790
  751802
  755521
  757069
  757145
  758554
  764423
  765433
  765768
  768856
  770216
  770958
  771038
  777142
  778027
  778109
  779377
  783764
  786005
  787283
  788221
  789747
  790170
  796236
  798293
  798433
  799140
  801649
  803120
  803969
  804259
  805187
  810349
  810794
  811741
  812587
  814791
  820021
  821444
]
1.85 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "yoga girl"
]
1.69 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "yoga девушк"
]
1.54 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "yoga девушк"
]

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.