GET https://search.jues.net/search/embeds/6?q=ass%20son

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.36 ms
(81.87%)
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
  263299
  383888
  392787
  395142
  395427
  395699
  398243
  399518
  400511
  407710
  411731
  411914
  413112
  413128
  414153
  418905
  421829
  421838
  421842
  421855
  422182
  424274
  425450
  428556
  428809
  428852
  429528
  435382
  442415
  442418
  443180
  443182
  443183
  443185
  443722
  446269
  446277
  446306
  446622
  448145
  449232
  450147
  452391
  453260
  455298
  457301
  458012
  458018
  459251
  460156
  460177
  460273
  460641
  461374
  462082
  462110
  463563
  464189
  464382
  464423
  464440
  464446
  464556
  464559
  465209
  465366
  467012
  467304
  470995
  471627
  474794
  486896
  496108
  513115
  513366
  513784
  515911
  516485
  516829
  522602
  523838
  524267
  524289
  526323
  526521
  527158
  528390
  531923
  532004
  532056
  532062
  534722
  542957
  544103
  548864
  549833
  549847
  550223
  552299
  554897
  557924
  561378
  562517
  563142
  563148
  565012
  565625
  576995
  579209
  609825
  633535
  662140
  663772
  663929
  663969
  665233
  714062
  739940
  782503
  793784
]
17.33 ms
(10.97%)
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
  392787
  400511
  413128
  526323
  411731
  782503
  739940
  633535
  793784
  421829
  421838
  421855
  523838
  526521
  263299
  446269
  465209
  448145
  515911
  463563
  557924
  549847
  563148
  565625
  609825
  464189
  421842
  424274
  425450
  422182
  443722
  516485
  516829
  383888
  395142
  395699
  395427
  398243
  399518
  428809
  428852
  429528
  411914
  414153
  407710
  442418
  413112
  428556
  435382
  442415
  443182
  443183
  443185
  418905
  443180
  450147
  452391
  453260
  462082
  464382
  465366
  470995
  474794
  446622
  455298
  459251
  460156
  461374
  464440
  464446
  464556
  464559
  467304
  486896
  446277
  446306
  449232
  457301
  458012
  458018
  460177
  460273
  460641
  464423
  471627
  513366
  513784
  522602
  524289
  532004
  532062
  534722
  528390
  527158
  531923
  496108
  513115
  524267
  532056
  462110
  467012
  544103
  548864
  562517
  576995
  542957
  552299
  554897
  579209
  549833
  550223
  561378
  563142
  565012
  663929
  665233
  714062
  662140
  663772
  663969
]
2.87 ms
(1.82%)
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
  263299
  383888
  392787
  395142
  395427
  395699
  398243
  399518
  400511
  407710
  411731
  411914
  413112
  413128
  414153
  418905
  421829
  421838
  421842
  421855
  422182
  424274
  425450
  428556
  428809
  428852
  429528
  435382
  442415
  442418
  443180
  443182
  443183
  443185
  443722
  446269
  446277
  446306
  446622
  448145
  449232
  450147
  452391
  453260
  455298
  457301
  458012
  458018
  459251
  460156
  460177
  460273
  460641
  461374
  462082
  462110
  463563
  464189
  464382
  464423
  464440
  464446
  464556
  464559
  465209
  465366
  467012
  467304
  470995
  471627
  474794
  486896
  496108
  513115
  513366
  513784
  515911
  516485
  516829
  522602
  523838
  524267
  524289
  526323
  526521
  527158
  528390
  531923
  532004
  532056
  532062
  534722
  542957
  544103
  548864
  549833
  549847
  550223
  552299
  554897
  557924
  561378
  562517
  563142
  563148
  565012
  565625
  576995
  579209
  609825
  633535
  662140
  663772
  663929
  663969
  665233
  714062
  739940
  782503
  793784
]
2.34 ms
(1.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ass son"
]
2.30 ms
(1.45%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жоп son"
]
1.92 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "жоп son"
]
1.88 ms
(1.19%)
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.