GET https://search.jues.net/search/embeds/8?q=mother%20solo

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
252.15 ms
(91.61%)
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
  382101
  388711
  466031
  470621
  470674
  475727
  484729
  495383
  509659
  523400
  526656
  531562
  532458
  537852
  540563
  541204
  543679
  546409
  547411
  558264
  563086
  568530
  570885
  576540
  589652
  592800
  595438
  600223
  603119
  603633
  605173
  605290
  611285
  615157
  615395
  615965
  625231
  625679
  629480
  635248
  637462
  638957
  642293
  652881
  660831
  669869
  670448
  711975
  712239
  713325
  717976
  718033
  725495
  725739
  728000
  731806
  734120
  735876
  736089
  738089
  745121
  746570
  747415
  749384
  750593
  750639
  751359
  752951
  753019
  754565
  754680
  754759
  755322
  755351
  758251
  759068
  759077
  759338
  760373
  764419
  765546
  765567
  766475
  767718
  768068
  768515
  769335
  769348
  769886
  771950
  777097
  777522
  782064
  782658
  785882
  785901
  786433
  786972
  790612
  790764
  791823
  795724
  795990
  796814
  800655
  801833
  804131
  805588
  807564
  808263
  811020
  812242
  812404
  813434
  816184
  816644
  819246
  821377
  825366
  826723
]
13.29 ms
(4.83%)
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
  759068
  759338
  766475
  767718
  768515
  769335
  759077
  760373
  764419
  735876
  749384
  751359
  754759
  765567
  728000
  736089
  747415
  750593
  750639
  754565
  768068
  603633
  615157
  625231
  642293
  713325
  717976
  718033
  782658
  786972
  791823
  796814
  804131
  811020
  812242
  382101
  589652
  785901
  795990
  758251
  821377
  600223
  805588
  807564
  738089
  816184
  466031
  470621
  537852
  546409
  568530
  576540
  652881
  660831
  595438
  615395
  813434
  808263
  725739
  745121
  765546
  470674
  526656
  816644
  484729
  670448
  801833
  388711
  826723
  825366
  819246
  495383
  523400
  531562
  532458
  509659
  540563
  475727
  558264
  541204
  547411
  570885
  543679
  563086
  669869
  711975
  712239
  592800
  611285
  629480
  603119
  615965
  605173
  605290
  635248
  625679
  637462
  638957
  777097
  782064
  790612
  777522
  795724
  812404
  734120
  746570
  753019
  785882
  786433
  790764
  800655
  731806
  769348
  769886
  771950
  752951
  755322
  755351
  725495
  754680
]
3.21 ms
(1.17%)
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
  382101
  388711
  466031
  470621
  470674
  475727
  484729
  495383
  509659
  523400
  526656
  531562
  532458
  537852
  540563
  541204
  543679
  546409
  547411
  558264
  563086
  568530
  570885
  576540
  589652
  592800
  595438
  600223
  603119
  603633
  605173
  605290
  611285
  615157
  615395
  615965
  625231
  625679
  629480
  635248
  637462
  638957
  642293
  652881
  660831
  669869
  670448
  711975
  712239
  713325
  717976
  718033
  725495
  725739
  728000
  731806
  734120
  735876
  736089
  738089
  745121
  746570
  747415
  749384
  750593
  750639
  751359
  752951
  753019
  754565
  754680
  754759
  755322
  755351
  758251
  759068
  759077
  759338
  760373
  764419
  765546
  765567
  766475
  767718
  768068
  768515
  769335
  769348
  769886
  771950
  777097
  777522
  782064
  782658
  785882
  785901
  786433
  786972
  790612
  790764
  791823
  795724
  795990
  796814
  800655
  801833
  804131
  805588
  807564
  808263
  811020
  812242
  812404
  813434
  816184
  816644
  819246
  821377
  825366
  826723
]
2.10 ms
(0.76%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин соло"
]
1.53 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин соло"
]
1.49 ms
(0.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother solo"
]
1.47 ms
(0.53%)
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.