GET https://search.jues.net/search/embeds/4?q=big%20ass%20beautiful

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.90 ms
(80.88%)
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
  11377
  107060
  159380
  384445
  394391
  400311
  401660
  402164
  403678
  404087
  406799
  412432
  417907
  419062
  421235
  432601
  435872
  444474
  446093
  451389
  466437
  472888
  472957
  477190
  480721
  482115
  484158
  486726
  489863
  490479
  496514
  514917
  523282
  523434
  525466
  536702
  537045
  538172
  539262
  539881
  540459
  540730
  550410
  551728
  557747
  558264
  559334
  562243
  563482
  563685
  588082
  589402
  592490
  598310
  600512
  602967
  608606
  611116
  621872
  641516
  644734
  648527
  648659
  649107
  665717
  677726
  679512
  681756
  690461
  691600
  695158
  698575
  701479
  702176
  704211
  708131
  710333
  718965
  724433
  725183
  736185
  739042
  739081
  742131
  747410
  752587
  753610
  756197
  756671
  757286
  759029
  759696
  759829
  764107
  773296
  774632
  778086
  778761
  781343
  784581
  785490
  787880
  788908
  789489
  789592
  789926
  790236
  791525
  795054
  795570
  797045
  797229
  800902
  802947
  803810
  805776
  811075
  811319
  813500
  813566
]
16.63 ms
(11.22%)
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
  756671
  558264
  551728
  641516
  800902
  742131
  400311
  677726
  419062
  444474
  539881
  472888
  704211
  592490
  789592
  784581
  795054
  811319
  725183
  791525
  803810
  724433
  759696
  797045
  402164
  401660
  446093
  536702
  486726
  797229
  778086
  759829
  773296
  417907
  490479
  785490
  107060
  602967
  482115
  588082
  813500
  753610
  774632
  789489
  159380
  484158
  538172
  802947
  480721
  406799
  489863
  523282
  523434
  540730
  550410
  648659
  679512
  649107
  681756
  691600
  710333
  690461
  702176
  644734
  778761
  795570
  781343
  790236
  759029
  739081
  757286
  736185
  756197
  764107
  611116
  621872
  562243
  563482
  557747
  752587
  403678
  412432
  435872
  432601
  451389
  496514
  466437
  404087
  477190
  665717
  598310
  788908
  813566
  514917
  695158
  600512
  472957
  11377
  525466
  559334
  563685
  718965
  701479
  708131
  805776
  747410
  540459
  539262
  608606
  811075
  421235
  537045
  648527
  698575
  589402
  739042
  789926
  787880
  384445
  394391
]
4.28 ms
(2.88%)
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
  11377
  107060
  159380
  384445
  394391
  400311
  401660
  402164
  403678
  404087
  406799
  412432
  417907
  419062
  421235
  432601
  435872
  444474
  446093
  451389
  466437
  472888
  472957
  477190
  480721
  482115
  484158
  486726
  489863
  490479
  496514
  514917
  523282
  523434
  525466
  536702
  537045
  538172
  539262
  539881
  540459
  540730
  550410
  551728
  557747
  558264
  559334
  562243
  563482
  563685
  588082
  589402
  592490
  598310
  600512
  602967
  608606
  611116
  621872
  641516
  644734
  648527
  648659
  649107
  665717
  677726
  679512
  681756
  690461
  691600
  695158
  698575
  701479
  702176
  704211
  708131
  710333
  718965
  724433
  725183
  736185
  739042
  739081
  742131
  747410
  752587
  753610
  756197
  756671
  757286
  759029
  759696
  759829
  764107
  773296
  774632
  778086
  778761
  781343
  784581
  785490
  787880
  788908
  789489
  789592
  789926
  790236
  791525
  795054
  795570
  797045
  797229
  800902
  802947
  803810
  805776
  811075
  811319
  813500
  813566
]
2.21 ms
(1.49%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big ass beautiful"
]
1.84 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большая большие жоп красивая"
]
1.82 ms
(1.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.