GET https://search.jues.net/search/embeds/6?q=girl%20beach

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
212.16 ms
(58.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк пляж природ"
]
128.16 ms
(35.05%)
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
  28294
  365933
  384270
  395803
  399710
  413949
  420651
  435740
  446550
  447363
  451853
  454707
  456844
  457638
  457716
  457728
  458419
  465423
  468925
  468926
  468947
  469233
  469244
  471759
  476489
  486818
  487387
  488213
  494281
  516024
  516138
  520173
  528730
  529997
  533824
  534335
  534540
  535897
  539353
  542829
  547940
  550714
  553493
  574248
  577678
  578103
  579720
  585250
  593619
  610731
  614840
  614844
  618009
  621041
  628301
  628772
  633206
  633708
  634358
  634362
  640872
  640904
  644083
  644585
  650258
  651325
  658809
  662214
  672181
  674514
  677267
  680946
  685513
  693244
  696381
  703093
  709117
  714002
  714056
  716939
  719057
  719528
  720382
  720481
  722021
  722660
  724084
  729567
  732926
  734123
  736494
  738433
  749359
  749576
  761143
  763740
  766121
  769077
  772204
  774349
  774350
  783535
  786238
  788935
  791492
  792213
  793683
  794625
  797749
  798805
  798825
  799712
  801728
  803841
  804605
  804652
  810644
  811869
  812286
  813899
]
16.47 ms
(4.50%)
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
  662214
  658809
  651325
  709117
  621041
  640872
  803841
  734123
  766121
  763740
  738433
  732926
  435740
  535897
  486818
  736494
  469233
  451853
  547940
  516024
  716939
  792213
  761143
  579720
  454707
  487387
  520173
  528730
  722660
  578103
  384270
  468926
  465423
  539353
  468947
  488213
  696381
  650258
  680946
  614840
  593619
  640904
  634362
  786238
  811869
  804652
  793683
  798805
  799712
  801728
  812286
  774349
  724084
  749359
  772204
  614844
  633708
  722021
  794625
  798825
  413949
  457728
  420651
  457716
  529997
  534335
  677267
  714002
  714056
  719057
  634358
  644585
  769077
  749576
  395803
  469244
  471759
  446550
  456844
  457638
  813899
  458419
  633206
  365933
  468925
  533824
  553493
  672181
  685513
  720481
  618009
  610731
  788935
  797749
  774350
  628301
  791492
  399710
  28294
  516138
  534540
  494281
  550714
  577678
  628772
  644083
  729567
  783535
  804605
  810644
  447363
  476489
  542829
  574248
  719528
  720382
  693244
  703093
  674514
  585250
]
3.13 ms
(0.86%)
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
  28294
  365933
  384270
  395803
  399710
  413949
  420651
  435740
  446550
  447363
  451853
  454707
  456844
  457638
  457716
  457728
  458419
  465423
  468925
  468926
  468947
  469233
  469244
  471759
  476489
  486818
  487387
  488213
  494281
  516024
  516138
  520173
  528730
  529997
  533824
  534335
  534540
  535897
  539353
  542829
  547940
  550714
  553493
  574248
  577678
  578103
  579720
  585250
  593619
  610731
  614840
  614844
  618009
  621041
  628301
  628772
  633206
  633708
  634358
  634362
  640872
  640904
  644083
  644585
  650258
  651325
  658809
  662214
  672181
  674514
  677267
  680946
  685513
  693244
  696381
  703093
  709117
  714002
  714056
  716939
  719057
  719528
  720382
  720481
  722021
  722660
  724084
  729567
  732926
  734123
  736494
  738433
  749359
  749576
  761143
  763740
  766121
  769077
  772204
  774349
  774350
  783535
  786238
  788935
  791492
  792213
  793683
  794625
  797749
  798805
  798825
  799712
  801728
  803841
  804605
  804652
  810644
  811869
  812286
  813899
]
2.10 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girl beach"
]
1.94 ms
(0.53%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(0.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.