GET https://search.jues.net/search/embeds/3?q=old%20wife%20young

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.50 ms
(84.37%)
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
  168297
  252068
  306275
  383436
  390497
  391949
  392729
  395176
  395667
  395717
  396313
  396734
  397208
  397410
  398201
  398548
  400817
  400819
  407700
  407851
  407887
  411449
  412554
  414317
  421435
  421561
  424023
  426007
  428475
  444258
  449901
  456966
  460138
  460723
  461973
  467336
  470785
  473252
  473322
  476155
  476237
  477958
  477986
  479134
  486215
  511724
  515249
  518316
  520721
  522482
  524023
  538431
  543694
  549575
  549933
  550617
  551157
  555911
  556408
  558607
  561586
  562064
  565703
  566224
  566504
  571150
  579488
  584395
  598492
  604467
  605460
  610174
  610657
  615622
  620576
  620791
  622622
  627171
  650818
  663489
  664793
  664801
  664808
  665224
  665871
  667833
  680745
  683906
  683955
  684200
  694154
  702740
  716753
  720816
  722050
  726556
  727748
  729743
  731000
  739479
  748159
  750205
  753134
  755780
  759420
  762999
  765763
  784925
  785066
  788948
  789213
  789233
  789424
  799791
  803144
  804894
  805442
  823269
  825260
  827861
]
15.09 ms
(9.47%)
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
  627171
  424023
  470785
  477958
  467336
  252068
  400819
  444258
  306275
  473252
  477986
  522482
  615622
  785066
  664793
  667833
  473322
  825260
  827861
  543694
  551157
  561586
  550617
  788948
  726556
  750205
  397410
  664808
  555911
  620791
  620576
  789233
  789424
  755780
  762999
  729743
  395717
  396734
  428475
  720816
  598492
  610657
  731000
  727748
  739479
  753134
  407700
  518316
  398548
  383436
  392729
  397208
  456966
  566224
  400817
  479134
  391949
  716753
  168297
  565703
  665871
  665224
  549575
  604467
  486215
  511724
  515249
  520721
  680745
  663489
  421561
  476237
  605460
  579488
  664801
  702740
  549933
  566504
  571150
  610174
  622622
  799791
  803144
  804894
  784925
  748159
  765763
  722050
  461973
  449901
  476155
  538431
  524023
  395176
  407851
  823269
  556408
  789213
  805442
  759420
  407887
  395667
  460138
  390497
  396313
  398201
  411449
  414317
  421435
  426007
  412554
  460723
  562064
  584395
  650818
  684200
  683906
  683955
  694154
  558607
]
3.13 ms
(1.96%)
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
  168297
  252068
  306275
  383436
  390497
  391949
  392729
  395176
  395667
  395717
  396313
  396734
  397208
  397410
  398201
  398548
  400817
  400819
  407700
  407851
  407887
  411449
  412554
  414317
  421435
  421561
  424023
  426007
  428475
  444258
  449901
  456966
  460138
  460723
  461973
  467336
  470785
  473252
  473322
  476155
  476237
  477958
  477986
  479134
  486215
  511724
  515249
  518316
  520721
  522482
  524023
  538431
  543694
  549575
  549933
  550617
  551157
  555911
  556408
  558607
  561586
  562064
  565703
  566224
  566504
  571150
  579488
  584395
  598492
  604467
  605460
  610174
  610657
  615622
  620576
  620791
  622622
  627171
  650818
  663489
  664793
  664801
  664808
  665224
  665871
  667833
  680745
  683906
  683955
  684200
  694154
  702740
  716753
  720816
  722050
  726556
  727748
  729743
  731000
  739479
  748159
  750205
  753134
  755780
  759420
  762999
  765763
  784925
  785066
  788948
  789213
  789233
  789424
  799791
  803144
  804894
  805442
  823269
  825260
  827861
]
2.05 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "old wife young"
]
1.68 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "old жен young"
]
1.35 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "old жен young"
]

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.