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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
170.65 ms
(87.57%)
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
  365546
  385466
  385894
  388112
  395520
  398866
  402534
  404364
  408043
  409939
  418291
  420295
  425966
  431691
  433030
  434091
  434109
  434112
  435016
  441593
  444147
  455041
  455124
  456586
  464568
  468294
  473249
  474591
  477656
  478626
  479030
  480338
  483677
  484396
  484807
  488476
  488986
  492097
  494274
  495154
  496291
  499568
  501948
  507214
  508703
  509318
  509836
  511660
  517750
  519912
  520796
  521380
  526895
  527616
  528362
  533118
  538138
  541479
  543924
  546366
  548089
  548837
  550514
  552016
  553430
  555479
  556862
  559308
  560526
  564749
  565790
  572900
  576230
  576440
  579192
  580033
  583158
  584038
  586588
  587300
  592926
  594560
  595097
  596470
  600483
  600688
  602821
  605420
  607384
  614071
  615938
  618768
  619085
  621352
  629457
  629498
  634746
  641807
  644005
  664280
  664578
  666669
  680818
  681220
  687378
  727109
  742383
  742891
  744843
  746122
  770108
  780680
  789269
  794399
  796536
  804449
  804622
  806730
  810524
  814723
]
15.02 ms
(7.71%)
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
  538138
  680818
  780680
  402534
  629498
  770108
  794399
  615938
  468294
  592926
  365546
  796536
  586588
  388112
  614071
  398866
  564749
  409939
  600688
  533118
  441593
  434091
  584038
  546366
  395520
  806730
  464568
  418291
  521380
  528362
  479030
  594560
  579192
  641807
  519912
  681220
  434109
  742383
  814723
  478626
  559308
  480338
  552016
  509836
  583158
  587300
  629457
  804622
  746122
  541479
  488986
  556862
  595097
  477656
  560526
  744843
  404364
  727109
  520796
  789269
  804449
  488476
  494274
  618768
  435016
  483677
  548837
  810524
  433030
  509318
  600483
  431691
  444147
  434112
  496291
  385894
  420295
  580033
  484396
  455124
  687378
  385466
  553430
  664578
  742891
  456586
  484807
  576230
  634746
  501948
  508703
  572900
  474591
  602821
  492097
  565790
  607384
  517750
  495154
  425966
  473249
  455041
  543924
  526895
  621352
  527616
  550514
  596470
  576440
  548089
  605420
  619085
  644005
  664280
  666669
  507214
  499568
  555479
  511660
  408043
]
3.00 ms
(1.54%)
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
  365546
  385466
  385894
  388112
  395520
  398866
  402534
  404364
  408043
  409939
  418291
  420295
  425966
  431691
  433030
  434091
  434109
  434112
  435016
  441593
  444147
  455041
  455124
  456586
  464568
  468294
  473249
  474591
  477656
  478626
  479030
  480338
  483677
  484396
  484807
  488476
  488986
  492097
  494274
  495154
  496291
  499568
  501948
  507214
  508703
  509318
  509836
  511660
  517750
  519912
  520796
  521380
  526895
  527616
  528362
  533118
  538138
  541479
  543924
  546366
  548089
  548837
  550514
  552016
  553430
  555479
  556862
  559308
  560526
  564749
  565790
  572900
  576230
  576440
  579192
  580033
  583158
  584038
  586588
  587300
  592926
  594560
  595097
  596470
  600483
  600688
  602821
  605420
  607384
  614071
  615938
  618768
  619085
  621352
  629457
  629498
  634746
  641807
  644005
  664280
  664578
  666669
  680818
  681220
  687378
  727109
  742383
  742891
  744843
  746122
  770108
  780680
  789269
  794399
  796536
  804449
  804622
  806730
  810524
  814723
]
1.86 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вагин большие"
]
1.70 ms
(0.87%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.39 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "vagina big"
]
1.26 ms
(0.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.