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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.36 ms
(84.73%)
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
  168977
  382363
  383898
  396282
  399415
  416161
  416360
  427869
  429443
  430801
  430806
  434667
  437676
  445573
  448365
  449657
  450241
  450383
  454605
  454741
  454982
  457194
  460009
  466820
  471387
  484543
  489591
  495886
  502289
  503010
  511515
  516662
  521564
  521778
  525115
  526215
  529204
  539398
  546867
  549689
  550088
  555889
  559182
  562497
  562966
  563924
  569092
  569471
  571612
  571793
  572108
  572310
  572803
  575111
  584380
  590286
  591149
  591819
  592559
  594312
  595988
  602052
  605183
  607530
  608345
  618547
  619644
  622057
  623643
  623814
  629042
  629288
  632991
  633034
  636478
  639221
  651926
  656418
  661958
  668493
  671131
  682270
  694923
  695791
  696217
  705371
  710505
  717199
  726034
  726514
  726575
  732607
  742149
  748446
  749219
  749254
  759548
  761291
  761436
  762902
  772890
  774817
  775551
  778364
  781741
  781999
  786038
  787178
  787363
  788697
  789296
  794362
  794826
  798686
  807000
  808056
  809743
  810804
  815456
  818651
]
14.70 ms
(9.00%)
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
  717199
  591149
  592559
  623643
  726575
  726514
  710505
  466820
  761291
  495886
  815456
  539398
  629288
  775551
  809743
  732607
  726034
  383898
  168977
  563924
  661958
  555889
  602052
  632991
  460009
  427869
  437676
  489591
  454605
  396282
  471387
  516662
  546867
  590286
  623814
  772890
  810804
  749219
  748446
  787363
  794826
  416161
  521564
  595988
  636478
  511515
  605183
  749254
  619644
  629042
  457194
  607530
  429443
  450241
  762902
  454982
  656418
  594312
  618547
  445573
  668493
  705371
  695791
  694923
  608345
  633034
  639221
  788697
  774817
  807000
  787178
  789296
  808056
  399415
  448365
  502289
  525115
  550088
  449657
  450383
  569471
  572108
  562497
  591819
  778364
  786038
  781741
  781999
  454741
  503010
  526215
  529204
  382363
  671131
  571612
  572803
  575111
  696217
  651926
  798686
  742149
  759548
  761436
  434667
  571793
  569092
  559182
  572310
  521778
  549689
  562966
  416360
  430801
  430806
  584380
  682270
  622057
  794362
  818651
  484543
]
2.64 ms
(1.62%)
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
  168977
  382363
  383898
  396282
  399415
  416161
  416360
  427869
  429443
  430801
  430806
  434667
  437676
  445573
  448365
  449657
  450241
  450383
  454605
  454741
  454982
  457194
  460009
  466820
  471387
  484543
  489591
  495886
  502289
  503010
  511515
  516662
  521564
  521778
  525115
  526215
  529204
  539398
  546867
  549689
  550088
  555889
  559182
  562497
  562966
  563924
  569092
  569471
  571612
  571793
  572108
  572310
  572803
  575111
  584380
  590286
  591149
  591819
  592559
  594312
  595988
  602052
  605183
  607530
  608345
  618547
  619644
  622057
  623643
  623814
  629042
  629288
  632991
  633034
  636478
  639221
  651926
  656418
  661958
  668493
  671131
  682270
  694923
  695791
  696217
  705371
  710505
  717199
  726034
  726514
  726575
  732607
  742149
  748446
  749219
  749254
  759548
  761291
  761436
  762902
  772890
  774817
  775551
  778364
  781741
  781999
  786038
  787178
  787363
  788697
  789296
  794362
  794826
  798686
  807000
  808056
  809743
  810804
  815456
  818651
]
2.11 ms
(1.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие сиськ out"
]
1.97 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big tits out"
]
1.83 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие сиськ out"
]

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.