GET https://search.jues.net/search/embeds/9?q=mother%20hard

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.84 ms
(56.92%)
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
  186793
  187786
  383722
  384082
  389623
  393872
  397014
  397656
  397906
  401876
  407683
  411752
  420474
  423486
  429953
  432663
  433449
  440339
  447789
  451040
  452189
  452767
  453710
  453996
  461397
  462595
  464210
  468348
  476136
  477209
  478035
  481047
  481165
  481169
  482678
  484876
  493186
  493220
  493316
  494659
  496997
  504296
  508782
  509024
  513839
  525497
  533040
  543094
  543250
  543738
  547274
  550360
  552370
  555094
  560346
  561443
  563234
  565257
  570155
  573270
  577385
  582197
  592462
  598194
  606546
  619520
  625521
  641156
  649516
  666396
  668537
  669189
  701476
  702309
  709612
  720719
  721230
  722371
  759967
  763182
  765860
  770501
  773475
  777003
  777043
  784345
  790504
  790882
  795033
  795574
  796440
  800191
  800633
  801235
  801348
  802414
  811007
  812824
  815080
  815559
  817268
  817358
  817527
  817633
  817721
  819735
  820376
  824700
  824957
  825295
  826017
  826019
  826113
  826606
  826750
  826850
  828588
  828700
]
135.90 ms
(37.22%)
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
  186793
  187786
  383722
  384082
  389623
  393872
  397014
  397656
  397906
  401876
  407683
  411752
  420474
  423486
  429953
  432663
  433449
  440339
  447789
  451040
  452189
  452767
  453710
  453996
  461397
  462595
  464210
  468348
  476136
  477209
  478035
  481047
  481165
  481169
  482678
  484876
  493186
  493220
  493316
  494659
  496997
  504296
  508782
  509024
  513839
  525497
  533040
  543094
  543250
  543738
  547274
  550360
  552370
  555094
  560346
  561443
  563234
  565257
  570155
  573270
  577385
  582197
  592462
  598194
  606546
  619520
  625521
  641156
  649516
  666396
  668537
  669189
  701476
  702309
  709612
  720719
  721230
  722371
  759967
  763182
  765860
  770501
  773475
  777003
  777043
  784345
  790504
  790882
  795033
  795574
  796440
  800191
  800633
  801235
  801348
  802414
  811007
  812824
  815080
  815559
  817268
  817358
  817527
  817633
  817721
  819735
  820376
  824700
  824957
  825295
  826017
  826019
  826113
  826606
  826750
  826850
  828588
  828700
]
14.14 ms
(3.87%)
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
  795574
  796440
  802414
  397014
  432663
  817268
  815559
  815080
  468348
  477209
  484876
  493220
  533040
  482678
  573270
  555094
  563234
  565257
  669189
  720719
  649516
  668537
  625521
  592462
  598194
  606546
  777043
  790882
  800191
  801348
  801235
  784345
  765860
  773475
  759967
  619520
  777003
  790504
  811007
  812824
  447789
  452767
  407683
  508782
  397656
  433449
  461397
  481165
  525497
  493186
  560346
  582197
  547274
  702309
  666396
  701476
  709612
  721230
  552370
  641156
  795033
  763182
  384082
  462595
  423486
  481169
  494659
  504296
  186793
  411752
  550360
  800633
  509024
  513839
  770501
  476136
  481047
  440339
  453996
  464210
  493316
  817721
  478035
  570155
  763214
  722371
  429953
  401876
  452189
  577385
  187786
  389623
  397906
  451040
  453710
  496997
  383722
  393872
  420474
  817358
  822751
  824957
  825295
  826017
  826019
  826606
  817633
  819735
  824700
  826750
  826850
  817527
  820376
  826113
  828700
  828588
  543250
  543094
  561443
  543738
]
2.07 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mother hard"
]
1.85 ms
(0.51%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин hard"
]
1.68 ms
(0.46%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(0.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мам женщин hard"
]

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.