GET https://search.jues.net/search/embeds/9?q=wife%20latina

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
118.95 ms
(82.62%)
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
  381887
  480251
  503061
  507252
  514282
  530411
  530994
  531674
  532220
  535970
  545034
  550106
  551930
  554491
  555713
  557636
  575833
  582816
  583686
  594831
  597896
  598371
  601221
  607948
  609686
  621730
  626111
  628595
  632386
  635739
  639376
  645653
  646090
  646173
  648394
  649092
  649348
  649459
  650717
  651348
  653684
  672727
  681776
  683970
  687409
  687435
  710355
  712183
  713401
  714888
  715179
  717473
  718117
  718118
  719309
  720521
  721707
  727229
  739938
  740120
  740663
  744777
  745772
  746219
  747173
  748433
  751397
  759010
  759617
  773853
  784762
  789268
  793781
  795764
  796603
  797329
  800833
  804587
  811533
  813673
  814061
  814430
  814716
  816759
  817105
  817196
  817215
  817638
  818269
  818286
  818879
  818891
  819170
  819171
  819178
  819284
  819292
  819377
  819397
  819398
  819428
  819473
  820135
  820376
  823277
  823545
  824136
  824350
  824444
  824707
  825220
  825393
  825916
  826284
  826606
  826647
  826711
  827341
  827559
]
14.29 ms
(9.93%)
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
  759010
  784762
  575833
  632386
  818879
  503061
  651348
  712183
  653684
  601221
  607948
  621730
  795764
  811533
  789268
  746219
  759617
  745772
  751397
  710355
  796603
  744777
  740663
  793781
  814061
  545034
  649092
  598371
  628595
  804587
  747173
  797329
  800833
  727229
  740120
  773853
  739938
  748433
  583686
  381887
  814430
  817638
  818269
  819398
  825916
  826606
  826647
  826711
  814716
  816642
  816759
  817215
  818891
  819178
  819377
  824136
  824444
  824707
  825393
  817105
  817196
  818286
  819170
  819473
  820376
  823277
  823545
  826284
  813673
  819171
  819284
  819292
  819397
  819428
  820135
  824350
  825220
  827341
  827559
  480251
  507252
  530994
  532220
  530411
  514282
  531674
  535970
  550106
  555713
  557636
  582816
  551930
  554491
  646090
  646173
  648394
  649348
  683970
  713401
  719309
  672727
  681776
  687435
  714888
  715179
  720521
  645653
  649459
  650717
  687409
  717473
  718117
  718118
  721707
  597896
  594831
  609686
  626111
  635739
  639376
]
3.40 ms
(2.36%)
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
  381887
  480251
  503061
  507252
  514282
  530411
  530994
  531674
  532220
  535970
  545034
  550106
  551930
  554491
  555713
  557636
  575833
  582816
  583686
  594831
  597896
  598371
  601221
  607948
  609686
  621730
  626111
  628595
  632386
  635739
  639376
  645653
  646090
  646173
  648394
  649092
  649348
  649459
  650717
  651348
  653684
  672727
  681776
  683970
  687409
  687435
  710355
  712183
  713401
  714888
  715179
  717473
  718117
  718118
  719309
  720521
  721707
  727229
  739938
  740120
  740663
  744777
  745772
  746219
  747173
  748433
  751397
  759010
  759617
  773853
  784762
  789268
  793781
  795764
  796603
  797329
  800833
  804587
  811533
  813673
  814061
  814430
  814716
  816759
  817105
  817196
  817215
  817638
  818269
  818286
  818879
  818891
  819170
  819171
  819178
  819284
  819292
  819377
  819397
  819398
  819428
  819473
  820135
  820376
  823277
  823545
  824136
  824350
  824444
  824707
  825220
  825393
  825916
  826284
  826606
  826647
  826711
  827341
  827559
]
2.16 ms
(1.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "wife latina"
]
1.86 ms
(1.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "жен латинская"
]
1.63 ms
(1.13%)
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.