GET https://search.jues.net/search/embeds/6?q=wife%20beautiful

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.75 ms
(84.07%)
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
  392735
  395662
  395793
  396784
  402128
  402556
  402893
  403707
  418793
  420833
  424023
  424842
  424952
  427620
  428685
  433057
  433956
  437556
  451275
  457005
  457718
  460661
  464713
  467336
  467384
  469202
  477876
  478554
  479814
  483259
  484754
  498603
  500905
  502321
  503336
  505191
  505494
  509761
  517117
  529359
  530587
  531806
  533084
  537378
  537608
  542819
  547780
  551728
  553854
  554888
  555547
  556686
  558264
  562522
  567676
  569582
  575426
  593214
  593261
  610891
  612508
  612706
  616845
  619105
  620568
  632971
  641516
  645052
  646076
  648193
  652422
  664473
  672340
  676388
  678339
  679908
  682691
  689121
  708603
  708876
  715154
  717801
  721083
  721854
  729118
  733450
  736580
  745484
  746480
  746711
  752012
  752923
  755046
  756800
  762240
  762766
  763533
  768701
  777276
  778622
  779267
  779557
  780304
  782365
  783151
  784237
  784312
  785360
  788795
  793150
  793495
  798716
  799723
  800813
  802046
  802787
  803961
  805027
  807345
  811819
]
12.36 ms
(8.47%)
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
  798716
  811819
  729118
  736580
  745484
  746711
  763533
  784312
  793150
  802046
  802787
  803961
  762240
  746480
  755046
  752012
  632971
  717801
  778622
  785360
  793495
  433057
  402893
  752923
  768701
  619105
  479814
  503336
  708876
  427620
  402128
  418793
  451275
  505191
  500905
  569582
  575426
  676388
  547780
  567676
  779267
  807345
  784237
  805027
  756800
  721854
  783151
  424023
  437556
  477876
  395662
  395793
  428685
  457005
  467336
  469202
  396784
  464713
  467384
  460661
  478554
  424952
  502321
  505494
  483259
  498603
  529359
  484754
  509761
  517117
  799723
  800813
  762766
  708603
  403707
  457718
  788795
  733450
  433956
  392735
  402556
  420833
  424842
  530587
  531806
  537378
  537608
  533084
  553854
  558264
  542819
  551728
  555547
  554888
  562522
  648193
  664473
  679908
  689121
  646076
  652422
  678339
  715154
  721083
  645052
  672340
  682691
  556686
  616845
  620568
  593261
  610891
  612508
  612706
  593214
  641516
  777276
  779557
  780304
  782365
]
3.08 ms
(2.11%)
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
  392735
  395662
  395793
  396784
  402128
  402556
  402893
  403707
  418793
  420833
  424023
  424842
  424952
  427620
  428685
  433057
  433956
  437556
  451275
  457005
  457718
  460661
  464713
  467336
  467384
  469202
  477876
  478554
  479814
  483259
  484754
  498603
  500905
  502321
  503336
  505191
  505494
  509761
  517117
  529359
  530587
  531806
  533084
  537378
  537608
  542819
  547780
  551728
  553854
  554888
  555547
  556686
  558264
  562522
  567676
  569582
  575426
  593214
  593261
  610891
  612508
  612706
  616845
  619105
  620568
  632971
  641516
  645052
  646076
  648193
  652422
  664473
  672340
  676388
  678339
  679908
  682691
  689121
  708603
  708876
  715154
  717801
  721083
  721854
  729118
  733450
  736580
  745484
  746480
  746711
  752012
  752923
  755046
  756800
  762240
  762766
  763533
  768701
  777276
  778622
  779267
  779557
  780304
  782365
  783151
  784237
  784312
  785360
  788795
  793150
  793495
  798716
  799723
  800813
  802046
  802787
  803961
  805027
  807345
  811819
]
2.67 ms
(1.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(1.27%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен красивая"
]
1.79 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife beautiful"
]
1.50 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.