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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
117.50 ms
(81.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
  12792
  235834
  282006
  382017
  382456
  384856
  393127
  393731
  393732
  394197
  396891
  398390
  399194
  399223
  399332
  400422
  400438
  401142
  401306
  401343
  402245
  403060
  404264
  405567
  411958
  413197
  417429
  429249
  445039
  462500
  462579
  463141
  467364
  468013
  470703
  476155
  485308
  485489
  491646
  492392
  495372
  509965
  512679
  513036
  514386
  515285
  521854
  525671
  526038
  528344
  529206
  542972
  543547
  546001
  549296
  550620
  562119
  564440
  565332
  567002
  567151
  567159
  568573
  569678
  571188
  571214
  572197
  575723
  578481
  581697
  581703
  596585
  600793
  627818
  629293
  634545
  637692
  649996
  656739
  658413
  659608
  665027
  667323
  670081
  670175
  676453
  677056
  679385
  682022
  683538
  683825
  686040
  689757
  697307
  700663
  707329
  714455
  715323
  720435
  722654
  722662
  722665
  723406
  728350
  729890
  735800
  741999
  743144
  744298
  755746
  778550
  789210
  792722
  795286
  804113
  809053
  812361
  814065
  825563
]
17.71 ms
(12.27%)
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
  707329
  384856
  399194
  417429
  513036
  677056
  637692
  741999
  722662
  670175
  543547
  600793
  467364
  445039
  812361
  722665
  393732
  413197
  526038
  667323
  700663
  800948
  399332
  401142
  485489
  581703
  542972
  572197
  679385
  562119
  462500
  400438
  462579
  495372
  512679
  521854
  528344
  529206
  659608
  686040
  689757
  656739
  658413
  629293
  404264
  578481
  401343
  569678
  567151
  509965
  665027
  729890
  755746
  735800
  792722
  396891
  401306
  470703
  575723
  567002
  571188
  581697
  715323
  596585
  627818
  778550
  393731
  394197
  429249
  468013
  235834
  393127
  398390
  405567
  476155
  515285
  485308
  568573
  565332
  567159
  514386
  492392
  491646
  382017
  720435
  743144
  403060
  714455
  546001
  634545
  282006
  697307
  814065
  550620
  683538
  682022
  683825
  722654
  723406
  649996
  670081
  789210
  795286
  728350
  744298
  804113
  809053
  402245
  525671
  382456
  564440
  676453
  571214
  463141
  400422
  12792
  399223
  411958
  825563
  549296
]
2.31 ms
(1.60%)
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
  12792
  235834
  282006
  382017
  382456
  384856
  393127
  393731
  393732
  394197
  396891
  398390
  399194
  399223
  399332
  400422
  400438
  401142
  401306
  401343
  402245
  403060
  404264
  405567
  411958
  413197
  417429
  429249
  445039
  462500
  462579
  463141
  467364
  468013
  470703
  476155
  485308
  485489
  491646
  492392
  495372
  509965
  512679
  513036
  514386
  515285
  521854
  525671
  526038
  528344
  529206
  542972
  543547
  546001
  549296
  550620
  562119
  564440
  565332
  567002
  567151
  567159
  568573
  569678
  571188
  571214
  572197
  575723
  578481
  581697
  581703
  596585
  600793
  627818
  629293
  634545
  637692
  649996
  656739
  658413
  659608
  665027
  667323
  670081
  670175
  676453
  677056
  679385
  682022
  683538
  683825
  686040
  689757
  697307
  700663
  707329
  714455
  715323
  720435
  722654
  722662
  722665
  723406
  728350
  729890
  735800
  741999
  743144
  744298
  755746
  778550
  789210
  792722
  795286
  804113
  809053
  812361
  814065
  825563
]
2.10 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful young girl"
]
1.78 ms
(1.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(1.09%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая young девушк"
]
1.42 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "красивая young девушк"
]

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.