GET https://search.jues.net/search/embeds/9?q=big%20girl%20sleeping

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.90 ms
(86.18%)
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
  386345
  398613
  421323
  429321
  429529
  433697
  448315
  463047
  478863
  481994
  496859
  504672
  504770
  510673
  513190
  514767
  516310
  521902
  539049
  541882
  549148
  550720
  561409
  562779
  565177
  566293
  566624
  567628
  568051
  573792
  578838
  580829
  583616
  585728
  586320
  588124
  610275
  617294
  617319
  618504
  622334
  626274
  631390
  632984
  645370
  651957
  654124
  663292
  672161
  676527
  676554
  678017
  678986
  680823
  681663
  684208
  687238
  687579
  689229
  693794
  696106
  697129
  697650
  698039
  699436
  700303
  701392
  703350
  706612
  709326
  710586
  713054
  714290
  714344
  720035
  725580
  726790
  726862
  727251
  727650
  728694
  730481
  730931
  734740
  735806
  736684
  736693
  739268
  741949
  744320
  744462
  746142
  747651
  748682
  751531
  755727
  758197
  763749
  763964
  771742
  774882
  775771
  778329
  779939
  783679
  784762
  787040
  787149
  794712
  798121
  803711
  807425
  811117
  817305
  819340
  824224
  824346
  825283
  825689
  825708
]
14.60 ms
(8.23%)
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
  567628
  478863
  496859
  398613
  421323
  429321
  817305
  825689
  573792
  580829
  583616
  654124
  672161
  687238
  698039
  684208
  696106
  676527
  697650
  706612
  562779
  617294
  617319
  622334
  618504
  725580
  748682
  730931
  739268
  746142
  755727
  758197
  735806
  763964
  700303
  539049
  566624
  386345
  825708
  819340
  824224
  825283
  549148
  561409
  568051
  566293
  663292
  720035
  678017
  681663
  689229
  699436
  714344
  676554
  680823
  703350
  713054
  714290
  626274
  586320
  588124
  631390
  775771
  778329
  783679
  794712
  798121
  811117
  784762
  787149
  803711
  726790
  726862
  728694
  734740
  736684
  730481
  741949
  747651
  727251
  771742
  697129
  701392
  709326
  787040
  516310
  824346
  514767
  550720
  693794
  710586
  645370
  678986
  585728
  610275
  807425
  779939
  763749
  744462
  774882
  433697
  513190
  504672
  504770
  541882
  651957
  736693
  744320
  751531
  510673
  521902
  448315
  463047
  578838
  429529
  565177
  687579
  727650
  632984
  481994
]
2.78 ms
(1.57%)
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
  386345
  398613
  421323
  429321
  429529
  433697
  448315
  463047
  478863
  481994
  496859
  504672
  504770
  510673
  513190
  514767
  516310
  521902
  539049
  541882
  549148
  550720
  561409
  562779
  565177
  566293
  566624
  567628
  568051
  573792
  578838
  580829
  583616
  585728
  586320
  588124
  610275
  617294
  617319
  618504
  622334
  626274
  631390
  632984
  645370
  651957
  654124
  663292
  672161
  676527
  676554
  678017
  678986
  680823
  681663
  684208
  687238
  687579
  689229
  693794
  696106
  697129
  697650
  698039
  699436
  700303
  701392
  703350
  706612
  709326
  710586
  713054
  714290
  714344
  720035
  725580
  726790
  726862
  727251
  727650
  728694
  730481
  730931
  734740
  735806
  736684
  736693
  739268
  741949
  744320
  744462
  746142
  747651
  748682
  751531
  755727
  758197
  763749
  763964
  771742
  774882
  775771
  778329
  779939
  783679
  784762
  787040
  787149
  794712
  798121
  803711
  807425
  811117
  817305
  819340
  824224
  824346
  825283
  825689
  825708
]
1.82 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(1.01%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big girl sleeping"
]
1.78 ms
(1.00%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие девушк спящ"
]
1.74 ms
(0.98%)
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.