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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
181.91 ms
(89.64%)
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
  395263
  396681
  399356
  407727
  420119
  423748
  425657
  427427
  441822
  445365
  447115
  452591
  454962
  455643
  456493
  457653
  460331
  461742
  462697
  466861
  467083
  469195
  475427
  486544
  487943
  491170
  492197
  494396
  505652
  507877
  510647
  510841
  512865
  515218
  515569
  516022
  522190
  522932
  523237
  523556
  523575
  536768
  540306
  542161
  559554
  561396
  570970
  575344
  589560
  595201
  598881
  608443
  614040
  618778
  629337
  631684
  631976
  638136
  678766
  690032
  716246
  717046
  718338
  720200
  721278
  725310
  727823
  734180
  736795
  741291
  742011
  746688
  748701
  749329
  755716
  756109
  758312
  759460
  759482
  761047
  763444
  765837
  769615
  771933
  772151
  774285
  778841
  779636
  784702
  785005
  787141
  790075
  794088
  794472
  795295
  796829
  797639
  798953
  798983
  799367
  799433
  801897
  805671
  809165
  810207
  810225
  810929
  812624
  813789
  814075
  815197
  816495
  817019
  817794
  818045
  819560
  823403
  824491
  825124
  827956
]
11.96 ms
(5.89%)
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
  475427
  494396
  814075
  817019
  825124
  827956
  575344
  690032
  608443
  810929
  809165
  725310
  784702
  763444
  748701
  749329
  759460
  746688
  769615
  718338
  805671
  523237
  510841
  515218
  522190
  540306
  512865
  720200
  742011
  810207
  818045
  678766
  794088
  523575
  467083
  614040
  736795
  515569
  407727
  810225
  758312
  516022
  631684
  452591
  507877
  813789
  815197
  819560
  824491
  816495
  638136
  779636
  799367
  759482
  727823
  812624
  399356
  486544
  629337
  487943
  466861
  598881
  455643
  536768
  505652
  523556
  796829
  772151
  492197
  445365
  741291
  457653
  469195
  716246
  420119
  542161
  423748
  790075
  799433
  721278
  756109
  395263
  717046
  787141
  798953
  798983
  801897
  785005
  765837
  755716
  771933
  774285
  618778
  794472
  797639
  396681
  425657
  817794
  461742
  447115
  559554
  561396
  570970
  631976
  595201
  734180
  778841
  795295
  427427
  510647
  522932
  761047
  454962
  462697
  491170
  441822
  823403
  460331
  456493
  589560
]
2.50 ms
(1.23%)
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
  395263
  396681
  399356
  407727
  420119
  423748
  425657
  427427
  441822
  445365
  447115
  452591
  454962
  455643
  456493
  457653
  460331
  461742
  462697
  466861
  467083
  469195
  475427
  486544
  487943
  491170
  492197
  494396
  505652
  507877
  510647
  510841
  512865
  515218
  515569
  516022
  522190
  522932
  523237
  523556
  523575
  536768
  540306
  542161
  559554
  561396
  570970
  575344
  589560
  595201
  598881
  608443
  614040
  618778
  629337
  631684
  631976
  638136
  678766
  690032
  716246
  717046
  718338
  720200
  721278
  725310
  727823
  734180
  736795
  741291
  742011
  746688
  748701
  749329
  755716
  756109
  758312
  759460
  759482
  761047
  763444
  765837
  769615
  771933
  772151
  774285
  778841
  779636
  784702
  785005
  787141
  790075
  794088
  794472
  795295
  796829
  797639
  798953
  798983
  799367
  799433
  801897
  805671
  809165
  810207
  810225
  810929
  812624
  813789
  814075
  815197
  816495
  817019
  817794
  818045
  819560
  823403
  824491
  825124
  827956
]
1.89 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "rough big tits"
]
1.75 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.74%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "rough большие сиськ"
]
1.43 ms
(0.71%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "rough большие сиськ"
]

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.