GET https://search.jues.net/search/embeds/4?q=teen%20solo%20teen

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
151.28 ms
(88.20%)
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
  381819
  385645
  410655
  413641
  414070
  418219
  420277
  420823
  421369
  428289
  428924
  429144
  430366
  431154
  432927
  445810
  447318
  452875
  452923
  454711
  469221
  471117
  478030
  495747
  497690
  516597
  522288
  527524
  529004
  529606
  529628
  530652
  530970
  538599
  542453
  553583
  558407
  562573
  568211
  572184
  574969
  575616
  575655
  575935
  576564
  580779
  580781
  584848
  594171
  594208
  594306
  595442
  595464
  596649
  597505
  604134
  616837
  616850
  628850
  629226
  635823
  636343
  646439
  646789
  651840
  652212
  652221
  658777
  664266
  666857
  669267
  671097
  672715
  674885
  677470
  681196
  681787
  684850
  687375
  687718
  690173
  700244
  707264
  708544
  708562
  709089
  729674
  732093
  733798
  741660
  742305
  750574
  751385
  752654
  758728
  763407
  770880
  774462
  776092
  777665
  781017
  782858
  783607
  783708
  786792
  789371
  792897
  800507
  803119
  803134
  804806
  806605
  810491
  813734
  814441
  821785
  825808
  826353
]
11.00 ms
(6.41%)
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
  658777
  742305
  803134
  414070
  420277
  432927
  413641
  445810
  478030
  447318
  471117
  497690
  495747
  469221
  594208
  596649
  428924
  452923
  418219
  421369
  430366
  452875
  522288
  652212
  410655
  428289
  431154
  385645
  381819
  420823
  429144
  774462
  826353
  814441
  825808
  823492
  813734
  821785
  454711
  529606
  538599
  530970
  516597
  527524
  529004
  529628
  530652
  542453
  558407
  562573
  575655
  575935
  572184
  574969
  576564
  580779
  568211
  584848
  652221
  664266
  677470
  681787
  687718
  700244
  707264
  708544
  708562
  646439
  646789
  651840
  666857
  669267
  674885
  687375
  690173
  709089
  671097
  672715
  681196
  684850
  553583
  575616
  580781
  604134
  616850
  628850
  629226
  595442
  616837
  635823
  594171
  594306
  595464
  597505
  636343
  776092
  777665
  781017
  783607
  792897
  804806
  782858
  783708
  800507
  803119
  810491
  729674
  732093
  733798
  750574
  751385
  752654
  757736
  758728
  763407
  770880
  786792
  789371
  806605
  741660
]
2.95 ms
(1.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
  381819
  385645
  410655
  413641
  414070
  418219
  420277
  420823
  421369
  428289
  428924
  429144
  430366
  431154
  432927
  445810
  447318
  452875
  452923
  454711
  469221
  471117
  478030
  495747
  497690
  516597
  522288
  527524
  529004
  529606
  529628
  530652
  530970
  538599
  542453
  553583
  558407
  562573
  568211
  572184
  574969
  575616
  575655
  575935
  576564
  580779
  580781
  584848
  594171
  594208
  594306
  595442
  595464
  596649
  597505
  604134
  616837
  616850
  628850
  629226
  635823
  636343
  646439
  646789
  651840
  652212
  652221
  658777
  664266
  666857
  669267
  671097
  672715
  674885
  677470
  681196
  681787
  684850
  687375
  687718
  690173
  700244
  707264
  708544
  708562
  709089
  729674
  732093
  733798
  741660
  742305
  750574
  751385
  752654
  758728
  763407
  770880
  774462
  776092
  777665
  781017
  782858
  783607
  783708
  786792
  789371
  792897
  800507
  803119
  803134
  804806
  806605
  810491
  813734
  814441
  821785
  825808
  826353
]
1.70 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "teen solo teen"
]
1.65 ms
(0.96%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "teen соло teen"
]
1.28 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "teen соло teen"
]

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.