GET https://search.jues.net/search/embeds/10?q=pussy%20doggy

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.53 ms
(59.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pussy рак"
]
117.83 ms
(33.32%)
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
  118359
  223663
  262435
  378272
  391577
  393868
  395249
  395459
  397605
  398815
  411125
  411515
  416428
  421388
  425281
  435521
  442405
  447094
  448171
  466471
  482182
  485855
  489207
  490503
  495003
  495106
  501434
  503787
  506460
  514362
  514975
  516493
  516534
  526949
  528800
  534430
  541203
  552038
  556084
  556142
  556704
  556743
  559733
  560276
  561282
  562622
  563284
  565638
  583009
  583176
  584465
  585145
  598990
  604545
  606923
  615409
  617112
  619752
  626996
  628744
  635402
  636504
  641890
  644447
  647784
  657804
  663841
  672844
  673254
  675183
  679908
  698154
  698765
  702038
  718826
  720103
  721230
  723726
  726325
  729013
  731173
  733259
  739346
  740070
  742758
  745243
  746293
  748063
  749621
  758780
  762360
  766918
  768962
  769099
  771128
  771898
  776179
  778475
  778574
  778841
  779527
  780977
  781021
  781502
  783563
  783995
  787403
  790912
  791478
  795316
  795948
  796466
  796480
  800906
  802147
  805412
  809813
  809869
  817107
]
16.17 ms
(4.57%)
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
  528800
  817107
  673254
  647784
  698765
  561282
  628744
  617112
  776179
  778574
  781502
  809869
  762360
  771128
  771898
  739346
  495106
  560276
  720103
  636504
  606923
  805412
  723726
  745243
  749621
  398815
  416428
  740070
  482182
  718826
  635402
  796480
  733259
  644447
  395249
  391577
  534430
  565638
  583009
  541203
  657804
  721230
  552038
  562622
  641890
  795948
  790912
  768962
  731173
  742758
  795316
  262435
  393868
  421388
  556743
  663841
  672844
  556084
  563284
  615409
  626996
  598990
  778475
  780977
  781021
  783995
  779527
  746293
  802147
  748063
  726325
  787403
  809813
  411125
  425281
  447094
  584465
  556704
  619752
  604545
  526949
  489207
  490503
  514975
  516534
  516493
  823879
  397605
  448171
  503787
  506460
  559733
  583176
  556142
  675183
  702038
  585145
  758780
  698154
  778841
  800906
  411515
  442405
  466471
  118359
  395459
  435521
  485855
  495003
  501434
  378272
  514362
  679908
  783563
  796466
  769099
  729013
  766918
  791478
  223663
]
3.62 ms
(1.02%)
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
  118359
  223663
  262435
  378272
  391577
  393868
  395249
  395459
  397605
  398815
  411125
  411515
  416428
  421388
  425281
  435521
  442405
  447094
  448171
  466471
  482182
  485855
  489207
  490503
  495003
  495106
  501434
  503787
  506460
  514362
  514975
  516493
  516534
  526949
  528800
  534430
  541203
  552038
  556084
  556142
  556704
  556743
  559733
  560276
  561282
  562622
  563284
  565638
  583009
  583176
  584465
  585145
  598990
  604545
  606923
  615409
  617112
  619752
  626996
  628744
  635402
  636504
  641890
  644447
  647784
  657804
  663841
  672844
  673254
  675183
  679908
  698154
  698765
  702038
  718826
  720103
  721230
  723726
  726325
  729013
  731173
  733259
  739346
  740070
  742758
  745243
  746293
  748063
  749621
  758780
  762360
  766918
  768962
  769099
  771128
  771898
  776179
  778475
  778574
  778841
  779527
  780977
  781021
  781502
  783563
  783995
  787403
  790912
  791478
  795316
  795948
  796466
  796480
  800906
  802147
  805412
  809813
  809869
  817107
]
2.30 ms
(0.65%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pussy doggy"
]
2.23 ms
(0.63%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pussy рак"
]
1.96 ms
(0.55%)
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.