GET https://search.jues.net/search/embeds/3?q=big%20tits%20pink

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
173.90 ms
(84.38%)
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
  382233
  384140
  396282
  397886
  398858
  406764
  413235
  417174
  420847
  422032
  422933
  426979
  427971
  429366
  430441
  435047
  438631
  446759
  447534
  450321
  450563
  450573
  451462
  454886
  455047
  455082
  461437
  466379
  478462
  482937
  483527
  483867
  492963
  493116
  496395
  500222
  504787
  509796
  513689
  515275
  516409
  523157
  524809
  529096
  532900
  532976
  532978
  533005
  534389
  547741
  547799
  554442
  556593
  559293
  564170
  568115
  571809
  575630
  578234
  579693
  583209
  589324
  596244
  596470
  604999
  610120
  610680
  615318
  615910
  626960
  642462
  651926
  659344
  669026
  692750
  696435
  703486
  709786
  714725
  715289
  716536
  717174
  721560
  722369
  722522
  722785
  724361
  725390
  733227
  738563
  739769
  740910
  743610
  751435
  753806
  755101
  757020
  757416
  758070
  763738
  774124
  778385
  780231
  784519
  787002
  787073
  789638
  796877
  799693
  803594
  805134
  805136
  805149
  806640
  807360
  812322
  813241
  813418
  820768
  823030
]
14.95 ms
(7.26%)
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
  516409
  396282
  547741
  651926
  610680
  738563
  753806
  813418
  615910
  382233
  406764
  438631
  534389
  596244
  780231
  784519
  774124
  778385
  466379
  554442
  532978
  787073
  716536
  417174
  743610
  455082
  446759
  722369
  575630
  589324
  500222
  669026
  805136
  755101
  757020
  758070
  763738
  787002
  812322
  450321
  823030
  492963
  692750
  722522
  722785
  725390
  733227
  813241
  430441
  578234
  721560
  659344
  724361
  532976
  703486
  493116
  482937
  450573
  483867
  820768
  455047
  384140
  454886
  610120
  422032
  615318
  556593
  398858
  547799
  642462
  740910
  739769
  427971
  568115
  751435
  796877
  450563
  805134
  807360
  757416
  596470
  799693
  483527
  579693
  524809
  509796
  709786
  564170
  789638
  803594
  806640
  435047
  429366
  714725
  583209
  478462
  461437
  559293
  523157
  451462
  504787
  426979
  413235
  496395
  515275
  696435
  604999
  447534
  422933
  715289
  529096
  805149
  626960
  717174
  420847
  532900
  533005
  397886
  513689
  571809
]
5.85 ms
(2.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие сиськ pink"
]
4.51 ms
(2.19%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие сиськ pink"
]
3.25 ms
(1.58%)
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
  382233
  384140
  396282
  397886
  398858
  406764
  413235
  417174
  420847
  422032
  422933
  426979
  427971
  429366
  430441
  435047
  438631
  446759
  447534
  450321
  450563
  450573
  451462
  454886
  455047
  455082
  461437
  466379
  478462
  482937
  483527
  483867
  492963
  493116
  496395
  500222
  504787
  509796
  513689
  515275
  516409
  523157
  524809
  529096
  532900
  532976
  532978
  533005
  534389
  547741
  547799
  554442
  556593
  559293
  564170
  568115
  571809
  575630
  578234
  579693
  583209
  589324
  596244
  596470
  604999
  610120
  610680
  615318
  615910
  626960
  642462
  651926
  659344
  669026
  692750
  696435
  703486
  709786
  714725
  715289
  716536
  717174
  721560
  722369
  722522
  722785
  724361
  725390
  733227
  738563
  739769
  740910
  743610
  751435
  753806
  755101
  757020
  757416
  758070
  763738
  774124
  778385
  780231
  784519
  787002
  787073
  789638
  796877
  799693
  803594
  805134
  805136
  805149
  806640
  807360
  812322
  813241
  813418
  820768
  823030
]
1.97 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big tits pink"
]
1.64 ms
(0.80%)
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.