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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.69 ms
(82.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
  384803
  392024
  416959
  425489
  427317
  428882
  428996
  434017
  434344
  434368
  448365
  448515
  448640
  465894
  468328
  471591
  472019
  479043
  479394
  486169
  486751
  490519
  491970
  497964
  498853
  498865
  499352
  504564
  509206
  511812
  517017
  521992
  527753
  529634
  533384
  533594
  534953
  538843
  539224
  540194
  541394
  542397
  544497
  545325
  547453
  547471
  547475
  547477
  547501
  547570
  549268
  549604
  549996
  551020
  551682
  551770
  553915
  556641
  556794
  557322
  557732
  562141
  563069
  563071
  565039
  565547
  565980
  567045
  567097
  567396
  568560
  569196
  569948
  570797
  571035
  572599
  572650
  574196
  576262
  576662
  579170
  581972
  582339
  583851
  584696
  585301
  585380
  586168
  590707
  590904
  591644
  592015
  594557
  594778
  599212
  603161
  605129
  605652
  614935
  615946
  624197
  624776
  628105
  629009
  660364
  660369
  668690
  670356
  671038
  671923
  672138
  672942
  672944
  782760
  806947
  807176
  808046
  811627
  826449
  828380
]
18.12 ms
(11.05%)
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
  826449
  828380
  486169
  448365
  490519
  504564
  533384
  499352
  521992
  533594
  529634
  534953
  538843
  539224
  540194
  541394
  544497
  547475
  547501
  549268
  551682
  551770
  553915
  557322
  563071
  567045
  567396
  572599
  582339
  583851
  545325
  549604
  557732
  565039
  569196
  569948
  574196
  576662
  584696
  542397
  547453
  547477
  549996
  556641
  556794
  563069
  565980
  568560
  572650
  672944
  660364
  660369
  670356
  672138
  668690
  671038
  671923
  672942
  547471
  547570
  551020
  562141
  565547
  567097
  570797
  579170
  585380
  590707
  585301
  592015
  594557
  594778
  605129
  614935
  624197
  628105
  590904
  599212
  603161
  605652
  615946
  586168
  591644
  808046
  806947
  807176
  811627
  629009
  782760
  479394
  384803
  434368
  392024
  465894
  471591
  479043
  427317
  434017
  434344
  472019
  428882
  428996
  468328
  509206
  491970
  498853
  498865
  486751
  527753
  416959
  511812
  624776
  425489
  448515
  448640
  497964
  517017
  576262
  581972
  571035
]
2.85 ms
(1.74%)
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
  384803
  392024
  416959
  425489
  427317
  428882
  428996
  434017
  434344
  434368
  448365
  448515
  448640
  465894
  468328
  471591
  472019
  479043
  479394
  486169
  486751
  490519
  491970
  497964
  498853
  498865
  499352
  504564
  509206
  511812
  517017
  521992
  527753
  529634
  533384
  533594
  534953
  538843
  539224
  540194
  541394
  542397
  544497
  545325
  547453
  547471
  547475
  547477
  547501
  547570
  549268
  549604
  549996
  551020
  551682
  551770
  553915
  556641
  556794
  557322
  557732
  562141
  563069
  563071
  565039
  565547
  565980
  567045
  567097
  567396
  568560
  569196
  569948
  570797
  571035
  572599
  572650
  574196
  576262
  576662
  579170
  581972
  582339
  583851
  584696
  585301
  585380
  586168
  590707
  590904
  591644
  592015
  594557
  594778
  599212
  603161
  605129
  605652
  614935
  615946
  624197
  624776
  628105
  629009
  660364
  660369
  668690
  670356
  671038
  671923
  672138
  672942
  672944
  782760
  806947
  807176
  808046
  811627
  826449
  828380
]
2.03 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "skinny brunette milf"
]
1.84 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "худые черноволосая milf"
]
1.81 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худые черноволосая milf"
]
1.67 ms
(1.02%)
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.