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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.14 ms
(87.20%)
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
  62251
  144181
  144343
  350425
  383022
  385202
  385316
  390299
  397013
  424769
  428543
  432543
  432810
  435826
  441222
  442962
  444455
  445576
  451057
  451080
  456645
  457471
  459953
  459969
  462224
  467321
  476501
  479640
  480134
  483075
  491717
  498964
  499356
  500525
  514571
  526142
  527068
  531710
  532262
  532463
  532569
  534520
  540461
  553866
  557561
  559703
  561633
  572187
  576783
  577968
  580705
  585269
  585284
  587163
  588145
  588224
  589169
  589805
  593079
  597632
  602351
  603189
  610429
  611192
  611206
  623706
  624408
  628775
  629900
  632163
  633518
  636951
  641077
  642308
  658903
  667566
  677964
  688203
  689665
  691860
  696485
  698873
  702512
  716279
  722546
  724997
  736476
  738564
  743725
  745605
  760209
  764704
  765147
  776085
  777019
  777894
  782533
  782753
  783321
  784847
  789389
  790896
  792409
  795225
  800430
  803451
  806421
  807163
  808283
  808297
  810574
  811889
  812279
  812586
  812907
  813742
  815802
  819731
  821848
  821856
]
13.27 ms
(7.56%)
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
  765147
  808283
  811889
  585284
  603189
  628775
  587163
  610429
  777894
  602351
  812907
  498964
  702512
  806421
  764704
  442962
  397013
  531710
  696485
  580705
  588224
  812279
  783321
  499356
  633518
  441222
  445576
  534520
  532463
  716279
  585269
  812586
  800430
  808297
  813742
  483075
  576783
  577968
  553866
  557561
  589805
  636951
  782753
  777019
  792409
  736476
  743725
  451080
  451057
  467321
  480134
  462224
  691860
  589169
  623706
  745605
  724997
  435826
  383022
  527068
  561633
  698873
  658903
  776085
  789389
  760209
  611206
  782533
  424769
  432543
  514571
  144181
  432810
  532262
  667566
  588145
  795225
  738564
  611192
  790896
  390299
  457471
  385316
  144343
  819731
  459969
  526142
  532569
  479640
  559703
  572187
  689665
  722546
  688203
  593079
  632163
  642308
  597632
  624408
  784847
  803451
  810574
  629900
  807163
  456645
  444455
  821856
  476501
  821848
  500525
  677964
  641077
  491717
  385202
  350425
  62251
  428543
  815802
  540461
  459953
]
2.91 ms
(1.65%)
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
  62251
  144181
  144343
  350425
  383022
  385202
  385316
  390299
  397013
  424769
  428543
  432543
  432810
  435826
  441222
  442962
  444455
  445576
  451057
  451080
  456645
  457471
  459953
  459969
  462224
  467321
  476501
  479640
  480134
  483075
  491717
  498964
  499356
  500525
  514571
  526142
  527068
  531710
  532262
  532463
  532569
  534520
  540461
  553866
  557561
  559703
  561633
  572187
  576783
  577968
  580705
  585269
  585284
  587163
  588145
  588224
  589169
  589805
  593079
  597632
  602351
  603189
  610429
  611192
  611206
  623706
  624408
  628775
  629900
  632163
  633518
  636951
  641077
  642308
  658903
  667566
  677964
  688203
  689665
  691860
  696485
  698873
  702512
  716279
  722546
  724997
  736476
  738564
  743725
  745605
  760209
  764704
  765147
  776085
  777019
  777894
  782533
  782753
  783321
  784847
  789389
  790896
  792409
  795225
  800430
  803451
  806421
  807163
  808283
  808297
  810574
  811889
  812279
  812586
  812907
  813742
  815802
  819731
  821848
  821856
]
1.71 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "gym girl"
]
1.71 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.54 ms
(0.87%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "gym девушк"
]
1.34 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "gym девушк"
]

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.