GET https://search.jues.net/search/embeds/8?q=big%20hot%20mom

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.22 ms
(81.90%)
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
  392602
  395166
  395861
  401546
  403907
  405411
  405438
  406882
  407709
  411340
  413164
  419220
  427800
  428300
  443692
  447581
  449256
  450175
  450796
  450807
  456934
  460428
  472536
  474150
  478760
  482239
  484443
  486288
  496112
  502523
  502756
  504951
  504980
  510064
  515623
  515652
  519594
  521528
  521997
  525470
  526742
  528777
  531949
  534018
  536434
  536611
  542597
  554772
  557869
  560474
  563688
  566543
  568391
  570146
  570796
  580221
  580393
  581999
  584541
  590426
  592457
  593068
  602363
  604614
  605581
  605948
  620331
  621540
  623416
  623934
  639774
  663385
  666854
  671730
  705196
  712565
  716566
  720603
  721112
  734487
  746636
  750296
  759980
  760681
  760687
  761570
  763613
  765379
  771815
  772318
  774675
  778260
  781197
  784814
  784981
  786258
  786763
  787272
  788452
  788601
  790635
  790827
  792356
  796435
  799081
  800470
  800864
  805490
  807404
  807522
  807599
  807686
  808730
  811335
  811782
  812418
  813567
  816691
  817010
  824258
]
16.35 ms
(8.52%)
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
  816691
  817010
  447581
  515623
  510064
  534018
  568391
  566543
  663385
  666854
  671730
  580393
  604614
  621540
  605948
  781197
  807404
  808730
  774675
  799081
  800470
  800864
  807522
  772318
  784981
  788601
  796435
  811782
  760687
  771815
  760681
  765379
  716566
  721112
  784814
  786258
  788452
  790827
  792356
  419220
  428300
  456934
  392602
  395861
  427800
  486288
  502523
  502756
  504980
  525470
  515652
  813567
  570146
  563688
  554772
  560474
  705196
  570796
  605581
  590426
  778260
  790635
  786763
  807686
  734487
  750296
  761570
  763613
  602363
  712565
  720603
  805490
  401546
  536434
  450175
  811335
  395166
  639774
  405411
  411340
  824258
  450796
  482239
  531949
  536611
  460428
  581999
  584541
  620331
  746636
  759980
  787272
  478760
  449256
  405438
  443692
  406882
  519594
  521997
  484443
  504951
  528777
  403907
  407709
  413164
  450807
  474150
  521528
  496112
  526742
  472536
  542597
  580221
  557869
  592457
  593068
  623416
  623934
  807599
  812418
]
9.68 ms
(5.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие hot mom"
]
2.68 ms
(1.39%)
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
  392602
  395166
  395861
  401546
  403907
  405411
  405438
  406882
  407709
  411340
  413164
  419220
  427800
  428300
  443692
  447581
  449256
  450175
  450796
  450807
  456934
  460428
  472536
  474150
  478760
  482239
  484443
  486288
  496112
  502523
  502756
  504951
  504980
  510064
  515623
  515652
  519594
  521528
  521997
  525470
  526742
  528777
  531949
  534018
  536434
  536611
  542597
  554772
  557869
  560474
  563688
  566543
  568391
  570146
  570796
  580221
  580393
  581999
  584541
  590426
  592457
  593068
  602363
  604614
  605581
  605948
  620331
  621540
  623416
  623934
  639774
  663385
  666854
  671730
  705196
  712565
  716566
  720603
  721112
  734487
  746636
  750296
  759980
  760681
  760687
  761570
  763613
  765379
  771815
  772318
  774675
  778260
  781197
  784814
  784981
  786258
  786763
  787272
  788452
  788601
  790635
  790827
  792356
  796435
  799081
  800470
  800864
  805490
  807404
  807522
  807599
  807686
  808730
  811335
  811782
  812418
  813567
  816691
  817010
  824258
]
2.21 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big hot mom"
]
1.96 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(0.97%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие hot mom"
]

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.