GET https://search.jues.net/search/embeds/3?q=parents%20homemade

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.52 ms
(83.14%)
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
  425641
  428877
  433981
  435647
  438513
  438694
  439011
  453652
  455242
  460563
  477202
  479421
  487466
  495097
  496424
  509770
  512144
  514416
  514583
  521603
  524179
  525296
  530554
  533464
  533892
  537042
  538455
  556066
  556113
  558638
  562009
  562085
  562409
  564843
  567204
  567232
  572274
  583265
  585797
  587968
  588480
  590982
  602714
  610499
  610522
  625544
  626122
  626193
  635367
  637183
  638490
  639551
  645599
  645626
  659061
  659416
  659430
  661350
  667813
  676192
  689169
  694715
  698027
  698028
  698248
  701904
  702257
  703564
  705043
  706471
  709510
  710467
  717490
  718933
  722230
  724074
  724898
  725675
  727095
  730750
  731038
  732131
  736690
  736745
  739550
  740533
  740996
  741932
  749113
  749740
  750916
  751846
  753623
  755649
  756436
  757175
  764606
  765343
  765625
  767454
  767611
  770595
  771043
  777278
  778870
  778975
  781519
  783735
  784228
  785678
  792690
  792878
  795479
  798788
  799342
  801443
  801669
  802910
  814181
  817151
]
15.38 ms
(9.79%)
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
  590982
  639551
  730750
  562085
  701904
  635367
  638490
  637183
  588480
  509770
  530554
  487466
  533892
  587968
  784228
  724074
  731038
  753623
  732131
  739550
  428877
  453652
  556066
  740533
  741932
  749113
  736745
  765625
  702257
  433981
  514416
  538455
  799342
  802910
  777278
  438513
  755649
  736690
  727095
  750916
  718933
  795479
  785678
  495097
  477202
  512144
  533464
  567204
  659430
  706471
  698248
  610499
  438694
  514583
  705043
  698027
  556113
  435647
  659061
  717490
  756436
  770595
  781519
  767611
  771043
  778975
  792690
  583265
  722230
  724898
  751846
  765343
  740996
  778870
  479421
  455242
  572274
  792878
  801443
  725675
  425641
  439011
  817151
  667813
  798788
  801669
  783735
  757175
  767454
  764606
  749740
  460563
  524179
  525296
  562009
  564843
  562409
  659416
  645599
  661350
  710467
  689169
  698028
  558638
  610522
  625544
  703564
  496424
  694715
  585797
  626193
  602714
  709510
  676192
  814181
  537042
  521603
  567232
  645626
  626122
]
2.58 ms
(1.65%)
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
  425641
  428877
  433981
  435647
  438513
  438694
  439011
  453652
  455242
  460563
  477202
  479421
  487466
  495097
  496424
  509770
  512144
  514416
  514583
  521603
  524179
  525296
  530554
  533464
  533892
  537042
  538455
  556066
  556113
  558638
  562009
  562085
  562409
  564843
  567204
  567232
  572274
  583265
  585797
  587968
  588480
  590982
  602714
  610499
  610522
  625544
  626122
  626193
  635367
  637183
  638490
  639551
  645599
  645626
  659061
  659416
  659430
  661350
  667813
  676192
  689169
  694715
  698027
  698028
  698248
  701904
  702257
  703564
  705043
  706471
  709510
  710467
  717490
  718933
  722230
  724074
  724898
  725675
  727095
  730750
  731038
  732131
  736690
  736745
  739550
  740533
  740996
  741932
  749113
  749740
  750916
  751846
  753623
  755649
  756436
  757175
  764606
  765343
  765625
  767454
  767611
  770595
  771043
  777278
  778870
  778975
  781519
  783735
  784228
  785678
  792690
  792878
  795479
  798788
  799342
  801443
  801669
  802910
  814181
  817151
]
2.34 ms
(1.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "parents homemade"
]
2.15 ms
(1.37%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.11 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "parents домашн любительск"
]
1.91 ms
(1.22%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "parents домашн любительск"
]

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.