GET https://search.jues.net/search/embeds/5?q=brunette%20latina%20pov

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.94 ms
(85.75%)
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
  409685
  419217
  429823
  431558
  435745
  444582
  444957
  446003
  447713
  453757
  453779
  455693
  457378
  463852
  473020
  474882
  478320
  483458
  486610
  488663
  491177
  494346
  496586
  496662
  501119
  507590
  510147
  514164
  517916
  520303
  521518
  524585
  527171
  529460
  537064
  541929
  552690
  557853
  564844
  575398
  580423
  580482
  584496
  586178
  587493
  589374
  598633
  604306
  625680
  626284
  626710
  627227
  630347
  634442
  647177
  667792
  669316
  673223
  686351
  703626
  710706
  723573
  731475
  737561
  739268
  740847
  743333
  759243
  764715
  770359
  771182
  772788
  774495
  774688
  774692
  778397
  780748
  784488
  784756
  788075
  788138
  789798
  790737
  794320
  795741
  796869
  797448
  797742
  799318
  802576
  803291
  804963
  805473
  807631
  807749
  807753
  808084
  808701
  810251
  810261
  812266
  812993
  813457
  813471
  814212
  814218
  816077
  819652
  820991
  821066
  821527
  821586
  822002
  822232
  822454
  825117
  825275
  826295
  826324
]
12.96 ms
(8.49%)
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
  822454
  825275
  826295
  453779
  446003
  510147
  537064
  527171
  478320
  564844
  575398
  669316
  667792
  673223
  686351
  625680
  587493
  630347
  589374
  626284
  626710
  789798
  797448
  797742
  799318
  774495
  788138
  795741
  808701
  812266
  813457
  740847
  788075
  805473
  807749
  759243
  764715
  731475
  770359
  772788
  634442
  710706
  780748
  796869
  802576
  803291
  444582
  455693
  474882
  521518
  496662
  473020
  586178
  435745
  488663
  491177
  453757
  514164
  557853
  447713
  431558
  419217
  507590
  524585
  580482
  784488
  784756
  529460
  808084
  826324
  816077
  723573
  819652
  822002
  821066
  821527
  821586
  814218
  483458
  463852
  496586
  520303
  584496
  552690
  580423
  598633
  604306
  780433
  804963
  807753
  737561
  790737
  794320
  813471
  743333
  771182
  627227
  774688
  774692
  812993
  517916
  501119
  541929
  409685
  457378
  486610
  494346
  647177
  703626
  778397
  807631
  810251
  810261
  739268
  429823
  444957
  822232
  825117
  814212
  820991
]
2.36 ms
(1.55%)
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
  409685
  419217
  429823
  431558
  435745
  444582
  444957
  446003
  447713
  453757
  453779
  455693
  457378
  463852
  473020
  474882
  478320
  483458
  486610
  488663
  491177
  494346
  496586
  496662
  501119
  507590
  510147
  514164
  517916
  520303
  521518
  524585
  527171
  529460
  537064
  541929
  552690
  557853
  564844
  575398
  580423
  580482
  584496
  586178
  587493
  589374
  598633
  604306
  625680
  626284
  626710
  627227
  630347
  634442
  647177
  667792
  669316
  673223
  686351
  703626
  710706
  723573
  731475
  737561
  739268
  740847
  743333
  759243
  764715
  770359
  771182
  772788
  774495
  774688
  774692
  778397
  780748
  784488
  784756
  788075
  788138
  789798
  790737
  794320
  795741
  796869
  797448
  797742
  799318
  802576
  803291
  804963
  805473
  807631
  807749
  807753
  808084
  808701
  810251
  810261
  812266
  812993
  813457
  813471
  814212
  814218
  816077
  819652
  820991
  821066
  821527
  821586
  822002
  822232
  822454
  825117
  825275
  826295
  826324
]
1.77 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "черноволосая латинская пов"
]
1.68 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "brunette latina pov"
]
1.63 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "черноволосая латинская пов"
]
1.35 ms
(0.88%)
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.