GET https://search.jues.net/search/embeds/4?q=old%20man%20hidden

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
190.15 ms
(89.95%)
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
  420398
  429794
  432782
  441017
  447322
  454217
  455912
  456482
  456889
  458031
  459558
  461394
  467402
  467418
  467445
  472616
  484090
  485931
  487067
  487144
  491854
  491885
  491905
  491915
  492163
  492515
  493242
  494768
  498024
  498064
  506659
  511523
  511803
  513280
  515281
  522362
  529546
  545695
  548642
  552083
  553706
  553720
  560152
  560157
  560169
  560429
  560445
  562882
  563846
  565067
  566047
  572176
  574162
  574179
  580296
  584673
  586465
  586472
  586474
  590500
  591607
  593368
  594770
  594830
  594833
  598614
  599436
  600078
  600107
  600115
  605355
  605395
  606738
  610595
  611739
  611820
  611880
  612099
  612336
  617216
  620277
  620282
  620619
  620987
  621504
  623724
  623874
  624215
  624241
  624369
  624511
  674064
  675381
  681478
  682599
  686710
  687551
  689622
  689634
  699025
  699334
  699804
  699808
  700426
  704561
  704726
  704735
  706280
  706676
  706984
  709543
  712973
  712978
  713262
  721617
  721646
  739557
  789677
  799642
  803293
]
12.20 ms
(5.77%)
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
  682599
  689622
  699804
  704726
  704735
  712973
  594833
  617216
  590500
  611880
  623874
  598614
  624241
  699808
  700426
  706280
  713262
  429794
  456889
  459558
  461394
  467445
  511523
  498064
  513280
  611820
  565067
  624215
  560429
  548642
  492163
  458031
  432782
  456482
  467418
  447322
  491905
  498024
  484090
  552083
  560157
  574162
  584673
  675381
  699334
  706984
  712978
  704561
  686710
  687551
  560169
  566047
  594770
  599436
  605355
  610595
  593368
  600107
  600115
  612336
  620277
  620987
  624369
  586465
  586474
  623724
  789677
  803293
  739557
  706676
  467402
  441017
  420398
  522362
  491915
  492515
  485931
  487067
  515281
  506659
  709543
  799642
  545695
  455912
  491854
  529546
  553706
  560445
  574179
  562882
  553720
  560152
  721617
  674064
  681478
  689634
  721646
  699025
  621504
  591607
  606738
  586472
  600078
  605395
  620282
  620619
  624511
  454217
  472616
  491885
  493242
  487144
  511803
  494768
  580296
  611739
  594830
  612099
  563846
  572176
]
2.09 ms
(0.99%)
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
  420398
  429794
  432782
  441017
  447322
  454217
  455912
  456482
  456889
  458031
  459558
  461394
  467402
  467418
  467445
  472616
  484090
  485931
  487067
  487144
  491854
  491885
  491905
  491915
  492163
  492515
  493242
  494768
  498024
  498064
  506659
  511523
  511803
  513280
  515281
  522362
  529546
  545695
  548642
  552083
  553706
  553720
  560152
  560157
  560169
  560429
  560445
  562882
  563846
  565067
  566047
  572176
  574162
  574179
  580296
  584673
  586465
  586472
  586474
  590500
  591607
  593368
  594770
  594830
  594833
  598614
  599436
  600078
  600107
  600115
  605355
  605395
  606738
  610595
  611739
  611820
  611880
  612099
  612336
  617216
  620277
  620282
  620619
  620987
  621504
  623724
  623874
  624215
  624241
  624369
  624511
  674064
  675381
  681478
  682599
  686710
  687551
  689622
  689634
  699025
  699334
  699804
  699808
  700426
  704561
  704726
  704735
  706280
  706676
  706984
  709543
  712973
  712978
  713262
  721617
  721646
  739557
  789677
  799642
  803293
]
2.06 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "old man hidden"
]
1.74 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "old мужчин скрыт"
]
1.69 ms
(0.80%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "old мужчин скрыт"
]

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.