GET https://search.jues.net/search/embeds/7?q=hairy%20mom%20milf

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.73 ms
(80.03%)
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
  387510
  396768
  400359
  401637
  402997
  407567
  409226
  410563
  415266
  415451
  416263
  426003
  426129
  426183
  426535
  428653
  428853
  431793
  432351
  432810
  442771
  443801
  446789
  448356
  449622
  450654
  454053
  458378
  460191
  461051
  464388
  466192
  470280
  471195
  471461
  474791
  481668
  481942
  481970
  482239
  486533
  486539
  489082
  490117
  492333
  496066
  496118
  498061
  506830
  509309
  510466
  511422
  513151
  513619
  515734
  518156
  519573
  522879
  524896
  526888
  541626
  547930
  550354
  560075
  581173
  585127
  585155
  586445
  586858
  588411
  590932
  592501
  593086
  593397
  596134
  597018
  601115
  611345
  619857
  620159
  622650
  625181
  630782
  633091
  644323
  684232
  724855
  725578
  725579
  728114
  731544
  732029
  733178
  748153
  752950
  755426
  756642
  756816
  775282
  775551
  781946
  783777
  787274
  792529
  792642
  793886
  794606
  800052
  800197
  803760
  807154
  808385
  808636
  809548
  814910
  814926
  815866
  817131
  818459
  825304
]
23.80 ms
(13.73%)
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
  586445
  592501
  593086
  593397
  596134
  597018
  630782
  585155
  590932
  619857
  620159
  807154
  775551
  792642
  800052
  803760
  809548
  748153
  752950
  781946
  787274
  728114
  733178
  724855
  725578
  755426
  756642
  725579
  731544
  756816
  633091
  644323
  775282
  783777
  794606
  800197
  808385
  808636
  396768
  407567
  426003
  387510
  432351
  515734
  541626
  442771
  814926
  482239
  518156
  684232
  601115
  625181
  586858
  792529
  793886
  732029
  622650
  410563
  415266
  449622
  460191
  481668
  498061
  513151
  524896
  489082
  588411
  431793
  510466
  611345
  486533
  486539
  496118
  492333
  428653
  409226
  448356
  454053
  458378
  490117
  461051
  464388
  560075
  550354
  547930
  581173
  428853
  400359
  402997
  416263
  426535
  474791
  481942
  466192
  470280
  481970
  443801
  511422
  513619
  506830
  519573
  526888
  509309
  496066
  401637
  426129
  432810
  415451
  426183
  818459
  825304
  585127
  814910
  817131
  815866
  446789
  450654
  471461
  471195
  522879
]
3.40 ms
(1.96%)
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
  387510
  396768
  400359
  401637
  402997
  407567
  409226
  410563
  415266
  415451
  416263
  426003
  426129
  426183
  426535
  428653
  428853
  431793
  432351
  432810
  442771
  443801
  446789
  448356
  449622
  450654
  454053
  458378
  460191
  461051
  464388
  466192
  470280
  471195
  471461
  474791
  481668
  481942
  481970
  482239
  486533
  486539
  489082
  490117
  492333
  496066
  496118
  498061
  506830
  509309
  510466
  511422
  513151
  513619
  515734
  518156
  519573
  522879
  524896
  526888
  541626
  547930
  550354
  560075
  581173
  585127
  585155
  586445
  586858
  588411
  590932
  592501
  593086
  593397
  596134
  597018
  601115
  611345
  619857
  620159
  622650
  625181
  630782
  633091
  644323
  684232
  724855
  725578
  725579
  728114
  731544
  732029
  733178
  748153
  752950
  755426
  756642
  756816
  775282
  775551
  781946
  783777
  787274
  792529
  792642
  793886
  794606
  800052
  800197
  803760
  807154
  808385
  808636
  809548
  814910
  814926
  815866
  817131
  818459
  825304
]
2.42 ms
(1.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy mom milf"
]
1.93 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая mom milf"
]
1.45 ms
(0.83%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "волосатая mom milf"
]

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.