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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
187.94 ms
(87.60%)
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
  78926
  154844
  383000
  391873
  397899
  398552
  401508
  417829
  419253
  430526
  442035
  448651
  473005
  482132
  486243
  489230
  495516
  496150
  500505
  505451
  514034
  518641
  524169
  526122
  531877
  532659
  534532
  536399
  542370
  543669
  544749
  547856
  550303
  551057
  551810
  551813
  563265
  571136
  576512
  577210
  583716
  589042
  607248
  613032
  626021
  630670
  653888
  658784
  661455
  662022
  663567
  667981
  673923
  679445
  680588
  681804
  685013
  685819
  687362
  689525
  692438
  692450
  692453
  693755
  693761
  705119
  708303
  709546
  710056
  710096
  713454
  715176
  717615
  718327
  720138
  720139
  720202
  724109
  724304
  725309
  726455
  728956
  731113
  732666
  742353
  742363
  742684
  745896
  745917
  746235
  747560
  750154
  754289
  755370
  755478
  764071
  764220
  768670
  769418
  772714
  783627
  784038
  784066
  784120
  784236
  784324
  788026
  791101
  792246
  796204
  798135
  800958
  809562
  812561
  814379
  817240
  818465
  824498
  826238
  827484
]
15.25 ms
(7.11%)
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
  817240
  514034
  495516
  505451
  532659
  576512
  661455
  663567
  784236
  725309
  755478
  764220
  812561
  742353
  764071
  783627
  784066
  784120
  401508
  550303
  542370
  662022
  680588
  571136
  720138
  544749
  526122
  724304
  524169
  547856
  720202
  500505
  551813
  551057
  796204
  482132
  713454
  442035
  826238
  827484
  818465
  486243
  563265
  692438
  692450
  705119
  679445
  689525
  717615
  589042
  724109
  750154
  769418
  772714
  784324
  791101
  742363
  754289
  768670
  732666
  715176
  784038
  809562
  419253
  489230
  448651
  154844
  531877
  583716
  687362
  692453
  710096
  667981
  673923
  728956
  745896
  742684
  726455
  745917
  720139
  473005
  630670
  417829
  653888
  693761
  709546
  681804
  685819
  607248
  788026
  746235
  708303
  536399
  383000
  430526
  551810
  792246
  398552
  496150
  798135
  397899
  391873
  577210
  78926
  824498
  814379
  534532
  518641
  543669
  658784
  685013
  693755
  710056
  718327
  613032
  626021
  800958
  731113
  747560
  755370
]
3.32 ms
(1.55%)
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
  78926
  154844
  383000
  391873
  397899
  398552
  401508
  417829
  419253
  430526
  442035
  448651
  473005
  482132
  486243
  489230
  495516
  496150
  500505
  505451
  514034
  518641
  524169
  526122
  531877
  532659
  534532
  536399
  542370
  543669
  544749
  547856
  550303
  551057
  551810
  551813
  563265
  571136
  576512
  577210
  583716
  589042
  607248
  613032
  626021
  630670
  653888
  658784
  661455
  662022
  663567
  667981
  673923
  679445
  680588
  681804
  685013
  685819
  687362
  689525
  692438
  692450
  692453
  693755
  693761
  705119
  708303
  709546
  710056
  710096
  713454
  715176
  717615
  718327
  720138
  720139
  720202
  724109
  724304
  725309
  726455
  728956
  731113
  732666
  742353
  742363
  742684
  745896
  745917
  746235
  747560
  750154
  754289
  755370
  755478
  764071
  764220
  768670
  769418
  772714
  783627
  784038
  784066
  784120
  784236
  784324
  788026
  791101
  792246
  796204
  798135
  800958
  809562
  812561
  814379
  817240
  818465
  824498
  826238
  827484
]
2.28 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur wife double"
]
2.09 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск жен double"
]
1.88 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.79 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск жен double"
]

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.