GET https://search.jues.net/search/embeds/2?q=pink%20boobs

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.20 ms
(82.37%)
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
  34830
  395623
  396282
  406764
  408709
  417174
  423342
  425283
  426979
  427971
  429150
  429366
  431062
  434115
  435325
  439623
  443029
  447238
  450321
  450563
  450573
  451152
  451462
  454886
  455082
  460548
  465891
  482937
  483867
  488724
  496395
  509796
  510334
  512987
  515275
  515659
  516409
  516861
  524126
  524809
  526367
  531949
  532976
  532978
  538912
  541448
  541478
  554442
  556593
  558194
  568115
  571809
  578234
  579693
  584086
  596470
  599644
  602147
  603776
  604999
  607288
  608534
  608827
  610120
  613489
  615318
  615910
  615921
  630078
  631173
  634543
  634801
  659344
  670980
  679200
  679801
  696435
  715289
  716536
  718785
  721560
  724114
  724361
  727143
  734687
  742641
  743610
  743641
  745942
  747322
  751435
  756307
  757416
  758070
  758229
  763738
  769209
  769409
  784039
  784679
  787002
  787073
  796862
  796877
  805134
  805136
  805149
  806385
  807360
  812322
  820330
  820759
  820768
]
16.53 ms
(10.46%)
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
  805136
  769209
  787073
  745942
  758229
  742641
  747322
  756307
  758070
  763738
  716536
  784039
  787002
  812322
  34830
  395623
  465891
  434115
  408709
  820768
  447238
  512987
  541478
  584086
  541448
  670980
  679200
  659344
  607288
  608827
  805134
  807360
  784679
  724361
  727143
  769409
  796862
  743641
  757416
  734687
  806385
  423342
  425283
  429150
  556593
  406764
  435325
  820330
  482937
  531949
  524126
  538912
  496395
  515275
  578234
  696435
  721560
  602147
  615318
  615910
  604999
  805149
  724114
  631173
  451462
  396282
  460548
  455082
  510334
  427971
  429366
  450321
  450573
  454886
  532978
  532976
  516409
  568115
  554442
  715289
  718785
  610120
  596470
  615921
  630078
  743610
  751435
  796877
  426979
  443029
  417174
  450563
  483867
  524809
  579693
  509796
  451152
  526367
  571809
  488724
  558194
  613489
  431062
  820759
  603776
  599644
  608534
  634543
  634801
  439623
  515659
  679801
  516861
]
4.26 ms
(2.70%)
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
  34830
  395623
  396282
  406764
  408709
  417174
  423342
  425283
  426979
  427971
  429150
  429366
  431062
  434115
  435325
  439623
  443029
  447238
  450321
  450563
  450573
  451152
  451462
  454886
  455082
  460548
  465891
  482937
  483867
  488724
  496395
  509796
  510334
  512987
  515275
  515659
  516409
  516861
  524126
  524809
  526367
  531949
  532976
  532978
  538912
  541448
  541478
  554442
  556593
  558194
  568115
  571809
  578234
  579693
  584086
  596470
  599644
  602147
  603776
  604999
  607288
  608534
  608827
  610120
  613489
  615318
  615910
  615921
  630078
  631173
  634543
  634801
  659344
  670980
  679200
  679801
  696435
  715289
  716536
  718785
  721560
  724114
  724361
  727143
  734687
  742641
  743610
  743641
  745942
  747322
  751435
  756307
  757416
  758070
  758229
  763738
  769209
  769409
  784039
  784679
  787002
  787073
  796862
  796877
  805134
  805136
  805149
  806385
  807360
  812322
  820330
  820759
  820768
]
2.25 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pink boobs"
]
1.76 ms
(1.11%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pink boobs"
]
1.62 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pink boobs"
]
1.45 ms
(0.91%)
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.