GET https://search.jues.net/search/embeds/6?q=deep%20amateur

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
163.95 ms
(85.72%)
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
  382318
  384978
  394490
  398993
  400554
  412729
  441516
  449472
  451309
  506526
  512507
  518250
  544573
  545020
  550186
  551517
  563015
  584961
  587582
  591765
  600328
  600957
  604269
  604659
  605587
  616612
  619864
  623176
  626173
  629194
  633855
  645365
  645634
  648623
  655279
  656625
  668662
  668987
  669967
  670915
  690052
  695016
  695690
  698725
  698785
  703318
  708560
  709838
  717432
  720463
  724129
  724569
  724789
  725349
  726082
  726983
  727792
  728779
  731222
  733059
  734297
  734640
  735120
  737827
  739355
  741807
  746658
  750280
  750298
  750775
  751152
  751642
  754440
  759648
  760458
  762049
  763128
  763222
  763404
  764602
  767029
  767393
  768198
  768388
  776622
  777035
  777933
  778259
  778499
  780308
  780491
  782939
  783038
  783805
  784570
  787189
  787747
  788011
  790056
  790552
  791233
  793474
  794877
  795585
  797614
  802032
  806889
  810136
  810870
  811248
  812946
  812958
  812961
  814241
  819431
  823958
  826025
]
17.67 ms
(9.24%)
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
  726983
  734297
  750775
  760458
  724569
  733059
  737827
  751642
  739355
  741807
  751152
  763128
  763404
  767029
  746729
  750280
  762017
  764602
  768198
  771059
  708560
  776622
  778259
  778499
  780308
  812958
  400554
  506526
  670915
  690052
  604269
  626173
  724129
  728779
  633855
  544573
  563015
  703318
  591765
  791233
  441516
  451309
  551517
  545020
  645365
  668987
  695690
  717432
  655279
  669967
  698785
  645634
  648623
  656625
  668662
  695016
  605587
  600957
  616612
  619864
  623176
  600328
  587582
  734640
  768388
  727792
  746658
  726082
  629194
  698725
  777035
  512507
  394490
  412729
  823958
  814241
  826025
  819431
  518250
  550186
  720463
  584961
  604659
  787189
  787747
  790552
  797614
  806889
  794877
  812961
  724789
  731222
  754440
  763222
  783038
  788011
  790056
  802032
  810870
  811248
  812946
  725349
  759648
  762049
  735120
  750298
  767393
  709838
  777933
  780491
  782939
  783805
  784570
  793474
  810136
  398993
  795585
  384978
  382318
  449472
]
2.86 ms
(1.50%)
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
  382318
  384978
  394490
  398993
  400554
  412729
  441516
  449472
  451309
  506526
  512507
  518250
  544573
  545020
  550186
  551517
  563015
  584961
  587582
  591765
  600328
  600957
  604269
  604659
  605587
  616612
  619864
  623176
  626173
  629194
  633855
  645365
  645634
  648623
  655279
  656625
  668662
  668987
  669967
  670915
  690052
  695016
  695690
  698725
  698785
  703318
  708560
  709838
  717432
  720463
  724129
  724569
  724789
  725349
  726082
  726983
  727792
  728779
  731222
  733059
  734297
  734640
  735120
  737827
  739355
  741807
  746658
  750280
  750298
  750775
  751152
  751642
  754440
  759648
  760458
  762049
  763128
  763222
  763404
  764602
  767029
  767393
  768198
  768388
  776622
  777035
  777933
  778259
  778499
  780308
  780491
  782939
  783038
  783805
  784570
  787189
  787747
  788011
  790056
  790552
  791233
  793474
  794877
  795585
  797614
  802032
  806889
  810136
  810870
  811248
  812946
  812958
  812961
  814241
  819431
  823958
  826025
]
2.06 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "deep любительск"
]
1.85 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "deep любительск"
]
1.52 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "deep amateur"
]
1.35 ms
(0.71%)
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.