GET https://search.jues.net/search/embeds/4?q=18%20year

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
117.72 ms
(83.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
  438276
  458628
  474057
  489155
  492016
  500444
  514976
  527165
  533763
  534111
  536825
  539707
  540412
  543657
  552159
  554121
  554180
  556060
  563598
  575681
  582214
  585499
  594632
  597735
  605022
  605900
  608088
  612269
  613293
  613350
  615651
  618187
  618782
  621536
  622334
  622562
  624180
  627111
  627141
  628801
  628846
  628957
  636522
  642679
  649862
  659459
  661709
  664409
  674600
  676522
  677047
  678195
  696194
  700055
  702375
  704638
  708680
  711249
  711699
  712931
  713838
  714080
  715235
  716403
  717235
  719817
  721122
  721771
  724891
  730367
  733090
  736258
  738618
  740166
  740417
  743047
  743355
  748639
  748651
  749501
  749659
  749878
  750722
  756473
  756967
  762483
  764692
  765084
  766188
  767399
  773132
  773903
  773907
  777327
  781580
  782387
  784759
  785227
  785274
  785441
  785492
  786713
  787937
  789139
  789754
  790602
  792579
  795707
  796418
  801718
  805653
  810184
  810548
  811537
  812908
  814419
  817891
  818930
  819870
  827360
]
13.43 ms
(9.49%)
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
  787937
  736258
  738618
  762483
  627141
  782387
  812908
  817891
  827360
  818930
  819870
  740166
  618187
  702375
  721771
  676522
  713838
  719817
  677047
  628846
  618782
  458628
  514976
  527165
  539707
  540412
  474057
  543657
  554180
  582214
  661709
  678195
  712931
  721122
  659459
  696194
  704638
  715235
  556060
  563598
  575681
  605900
  613293
  613350
  628957
  636522
  597735
  622334
  642679
  608088
  784759
  785441
  810548
  811537
  789754
  724891
  743355
  756473
  792579
  748639
  749878
  749501
  766188
  773132
  749659
  765084
  615651
  627111
  711249
  777327
  781580
  785274
  785492
  810184
  730367
  489155
  552159
  711699
  717235
  621536
  605022
  773907
  773903
  795707
  438276
  814419
  536825
  533763
  500444
  554121
  649862
  674600
  714080
  664409
  708680
  716403
  585499
  622562
  628801
  624180
  594632
  612269
  785227
  790602
  805653
  750722
  789139
  801718
  733090
  740417
  748651
  764692
  756967
  767399
  743047
  700055
  786713
  796418
  492016
  534111
]
2.64 ms
(1.87%)
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
  438276
  458628
  474057
  489155
  492016
  500444
  514976
  527165
  533763
  534111
  536825
  539707
  540412
  543657
  552159
  554121
  554180
  556060
  563598
  575681
  582214
  585499
  594632
  597735
  605022
  605900
  608088
  612269
  613293
  613350
  615651
  618187
  618782
  621536
  622334
  622562
  624180
  627111
  627141
  628801
  628846
  628957
  636522
  642679
  649862
  659459
  661709
  664409
  674600
  676522
  677047
  678195
  696194
  700055
  702375
  704638
  708680
  711249
  711699
  712931
  713838
  714080
  715235
  716403
  717235
  719817
  721122
  721771
  724891
  730367
  733090
  736258
  738618
  740166
  740417
  743047
  743355
  748639
  748651
  749501
  749659
  749878
  750722
  756473
  756967
  762483
  764692
  765084
  766188
  767399
  773132
  773903
  773907
  777327
  781580
  782387
  784759
  785227
  785274
  785441
  785492
  786713
  787937
  789139
  789754
  790602
  792579
  795707
  796418
  801718
  805653
  810184
  810548
  811537
  812908
  814419
  817891
  818930
  819870
  827360
]
2.15 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "18 year"
]
2.01 ms
(1.42%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.25%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "18 year"
]
1.69 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "18 year"
]

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.