GET https://search.jues.net/search/embeds/2?q=video%20girl

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.41 ms
(87.31%)
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
  185589
  199058
  339415
  392236
  512001
  523627
  526801
  530282
  530964
  532093
  532400
  533444
  535355
  536800
  537039
  537053
  537055
  537079
  537081
  537085
  537087
  537089
  537092
  539330
  553174
  559815
  567027
  568308
  568311
  574202
  580253
  587827
  590109
  595321
  616712
  626818
  627684
  628029
  628032
  634867
  646277
  649840
  652248
  652956
  652990
  653363
  663537
  666376
  681363
  681392
  681657
  681736
  683268
  692104
  692180
  698213
  703307
  706607
  706758
  707206
  713588
  715434
  717583
  722251
  730838
  732202
  735699
  738148
  742245
  743840
  744125
  745880
  746625
  748027
  748095
  748122
  748410
  748508
  748841
  748877
  749655
  751931
  757561
  764155
  768920
  773904
  774052
  777093
  780660
  783143
  785308
  792020
  793743
  794086
  796533
  802399
  811967
  812133
  816845
  818195
  818301
  818931
  820028
  823063
  823096
  823900
  824072
  824426
  824602
  824624
  824830
  825337
  825745
  826261
  826847
  827703
  828349
  828351
]
11.96 ms
(7.18%)
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
  553174
  567027
  530282
  751931
  663537
  745880
  828079
  512001
  526801
  681392
  634867
  825337
  530964
  535355
  627684
  537085
  185589
  536800
  826261
  828349
  692180
  824602
  735699
  580253
  537092
  828351
  532093
  559815
  777093
  744125
  825745
  681657
  824629
  537089
  537079
  652956
  626818
  768920
  537053
  698213
  713588
  749655
  820028
  539330
  628029
  590109
  748410
  703307
  715434
  574202
  706607
  811967
  537039
  824426
  537055
  616712
  774052
  199058
  823900
  824830
  824624
  824072
  785308
  793743
  812133
  730838
  743840
  773904
  748508
  742245
  748841
  628032
  783143
  649840
  652248
  748122
  826847
  818195
  818301
  568311
  692104
  722251
  653363
  587827
  792020
  794086
  746625
  738148
  748095
  757561
  392236
  339415
  818931
  827703
  823063
  537087
  533444
  706758
  666376
  681363
  595321
  802399
  732202
  748027
  796533
  748877
  764155
  717583
  780660
  683268
  823096
  816845
  523627
  537081
  532400
  568308
  681736
  646277
  707206
  652990
]
2.11 ms
(1.27%)
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
  185589
  199058
  339415
  392236
  512001
  523627
  526801
  530282
  530964
  532093
  532400
  533444
  535355
  536800
  537039
  537053
  537055
  537079
  537081
  537085
  537087
  537089
  537092
  539330
  553174
  559815
  567027
  568308
  568311
  574202
  580253
  587827
  590109
  595321
  616712
  626818
  627684
  628029
  628032
  634867
  646277
  649840
  652248
  652956
  652990
  653363
  663537
  666376
  681363
  681392
  681657
  681736
  683268
  692104
  692180
  698213
  703307
  706607
  706758
  707206
  713588
  715434
  717583
  722251
  730838
  732202
  735699
  738148
  742245
  743840
  744125
  745880
  746625
  748027
  748095
  748122
  748410
  748508
  748841
  748877
  749655
  751931
  757561
  764155
  768920
  773904
  774052
  777093
  780660
  783143
  785308
  792020
  793743
  794086
  796533
  802399
  811967
  812133
  816845
  818195
  818301
  818931
  820028
  823063
  823096
  823900
  824072
  824426
  824602
  824624
  824830
  825337
  825745
  826261
  826847
  827703
  828349
  828351
]
1.90 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "video girl"
]
1.72 ms
(1.03%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "video девушк"
]
1.60 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "video девушк"
]

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.