GET https://search.jues.net/search/embeds/9?q=mother%20mature

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.43 ms
(85.68%)
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
  156014
  327378
  358453
  388203
  397878
  398421
  402960
  432445
  518911
  607568
  632094
  699415
  707551
  708813
  712786
  713153
  715522
  719916
  725237
  726217
  726925
  726926
  726978
  727259
  727565
  728261
  728778
  731309
  731327
  734436
  734623
  734965
  734969
  735448
  736201
  737148
  737562
  738602
  740289
  740593
  741514
  742626
  742629
  742797
  747104
  748830
  750127
  750292
  752611
  752621
  752705
  754065
  756782
  758304
  758701
  759299
  759796
  759806
  759933
  759947
  760921
  761023
  761038
  761053
  761072
  761719
  762800
  764135
  764180
  764245
  765326
  765376
  765434
  765452
  765458
  765555
  765686
  765692
  765788
  765819
  766437
  766601
  766635
  766692
  767081
  767095
  768870
  769782
  769838
  773391
  773407
  773912
  776999
  783369
  788629
  791364
  791849
  793138
  794351
  794359
  794908
  796211
  797097
  798773
  798814
  799358
  800349
  800388
  800594
  800782
  800785
  804590
  805651
  810301
  810354
  810424
  811536
  811555
  812017
]
13.65 ms
(7.93%)
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
  750127
  766437
  766601
  766635
  766692
  725237
  726217
  726925
  726926
  726978
  727259
  728261
  734436
  734623
  734965
  735448
  737148
  740289
  742629
  748830
  758701
  761023
  764135
  765326
  765555
  765819
  773407
  737562
  741514
  742797
  750292
  752705
  756782
  758304
  759796
  759933
  760921
  761719
  765376
  765458
  765549
  767081
  767095
  768870
  773391
  773912
  727565
  728778
  731309
  731327
  734969
  738602
  740593
  742626
  747104
  752611
  752621
  754065
  759299
  759806
  761038
  761053
  761072
  764180
  764245
  765434
  765686
  765692
  765788
  769782
  769838
  607568
  632094
  699415
  707551
  708813
  712786
  713153
  715522
  719916
  776999
  783369
  788629
  791364
  791849
  793138
  794351
  794359
  794908
  797097
  798773
  798814
  800349
  800388
  800594
  800782
  800785
  805651
  810301
  810354
  810424
  811536
  811555
  812017
  398421
  327378
  156014
  432445
  518911
  736201
  799358
  804590
  765452
  762800
  759947
  402960
  796211
  397878
  358453
  388203
]
2.86 ms
(1.66%)
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
  156014
  327378
  358453
  388203
  397878
  398421
  402960
  432445
  518911
  607568
  632094
  699415
  707551
  708813
  712786
  713153
  715522
  719916
  725237
  726217
  726925
  726926
  726978
  727259
  727565
  728261
  728778
  731309
  731327
  734436
  734623
  734965
  734969
  735448
  736201
  737148
  737562
  738602
  740289
  740593
  741514
  742626
  742629
  742797
  747104
  748830
  750127
  750292
  752611
  752621
  752705
  754065
  756782
  758304
  758701
  759299
  759796
  759806
  759933
  759947
  760921
  761023
  761038
  761053
  761072
  761719
  762800
  764135
  764180
  764245
  765326
  765376
  765434
  765452
  765458
  765555
  765686
  765692
  765788
  765819
  766437
  766601
  766635
  766692
  767081
  767095
  768870
  769782
  769838
  773391
  773407
  773912
  776999
  783369
  788629
  791364
  791849
  793138
  794351
  794359
  794908
  796211
  797097
  798773
  798814
  799358
  800349
  800388
  800594
  800782
  800785
  804590
  805651
  810301
  810354
  810424
  811536
  811555
  812017
]
2.17 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother mature"
]
2.07 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.97 ms
(1.14%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин mature"
]
1.93 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин mature"
]

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.