GET https://search.jues.net/search/embeds/5?q=girls%20out

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.78 ms
(82.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
  313222
  376519
  385282
  388005
  424262
  426234
  434025
  447753
  457503
  479982
  492663
  495333
  496467
  500234
  507272
  529686
  530149
  533808
  534635
  539787
  542404
  542726
  547761
  554133
  554991
  556953
  565515
  585285
  586196
  588021
  588606
  598587
  604966
  606826
  611368
  612373
  613611
  614006
  618506
  620968
  627239
  627418
  630583
  631093
  631390
  631396
  633974
  637231
  645604
  648195
  648895
  653386
  656167
  661387
  666100
  667805
  678661
  680744
  680825
  682410
  685933
  691268
  697234
  700176
  701801
  703684
  706020
  707980
  710465
  715407
  715743
  718282
  719147
  719173
  720208
  722060
  723139
  726273
  728283
  729031
  729316
  729458
  730418
  739800
  740794
  740858
  744532
  746090
  747858
  748279
  753171
  757328
  757635
  761305
  761384
  762911
  769069
  774443
  774665
  775395
  780378
  780630
  783798
  784650
  784962
  788577
  793673
  794143
  803762
  815502
  816765
  818428
  819802
  821587
  822846
  823052
  824468
  825005
  825016
  825131
]
14.44 ms
(10.06%)
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
  313222
  507272
  825131
  530149
  666100
  661387
  627418
  598587
  747858
  728283
  729458
  385282
  434025
  533808
  565515
  554133
  554991
  678661
  648895
  720208
  645604
  618506
  631093
  774665
  803762
  784962
  740858
  748279
  726273
  744532
  757328
  746090
  753171
  604966
  703684
  706020
  722060
  457503
  495333
  627239
  631396
  719147
  784650
  729031
  388005
  818428
  819802
  822846
  825016
  447753
  500234
  534635
  529686
  556953
  691268
  707980
  697234
  700176
  715743
  723139
  656167
  667805
  585285
  630583
  588606
  780630
  783798
  794143
  788577
  793673
  740794
  761384
  729316
  730418
  761305
  769069
  739800
  757635
  762911
  701801
  424262
  426234
  492663
  496467
  376519
  821587
  823052
  774443
  816765
  815502
  825005
  824468
  479982
  539787
  542404
  542726
  547761
  682410
  715407
  648195
  680825
  710465
  653386
  680744
  685933
  718282
  719173
  586196
  588021
  606826
  614006
  612373
  620968
  637231
  611368
  613611
  633974
  631390
  775395
  780378
]
2.90 ms
(2.02%)
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
  313222
  376519
  385282
  388005
  424262
  426234
  434025
  447753
  457503
  479982
  492663
  495333
  496467
  500234
  507272
  529686
  530149
  533808
  534635
  539787
  542404
  542726
  547761
  554133
  554991
  556953
  565515
  585285
  586196
  588021
  588606
  598587
  604966
  606826
  611368
  612373
  613611
  614006
  618506
  620968
  627239
  627418
  630583
  631093
  631390
  631396
  633974
  637231
  645604
  648195
  648895
  653386
  656167
  661387
  666100
  667805
  678661
  680744
  680825
  682410
  685933
  691268
  697234
  700176
  701801
  703684
  706020
  707980
  710465
  715407
  715743
  718282
  719147
  719173
  720208
  722060
  723139
  726273
  728283
  729031
  729316
  729458
  730418
  739800
  740794
  740858
  744532
  746090
  747858
  748279
  753171
  757328
  757635
  761305
  761384
  762911
  769069
  774443
  774665
  775395
  780378
  780630
  783798
  784650
  784962
  788577
  793673
  794143
  803762
  815502
  816765
  818428
  819802
  821587
  822846
  823052
  824468
  825005
  825016
  825131
]
1.94 ms
(1.35%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк out"
]
1.87 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girls out"
]
1.86 ms
(1.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк out"
]

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.