GET https://search.jues.net/search/embeds/5?q=tanned%20wife

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.04 ms
(82.26%)
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
  441462
  459170
  468407
  471743
  472700
  475667
  481442
  484329
  485967
  486619
  487215
  488199
  491624
  492529
  493806
  500576
  500717
  500870
  504517
  504630
  506634
  509505
  509973
  512876
  513301
  513597
  513820
  513848
  516476
  517824
  518017
  519845
  521041
  521316
  521358
  522065
  522684
  523761
  525048
  526904
  528123
  529106
  529898
  529905
  532005
  532011
  532424
  534017
  535416
  537815
  539607
  541535
  542870
  543575
  545968
  553477
  554489
  554839
  555614
  556041
  558473
  559191
  559203
  561289
  563692
  570717
  571146
  571308
  571785
  572245
  572263
  573445
  575279
  575704
  577529
  577587
  580522
  580935
  582574
  584498
  585750
  587928
  588201
  588745
  589122
  592184
  592222
  592653
  592974
  593702
  593952
  595763
  603163
  605074
  605222
  605591
  606375
  609823
  609841
  613517
  613852
  615721
  616910
  619717
  623086
  625520
  625594
  625864
  630328
  630607
  637597
  655582
  658998
  661952
  672761
  679656
  690153
  717179
  717189
  730903
]
19.16 ms
(11.67%)
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
  459170
  513848
  484329
  523761
  522684
  493806
  537815
  518017
  570717
  575279
  585750
  534017
  529106
  575704
  672761
  603163
  587928
  595763
  485967
  509973
  630607
  571308
  588745
  441462
  690153
  472700
  481442
  487215
  471743
  486619
  491624
  509505
  512876
  513820
  521358
  522065
  526904
  504630
  513597
  517824
  519845
  521316
  529898
  500576
  500717
  500870
  506634
  513301
  525048
  528123
  529905
  532424
  539607
  504517
  516476
  521041
  532005
  532011
  535416
  468407
  475667
  488199
  492529
  554489
  558473
  559191
  573445
  577529
  580935
  582574
  584498
  541535
  542870
  543575
  553477
  559203
  563692
  572245
  572263
  554839
  556041
  561289
  571785
  655582
  717189
  658998
  661952
  679656
  717179
  545968
  555614
  571146
  577587
  580522
  592653
  605222
  605591
  609841
  613517
  630328
  588201
  592974
  593702
  606375
  623086
  637597
  593952
  605074
  615721
  616910
  625864
  589122
  592184
  592222
  625520
  625594
  730903
  609823
  613852
  619717
]
2.74 ms
(1.67%)
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
  441462
  459170
  468407
  471743
  472700
  475667
  481442
  484329
  485967
  486619
  487215
  488199
  491624
  492529
  493806
  500576
  500717
  500870
  504517
  504630
  506634
  509505
  509973
  512876
  513301
  513597
  513820
  513848
  516476
  517824
  518017
  519845
  521041
  521316
  521358
  522065
  522684
  523761
  525048
  526904
  528123
  529106
  529898
  529905
  532005
  532011
  532424
  534017
  535416
  537815
  539607
  541535
  542870
  543575
  545968
  553477
  554489
  554839
  555614
  556041
  558473
  559191
  559203
  561289
  563692
  570717
  571146
  571308
  571785
  572245
  572263
  573445
  575279
  575704
  577529
  577587
  580522
  580935
  582574
  584498
  585750
  587928
  588201
  588745
  589122
  592184
  592222
  592653
  592974
  593702
  593952
  595763
  603163
  605074
  605222
  605591
  606375
  609823
  609841
  613517
  613852
  615721
  616910
  619717
  623086
  625520
  625594
  625864
  630328
  630607
  637597
  655582
  658998
  661952
  672761
  679656
  690153
  717179
  717189
  730903
]
2.14 ms
(1.30%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "загорелые жен"
]
1.82 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "загорелые жен"
]
1.70 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "tanned wife"
]
1.57 ms
(0.96%)
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.