GET https://search.jues.net/search/embeds/2?q=mother%20pov

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
208.62 ms
(59.55%)
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
  53698
  386680
  395523
  400516
  411841
  424125
  426003
  428452
  428580
  432641
  432704
  432852
  436719
  439480
  441406
  441511
  441782
  442057
  444519
  454167
  456046
  466224
  467671
  468363
  472690
  477135
  477538
  485644
  486610
  506069
  533198
  535725
  537760
  543532
  544161
  549718
  560923
  563185
  564296
  564549
  566405
  584364
  591944
  604260
  604313
  605401
  608439
  609625
  619070
  639385
  657178
  665790
  671379
  687584
  720410
  723667
  725029
  728393
  730360
  731333
  731565
  748231
  758587
  761050
  761461
  761587
  764882
  767269
  770331
  772039
  777575
  784170
  789496
  791482
  792654
  793867
  794073
  794853
  795141
  795337
  798804
  800313
  800364
  800509
  800569
  801483
  801549
  801696
  802201
  802500
  802519
  802620
  804810
  805692
  805777
  807372
  807446
  810318
  813828
  815050
  815062
  815074
  815077
  815093
  815095
  815099
  815109
  815115
  816684
  817155
  817336
  818528
  819719
  821166
  822278
  825418
  825670
  826155
  827220
  827492
]
122.30 ms
(34.91%)
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
  53698
  386680
  395523
  400516
  411841
  424125
  426003
  428452
  428580
  432641
  432704
  432852
  436719
  439480
  441406
  441511
  441782
  442057
  444519
  454167
  456046
  466224
  467671
  468363
  472690
  477135
  477538
  485644
  486610
  506069
  533198
  535725
  537760
  543532
  544161
  549718
  560923
  563185
  564296
  564549
  566405
  584364
  591944
  604260
  604313
  605401
  608439
  609625
  619070
  639385
  657178
  665790
  671379
  687584
  720410
  723667
  725029
  728393
  730360
  731333
  731565
  748231
  758587
  761050
  761461
  761587
  764882
  767269
  770331
  772039
  777575
  784170
  789496
  791482
  792654
  793867
  794073
  794853
  795141
  795337
  798804
  800313
  800364
  800509
  800569
  801483
  801549
  801696
  802201
  802500
  802519
  802620
  804810
  805692
  805777
  807372
  807446
  810318
  813828
  815050
  815062
  815074
  815077
  815093
  815095
  815099
  815109
  815115
  816684
  817155
  817336
  818528
  819719
  821166
  822278
  825418
  825670
  826155
  827220
  827492
]
11.89 ms
(3.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
  770331
  537760
  584364
  605401
  725029
  767269
  441406
  53698
  386680
  815095
  815074
  533198
  720410
  802519
  772039
  826155
  817336
  827220
  827492
  813828
  817155
  821166
  468363
  564549
  544161
  564296
  604260
  793867
  810318
  777575
  804810
  791482
  807372
  728393
  764882
  608439
  792654
  798804
  801696
  731565
  432852
  441511
  506069
  566405
  424125
  428452
  439480
  467671
  411841
  486610
  444519
  801549
  794073
  818528
  432641
  428580
  472690
  466224
  591944
  802620
  426003
  815115
  441782
  477135
  619070
  789496
  794853
  800569
  761050
  761461
  784170
  456046
  442057
  477538
  432704
  609625
  395523
  454167
  815050
  815099
  815109
  815062
  815077
  665790
  604313
  805777
  801483
  758587
  822278
  795141
  730360
  815093
  549718
  400516
  436719
  748231
  825670
  723667
  816684
  819719
  825418
  485644
  535725
  543532
  657178
  671379
  687584
  560923
  563185
  639385
  795337
  800509
  802201
  802500
  800313
  807446
  731333
  761587
  800364
  805692
]
2.17 ms
(0.62%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин пов"
]
1.87 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин пов"
]
1.84 ms
(0.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother pov"
]
1.66 ms
(0.47%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.