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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
208.31 ms
(58.48%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
125.58 ms
(35.25%)
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
  20031
  146855
  381871
  383234
  390125
  390380
  391144
  391266
  395276
  395389
  398022
  398908
  400956
  401824
  402128
  404267
  404339
  405112
  408447
  411133
  415487
  417758
  418083
  418530
  419625
  420091
  420507
  420685
  426944
  427526
  428685
  430737
  431687
  443351
  443440
  444005
  454674
  455009
  458713
  459496
  460179
  460215
  460801
  461482
  461532
  464688
  464713
  465950
  467134
  467384
  470341
  470509
  471342
  471723
  473549
  475444
  476632
  476681
  477876
  478715
  478828
  481340
  483620
  484952
  485641
  488135
  488137
  489148
  491026
  494350
  495387
  499957
  500736
  500862
  500905
  506144
  510203
  510796
  510985
  512974
  516301
  523155
  524365
  525543
  525823
  525893
  526841
  538936
  542072
  551370
  552971
  557486
  560642
  565564
  566063
  567566
  570231
  571793
  571884
  573925
  575426
  587247
  591073
  591248
  593341
  598066
  600191
  601142
  606817
  620475
  654446
  670190
  679091
  715402
  715478
  779267
  784237
  805027
  805031
  807345
]
14.61 ms
(4.10%)
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
  525543
  494350
  510796
  516301
  526841
  670190
  405112
  391266
  567566
  408447
  381871
  476632
  510203
  538936
  552971
  565564
  571793
  571884
  542072
  557486
  593341
  591073
  601142
  606817
  419625
  426944
  427526
  443351
  460179
  471723
  395276
  443440
  470509
  471342
  390125
  418530
  420685
  458713
  478715
  478828
  485641
  488137
  499957
  500736
  512974
  483620
  500862
  523155
  524365
  491026
  525823
  525893
  715478
  383234
  146855
  398022
  401824
  402128
  430737
  460215
  484952
  489148
  467134
  488135
  495387
  510985
  500905
  506144
  551370
  566063
  570231
  575426
  654446
  715402
  679091
  560642
  573925
  598066
  591248
  600191
  587247
  779267
  807345
  784237
  805031
  805027
  620475
  411133
  415487
  420507
  431687
  461482
  475444
  477876
  481340
  390380
  395389
  398908
  404267
  418083
  420091
  428685
  455009
  459496
  460801
  461532
  465950
  473549
  20031
  391144
  400956
  417758
  444005
  454674
  464688
  464713
  467384
  470341
  476681
  404339
]
2.57 ms
(0.72%)
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
  20031
  146855
  381871
  383234
  390125
  390380
  391144
  391266
  395276
  395389
  398022
  398908
  400956
  401824
  402128
  404267
  404339
  405112
  408447
  411133
  415487
  417758
  418083
  418530
  419625
  420091
  420507
  420685
  426944
  427526
  428685
  430737
  431687
  443351
  443440
  444005
  454674
  455009
  458713
  459496
  460179
  460215
  460801
  461482
  461532
  464688
  464713
  465950
  467134
  467384
  470341
  470509
  471342
  471723
  473549
  475444
  476632
  476681
  477876
  478715
  478828
  481340
  483620
  484952
  485641
  488135
  488137
  489148
  491026
  494350
  495387
  499957
  500736
  500862
  500905
  506144
  510203
  510796
  510985
  512974
  516301
  523155
  524365
  525543
  525823
  525893
  526841
  538936
  542072
  551370
  552971
  557486
  560642
  565564
  566063
  567566
  570231
  571793
  571884
  573925
  575426
  587247
  591073
  591248
  593341
  598066
  600191
  601142
  606817
  620475
  654446
  670190
  679091
  715402
  715478
  779267
  784237
  805027
  805031
  807345
]
1.73 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие красивая"
]
1.72 ms
(0.48%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие красивая"
]
1.71 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big beautiful"
]

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.