GET https://search.jues.net/search/embeds/9?q=beautiful%20mom%20old

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
179.63 ms
(85.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
  395738
  396321
  399700
  400196
  404273
  404953
  405145
  405188
  407148
  407156
  407414
  407549
  407895
  408467
  409506
  411415
  411751
  425043
  425622
  426203
  430095
  430810
  432807
  433669
  435700
  439699
  440619
  447464
  460609
  462488
  464329
  464395
  466213
  467523
  468760
  469509
  472124
  478546
  480372
  480526
  480782
  481341
  481844
  482101
  482355
  485037
  488011
  490894
  492099
  493224
  494724
  494842
  497537
  499802
  499814
  502304
  506348
  508474
  508525
  510251
  510887
  511160
  511369
  511517
  511568
  514926
  518750
  518948
  519927
  521206
  522673
  524296
  531512
  535264
  543440
  556320
  563844
  565467
  572038
  582024
  590861
  596147
  616097
  630766
  633130
  640022
  640721
  644373
  644748
  650844
  674780
  677279
  681478
  681647
  681833
  684910
  685682
  687507
  688041
  688050
  688548
  698284
  711893
  712694
  717852
  718798
  719343
  721617
  731678
  753990
  784152
  788604
  790218
  802109
  805420
  805558
  807363
  807386
  807399
  807492
]
22.20 ms
(10.51%)
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
  468760
  508474
  524296
  494724
  518948
  535264
  506348
  511568
  518750
  521206
  514926
  522673
  531512
  462488
  482101
  572038
  543440
  556320
  563844
  674780
  677279
  681833
  685682
  718798
  721617
  650844
  681478
  684910
  687507
  688050
  688548
  711893
  717852
  681647
  688041
  698284
  712694
  719343
  565467
  582024
  640022
  640721
  644373
  590861
  630766
  644748
  596147
  616097
  805558
  807363
  784152
  790218
  802109
  805420
  807386
  807492
  753990
  788604
  807399
  731678
  633130
  396321
  399700
  400196
  404273
  407414
  407549
  407895
  409506
  430810
  432807
  433669
  440619
  464395
  469509
  480526
  480782
  482355
  395738
  411751
  439699
  460609
  466213
  478546
  480372
  404953
  407156
  425043
  425622
  430095
  435700
  464329
  472124
  405145
  405188
  426203
  407148
  408467
  411415
  447464
  467523
  481341
  481844
  499802
  499814
  510251
  510887
  511160
  511369
  511517
  519927
  488011
  490894
  494842
  508525
  485037
  492099
  493224
  497537
  502304
]
2.37 ms
(1.12%)
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
  395738
  396321
  399700
  400196
  404273
  404953
  405145
  405188
  407148
  407156
  407414
  407549
  407895
  408467
  409506
  411415
  411751
  425043
  425622
  426203
  430095
  430810
  432807
  433669
  435700
  439699
  440619
  447464
  460609
  462488
  464329
  464395
  466213
  467523
  468760
  469509
  472124
  478546
  480372
  480526
  480782
  481341
  481844
  482101
  482355
  485037
  488011
  490894
  492099
  493224
  494724
  494842
  497537
  499802
  499814
  502304
  506348
  508474
  508525
  510251
  510887
  511160
  511369
  511517
  511568
  514926
  518750
  518948
  519927
  521206
  522673
  524296
  531512
  535264
  543440
  556320
  563844
  565467
  572038
  582024
  590861
  596147
  616097
  630766
  633130
  640022
  640721
  644373
  644748
  650844
  674780
  677279
  681478
  681647
  681833
  684910
  685682
  687507
  688041
  688050
  688548
  698284
  711893
  712694
  717852
  718798
  719343
  721617
  731678
  753990
  784152
  788604
  790218
  802109
  805420
  805558
  807363
  807386
  807399
  807492
]
2.03 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beautiful mom old"
]
1.96 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.77%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая mom old"
]
1.48 ms
(0.70%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "красивая mom old"
]

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.