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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
204.96 ms
(88.62%)
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
  379600
  400852
  421914
  428716
  428814
  428883
  428884
  431675
  432843
  432990
  443092
  443184
  444288
  445707
  446455
  447023
  447340
  447487
  447751
  447807
  448211
  452628
  453436
  453802
  458061
  459476
  459705
  466076
  468574
  474378
  475948
  477274
  478875
  479632
  481449
  482997
  483044
  486740
  487654
  489601
  490097
  490474
  491488
  491931
  492168
  494181
  494584
  495574
  495584
  500725
  502118
  503089
  505911
  507817
  508245
  509819
  509972
  510759
  514118
  514383
  514781
  516930
  518207
  518937
  518961
  519319
  519337
  520198
  521353
  521516
  521905
  522230
  522689
  522710
  523584
  523786
  525966
  526818
  527064
  527192
  528112
  528788
  529249
  535610
  545659
  549153
  549822
  551620
  552296
  558844
  559080
  559791
  560063
  560608
  561692
  563735
  566089
  566929
  568123
  571501
  575785
  575792
  576036
  597557
  598602
  599371
  601894
  601988
  603482
  605952
  609252
  609681
  611572
  620100
  697892
  722894
  726882
  770928
  796507
  799941
]
16.59 ms
(7.17%)
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
  495584
  428814
  500725
  571501
  379600
  432990
  443184
  444288
  514118
  560608
  561692
  576036
  566089
  478875
  428716
  468574
  522710
  519319
  527192
  482997
  535610
  432843
  521516
  563735
  566929
  558844
  575792
  568123
  603482
  447751
  447340
  466076
  459476
  502118
  518937
  491931
  483044
  609252
  522230
  552296
  446455
  486740
  520198
  605952
  528788
  545659
  559791
  601894
  609681
  611572
  443092
  477274
  474378
  509819
  521353
  523786
  525966
  489601
  514383
  521905
  522689
  492168
  549153
  697892
  599371
  770928
  726882
  458061
  421914
  453436
  453802
  475948
  503089
  495574
  510759
  487654
  490474
  518207
  529249
  494584
  494181
  620100
  575785
  551620
  560063
  722894
  559080
  598602
  601988
  799941
  428884
  479632
  481449
  452628
  447487
  448211
  447023
  518961
  527064
  505911
  514781
  528112
  526818
  507817
  523584
  796507
  549822
  597557
  400852
  428883
  445707
  459705
  519337
  516930
  447807
  431675
  490097
  508245
  491488
  509972
]
3.03 ms
(1.31%)
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
  379600
  400852
  421914
  428716
  428814
  428883
  428884
  431675
  432843
  432990
  443092
  443184
  444288
  445707
  446455
  447023
  447340
  447487
  447751
  447807
  448211
  452628
  453436
  453802
  458061
  459476
  459705
  466076
  468574
  474378
  475948
  477274
  478875
  479632
  481449
  482997
  483044
  486740
  487654
  489601
  490097
  490474
  491488
  491931
  492168
  494181
  494584
  495574
  495584
  500725
  502118
  503089
  505911
  507817
  508245
  509819
  509972
  510759
  514118
  514383
  514781
  516930
  518207
  518937
  518961
  519319
  519337
  520198
  521353
  521516
  521905
  522230
  522689
  522710
  523584
  523786
  525966
  526818
  527064
  527192
  528112
  528788
  529249
  535610
  545659
  549153
  549822
  551620
  552296
  558844
  559080
  559791
  560063
  560608
  561692
  563735
  566089
  566929
  568123
  571501
  575785
  575792
  576036
  597557
  598602
  599371
  601894
  601988
  603482
  605952
  609252
  609681
  611572
  620100
  697892
  722894
  726882
  770928
  796507
  799941
]
1.89 ms
(0.82%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "russian sleeping girl"
]
1.86 ms
(0.80%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск спящ девушк"
]
1.55 ms
(0.67%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.40 ms
(0.60%)
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.