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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.89 ms
(83.43%)
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
  334847
  366296
  383700
  394258
  395699
  395924
  396956
  398243
  400125
  400179
  401224
  407682
  418996
  422194
  428463
  428539
  428910
  429528
  433070
  437361
  437582
  438429
  440864
  442415
  443185
  443711
  443970
  446622
  451165
  457191
  457298
  458012
  458018
  459783
  460273
  460577
  460679
  463691
  465366
  471408
  476337
  477987
  486896
  493201
  493247
  513784
  519856
  524271
  524291
  524652
  524783
  532127
  534722
  546425
  550224
  550330
  550643
  550644
  562967
  563123
  563142
  565012
  569394
  571129
  582197
  602707
  605261
  609823
  622665
  625649
  639225
  662140
  685023
  689002
  695087
  696567
  699604
  704174
  709503
  709760
  711341
  719912
  723945
  723955
  724045
  724456
  724476
  724502
  725788
  726390
  727891
  730904
  743429
  743431
  743463
  743479
  743811
  744563
  746497
  753148
  753764
  755695
  756797
  763845
  769490
  769503
  769536
  769550
  772444
  772446
  773797
  775270
  788158
  804329
]
19.04 ms
(10.60%)
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
  724502
  730904
  743429
  726390
  769550
  772444
  773797
  756797
  639225
  711341
  804329
  524291
  395699
  569394
  662140
  605261
  775270
  772446
  437582
  524271
  383700
  396956
  451165
  460577
  550644
  582197
  550330
  563123
  695087
  696567
  704174
  602707
  755695
  743463
  736517
  743479
  746497
  769530
  697943
  709503
  443711
  609823
  519856
  493247
  395924
  398243
  400125
  401224
  407682
  428539
  429528
  437361
  442415
  443185
  460679
  463691
  465366
  446622
  457298
  486896
  458012
  458018
  460273
  476337
  493201
  513784
  534722
  532127
  524652
  550643
  563142
  565012
  709760
  716936
  689002
  685023
  550224
  562967
  571129
  622665
  788158
  723955
  724045
  727891
  724456
  724476
  743431
  744563
  769536
  723945
  725788
  753148
  769503
  743811
  753764
  699604
  719912
  428463
  428910
  477987
  394258
  457191
  334847
  459783
  440864
  400179
  524783
  510295
  546425
  625649
  769490
  763845
  697939
  471408
  433070
  422194
  366296
  438429
  443970
  418996
]
3.07 ms
(1.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
  334847
  366296
  383700
  394258
  395699
  395924
  396956
  398243
  400125
  400179
  401224
  407682
  418996
  422194
  428463
  428539
  428910
  429528
  433070
  437361
  437582
  438429
  440864
  442415
  443185
  443711
  443970
  446622
  451165
  457191
  457298
  458012
  458018
  459783
  460273
  460577
  460679
  463691
  465366
  471408
  476337
  477987
  486896
  493201
  493247
  513784
  519856
  524271
  524291
  524652
  524783
  532127
  534722
  546425
  550224
  550330
  550643
  550644
  562967
  563123
  563142
  565012
  569394
  571129
  582197
  602707
  605261
  609823
  622665
  625649
  639225
  662140
  685023
  689002
  695087
  696567
  699604
  704174
  709503
  709760
  711341
  719912
  723945
  723955
  724045
  724456
  724476
  724502
  725788
  726390
  727891
  730904
  743429
  743431
  743463
  743479
  743811
  744563
  746497
  753148
  753764
  755695
  756797
  763845
  769490
  769503
  769536
  769550
  772444
  772446
  773797
  775270
  788158
  804329
]
1.99 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom----and----son"
]
1.91 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom son"
]
1.89 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom son"
]
1.87 ms
(1.04%)
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.