GET https://search.jues.net/search/embeds/10?q=shower%20girl

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
215.45 ms
(37.67%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "shower девушк"
]
205.11 ms
(35.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
131.66 ms
(23.02%)
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
  388591
  399473
  413236
  416153
  422299
  424145
  424671
  425309
  427498
  432786
  434676
  436452
  440644
  441206
  443059
  443481
  448396
  452482
  453028
  453884
  455375
  456281
  458382
  458713
  459476
  459485
  460009
  463677
  464425
  465553
  469947
  471182
  473259
  478753
  480239
  482718
  482917
  485441
  488100
  488295
  493954
  495769
  498768
  498776
  499362
  499581
  501909
  506218
  509215
  509430
  510206
  511127
  511235
  511545
  511557
  512997
  513209
  514236
  514321
  516969
  517477
  517538
  518189
  520994
  521746
  522305
  522310
  523248
  523731
  523959
  524596
  526947
  531977
  532939
  539530
  541969
  542021
  542728
  554110
  555994
  562463
  565143
  572551
  575746
  579726
  580418
  583737
  587935
  592184
  593168
  594036
  595163
  603121
  605484
  610552
  612458
  614422
  614428
  634858
  645014
  648874
  659460
  662897
  666709
  711700
  723616
  726547
  737438
  739699
  759132
  760400
  765860
  775494
  776186
  780410
  784662
  787368
  790843
  804265
  814738
]
13.71 ms
(2.40%)
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
  780410
  737438
  759132
  760400
  787368
  739699
  614422
  776186
  790843
  804265
  443059
  460009
  471182
  441206
  425309
  498776
  522305
  498768
  416153
  482718
  575746
  579726
  595163
  434676
  459476
  501909
  511235
  493954
  440644
  427498
  456281
  526947
  542021
  562463
  541969
  572551
  592184
  436452
  463677
  464425
  399473
  458713
  511545
  488100
  522310
  523731
  514236
  520994
  645014
  443481
  610552
  511127
  814738
  532939
  594036
  603121
  452482
  511557
  424671
  432786
  723616
  453028
  513209
  518189
  506218
  516969
  480239
  580418
  659460
  662897
  614428
  784662
  413236
  465553
  455375
  473259
  509430
  510206
  482917
  488295
  495769
  499581
  523959
  453884
  517477
  512997
  517538
  531977
  539530
  499362
  521746
  523248
  524596
  542728
  555994
  583737
  554110
  565143
  648874
  666709
  711700
  634858
  587935
  593168
  605484
  612458
  775494
  726547
  765860
  388591
  458382
  448396
  422299
  469947
  424145
  478753
  459485
  485441
  509215
  514321
]
2.59 ms
(0.45%)
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
  388591
  399473
  413236
  416153
  422299
  424145
  424671
  425309
  427498
  432786
  434676
  436452
  440644
  441206
  443059
  443481
  448396
  452482
  453028
  453884
  455375
  456281
  458382
  458713
  459476
  459485
  460009
  463677
  464425
  465553
  469947
  471182
  473259
  478753
  480239
  482718
  482917
  485441
  488100
  488295
  493954
  495769
  498768
  498776
  499362
  499581
  501909
  506218
  509215
  509430
  510206
  511127
  511235
  511545
  511557
  512997
  513209
  514236
  514321
  516969
  517477
  517538
  518189
  520994
  521746
  522305
  522310
  523248
  523731
  523959
  524596
  526947
  531977
  532939
  539530
  541969
  542021
  542728
  554110
  555994
  562463
  565143
  572551
  575746
  579726
  580418
  583737
  587935
  592184
  593168
  594036
  595163
  603121
  605484
  610552
  612458
  614422
  614428
  634858
  645014
  648874
  659460
  662897
  666709
  711700
  723616
  726547
  737438
  739699
  759132
  760400
  765860
  775494
  776186
  780410
  784662
  787368
  790843
  804265
  814738
]
1.85 ms
(0.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "shower girl"
]
1.62 ms
(0.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "shower девушк"
]

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.