GET https://search.jues.net/search/embeds/3?q=girls%20student

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.48 ms
(84.59%)
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
  233335
  387050
  388544
  393729
  395235
  398977
  441490
  451776
  462406
  505935
  525293
  525629
  532414
  555708
  557326
  559512
  563561
  563565
  565801
  567171
  585784
  592538
  607845
  609578
  616845
  623056
  627597
  629727
  631222
  638334
  642085
  651509
  658169
  659313
  667178
  670893
  671447
  671516
  672797
  675178
  677542
  679296
  679305
  680669
  683698
  689171
  690346
  691326
  692606
  693174
  693875
  695788
  700056
  705786
  713734
  715036
  717763
  718134
  722348
  724834
  724971
  729705
  733657
  735245
  735831
  736680
  736688
  739928
  740624
  741553
  743496
  747302
  750106
  750558
  750630
  751306
  751943
  752951
  753543
  755577
  757701
  759313
  759337
  759593
  760521
  764663
  766056
  766163
  767231
  768708
  772262
  772560
  776235
  777621
  783563
  785366
  786796
  786886
  787890
  788552
  788938
  789591
  790237
  791223
  791869
  793026
  793128
  793920
  797812
  803980
  807160
  807319
  809599
  810205
  812668
  817497
  818279
  823348
  825377
]
12.11 ms
(8.43%)
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
  631222
  563565
  672797
  693875
  592538
  609578
  642085
  623056
  788552
  791223
  812668
  803980
  733657
  766163
  393729
  387050
  555708
  713734
  680669
  700056
  695788
  785366
  786886
  772262
  793128
  809599
  751306
  750106
  753543
  740624
  760521
  747302
  717763
  395235
  825377
  823348
  817497
  818279
  692606
  693174
  705786
  651509
  670893
  658169
  689171
  722348
  616845
  627597
  783563
  788938
  789591
  790237
  751943
  766056
  797812
  807319
  741553
  764663
  743496
  752951
  736688
  739928
  759313
  750630
  638334
  777621
  791869
  398977
  532414
  462406
  691326
  659313
  683698
  667178
  675178
  677542
  690346
  718134
  629727
  607845
  787890
  807160
  776235
  786796
  729705
  736680
  750558
  772560
  793920
  810205
  735245
  759337
  724971
  755577
  735831
  767231
  768708
  724834
  757701
  768119
  715036
  793026
  233335
  388544
  505935
  441490
  525293
  679296
  559512
  567171
  759593
  451776
  525629
  563561
  671447
  679305
  671516
  557326
  565801
  585784
]
2.92 ms
(2.03%)
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
  233335
  387050
  388544
  393729
  395235
  398977
  441490
  451776
  462406
  505935
  525293
  525629
  532414
  555708
  557326
  559512
  563561
  563565
  565801
  567171
  585784
  592538
  607845
  609578
  616845
  623056
  627597
  629727
  631222
  638334
  642085
  651509
  658169
  659313
  667178
  670893
  671447
  671516
  672797
  675178
  677542
  679296
  679305
  680669
  683698
  689171
  690346
  691326
  692606
  693174
  693875
  695788
  700056
  705786
  713734
  715036
  717763
  718134
  722348
  724834
  724971
  729705
  733657
  735245
  735831
  736680
  736688
  739928
  740624
  741553
  743496
  747302
  750106
  750558
  750630
  751306
  751943
  752951
  753543
  755577
  757701
  759313
  759337
  759593
  760521
  764663
  766056
  766163
  767231
  768708
  772262
  772560
  776235
  777621
  783563
  785366
  786796
  786886
  787890
  788552
  788938
  789591
  790237
  791223
  791869
  793026
  793128
  793920
  797812
  803980
  807160
  807319
  809599
  810205
  812668
  817497
  818279
  823348
  825377
]
1.99 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girls student"
]
1.88 ms
(1.31%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк student"
]
1.56 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "девушк student"
]

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.