GET https://search.jues.net/search/embeds/4?q=and%20son%20mom

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.08 ms
(57.51%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
131.24 ms
(36.10%)
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
  233292
  387422
  388113
  392277
  395584
  395909
  395910
  396954
  397174
  398564
  398947
  398951
  400948
  401225
  402599
  407187
  409258
  411038
  411310
  413136
  413908
  414022
  414946
  427536
  428892
  428904
  430247
  438219
  440292
  443921
  443969
  444707
  452335
  454050
  457016
  457187
  458708
  464410
  469370
  481794
  490740
  492096
  492302
  502788
  508450
  512895
  513117
  515022
  515317
  516886
  520021
  522168
  523323
  525469
  527148
  529170
  531482
  531997
  532032
  532041
  532063
  532114
  532126
  532825
  536330
  537116
  543773
  549719
  561465
  561587
  582656
  583797
  591155
  591258
  592856
  593805
  603307
  625493
  630332
  709372
  709575
  710575
  715536
  716915
  716927
  724295
  725402
  732140
  736379
  736977
  739965
  746267
  756714
  758594
  759898
  769547
  771490
  772463
  777217
  780795
  782503
  789188
  790017
  792522
  793282
  794403
  796214
  798763
  799983
  800926
  803518
  807452
  807453
  807454
  811919
  813771
  813913
  818602
  821761
]
15.68 ms
(4.31%)
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
  709372
  715536
  723107
  790017
  793282
  794403
  395909
  387422
  457016
  413136
  233292
  395910
  515317
  508450
  392277
  388113
  397174
  401225
  443921
  430247
  411038
  818602
  821761
  813771
  452335
  458708
  454050
  464410
  469370
  492302
  515022
  532041
  532126
  532825
  536330
  537116
  502788
  513117
  527148
  531997
  532032
  531482
  532063
  490740
  549719
  561465
  561587
  583797
  582656
  710575
  716915
  592856
  625493
  593805
  603307
  782503
  789188
  807453
  777217
  780795
  792522
  798763
  800926
  803518
  807452
  811919
  736977
  796214
  725402
  724295
  732140
  746267
  758594
  759898
  736379
  739965
  771490
  772463
  630332
  709575
  799983
  807454
  398564
  398947
  398951
  428904
  457187
  400948
  813913
  481794
  532114
  543773
  716927
  591258
  591155
  769547
  756714
  438219
  413908
  427536
  428892
  409258
  414946
  520021
  529170
  512895
  516886
  523323
  492096
  522168
  525469
  395584
  396954
  402599
  411310
  414022
  444707
  407187
  440292
  443969
]
2.57 ms
(0.71%)
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
  233292
  387422
  388113
  392277
  395584
  395909
  395910
  396954
  397174
  398564
  398947
  398951
  400948
  401225
  402599
  407187
  409258
  411038
  411310
  413136
  413908
  414022
  414946
  427536
  428892
  428904
  430247
  438219
  440292
  443921
  443969
  444707
  452335
  454050
  457016
  457187
  458708
  464410
  469370
  481794
  490740
  492096
  492302
  502788
  508450
  512895
  513117
  515022
  515317
  516886
  520021
  522168
  523323
  525469
  527148
  529170
  531482
  531997
  532032
  532041
  532063
  532114
  532126
  532825
  536330
  537116
  543773
  549719
  561465
  561587
  582656
  583797
  591155
  591258
  592856
  593805
  603307
  625493
  630332
  709372
  709575
  710575
  715536
  716915
  716927
  724295
  725402
  732140
  736379
  736977
  739965
  746267
  756714
  758594
  759898
  769547
  771490
  772463
  777217
  780795
  782503
  789188
  790017
  792522
  793282
  794403
  796214
  798763
  799983
  800926
  803518
  807452
  807453
  807454
  811919
  813771
  813913
  818602
  821761
]
1.93 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "and son mom"
]
1.66 ms
(0.46%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "son mom"
]
1.42 ms
(0.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "son mom"
]

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.