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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
168.55 ms
(86.29%)
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
  72499
  145343
  145646
  205011
  382006
  382385
  385812
  386740
  387052
  388124
  388631
  390082
  391405
  418161
  421147
  433766
  446786
  449335
  456037
  457567
  462567
  471038
  471057
  472606
  474782
  476162
  487328
  487790
  488277
  490587
  490825
  495021
  499849
  500472
  505641
  506855
  510923
  516990
  529458
  531593
  533390
  541013
  541116
  546016
  548414
  550530
  554783
  557707
  557735
  558174
  558318
  559313
  560828
  563683
  563729
  564230
  576597
  576771
  578156
  578177
  583579
  584304
  586954
  588017
  588242
  589467
  592985
  595922
  596967
  599354
  602466
  605686
  607345
  607526
  609057
  610055
  637245
  641485
  641807
  643201
  647534
  658797
  664968
  665372
  666114
  668699
  670952
  677371
  683257
  691578
  704121
  709367
  714418
  714531
  715370
  716349
  717601
  721906
  725564
  730159
  730847
  736600
  739085
  739759
  746013
  749485
  753580
  770114
  776473
  794399
  794701
  802621
  806801
  806827
  807837
  809926
  819310
  819347
  823744
  823978
]
16.01 ms
(8.20%)
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
  550530
  557735
  607345
  72499
  382006
  495021
  462567
  456037
  474782
  558174
  558318
  563729
  560828
  487328
  487790
  510923
  516990
  476162
  715370
  641485
  730159
  730847
  794399
  736600
  725564
  418161
  546016
  557707
  819310
  794701
  819347
  823744
  457567
  490587
  471038
  578156
  666114
  647534
  683257
  714418
  717601
  806801
  749485
  739085
  746013
  607526
  714531
  721906
  806827
  809926
  753580
  533390
  386740
  472606
  471057
  488277
  563683
  548414
  668699
  670952
  677371
  564230
  583579
  595922
  605686
  596967
  449335
  382385
  388631
  145646
  823978
  499849
  446786
  554783
  609057
  385812
  433766
  529458
  531593
  584304
  576771
  665372
  586954
  500472
  505641
  658797
  592985
  637245
  506855
  599354
  421147
  704121
  716349
  390082
  490825
  641807
  643201
  739759
  588017
  610055
  205011
  578177
  691578
  807837
  770114
  145343
  541116
  559313
  664968
  709367
  576597
  589467
  802621
  776473
  388124
  391405
  541013
  588242
  387052
  602466
]
3.30 ms
(1.69%)
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
  72499
  145343
  145646
  205011
  382006
  382385
  385812
  386740
  387052
  388124
  388631
  390082
  391405
  418161
  421147
  433766
  446786
  449335
  456037
  457567
  462567
  471038
  471057
  472606
  474782
  476162
  487328
  487790
  488277
  490587
  490825
  495021
  499849
  500472
  505641
  506855
  510923
  516990
  529458
  531593
  533390
  541013
  541116
  546016
  548414
  550530
  554783
  557707
  557735
  558174
  558318
  559313
  560828
  563683
  563729
  564230
  576597
  576771
  578156
  578177
  583579
  584304
  586954
  588017
  588242
  589467
  592985
  595922
  596967
  599354
  602466
  605686
  607345
  607526
  609057
  610055
  637245
  641485
  641807
  643201
  647534
  658797
  664968
  665372
  666114
  668699
  670952
  677371
  683257
  691578
  704121
  709367
  714418
  714531
  715370
  716349
  717601
  721906
  725564
  730159
  730847
  736600
  739085
  739759
  746013
  749485
  753580
  770114
  776473
  794399
  794701
  802621
  806801
  806827
  807837
  809926
  819310
  819347
  823744
  823978
]
2.39 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big hairy vagina"
]
1.90 ms
(0.97%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.64 ms
(0.84%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие волосатая вагин"
]
1.53 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.