GET https://search.jues.net/search/embeds/4?q=close%20up%20young

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.73 ms
(49.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "close up young"
]
192.14 ms
(45.66%)
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
  392461
  396251
  410150
  411125
  414944
  415092
  418648
  418653
  420374
  420600
  422925
  426007
  427221
  429147
  435468
  464648
  484822
  491067
  497337
  504669
  511691
  529566
  540736
  543734
  544873
  548300
  549582
  550691
  561007
  566511
  567240
  569962
  574964
  590346
  597820
  598725
  599791
  600287
  600455
  614201
  617128
  617835
  622880
  623519
  624592
  631280
  640320
  640427
  642908
  649191
  651977
  663434
  666654
  671229
  677258
  677337
  679579
  680633
  682691
  683011
  683247
  687929
  690000
  691326
  693028
  693873
  695840
  696126
  697976
  698091
  705320
  708432
  711639
  712955
  713701
  715144
  718614
  724186
  724519
  725532
  727631
  730204
  731404
  732086
  735709
  737408
  740618
  740738
  741268
  742434
  747966
  749028
  750127
  757105
  757182
  758615
  759317
  760335
  760547
  761161
  766670
  771903
  778303
  781099
  783530
  785291
  789526
  794978
  796532
  798533
  806680
  808116
  811533
  817746
  819444
  823049
  825140
  827474
]
12.55 ms
(2.98%)
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
  698091
  708432
  712955
  718614
  677337
  682691
  695840
  640320
  598725
  614201
  617128
  622880
  590346
  597820
  811533
  796532
  798533
  806680
  741268
  749028
  760335
  772553
  783530
  750127
  759317
  766670
  740618
  757182
  760547
  725532
  735709
  761161
  773406
  724519
  731404
  740738
  771903
  631280
  711639
  392461
  411125
  414944
  410150
  426007
  429147
  427221
  418653
  504669
  529566
  549582
  561007
  569962
  649191
  680633
  713701
  687929
  705320
  683247
  548300
  566511
  599791
  794978
  730204
  737408
  757105
  785291
  789526
  808116
  724186
  732086
  727631
  747966
  742434
  758615
  623519
  640427
  396251
  418648
  422925
  420374
  435468
  420600
  484822
  491067
  511691
  696126
  497337
  415092
  817746
  819444
  823049
  825140
  827474
  464648
  540736
  544873
  550691
  543734
  574964
  651977
  679579
  683011
  691326
  693873
  666654
  671229
  715144
  663434
  677258
  690000
  693028
  697976
  567240
  600455
  642908
  600287
  617835
  624592
  781099
  778303
]
3.02 ms
(0.72%)
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
  392461
  396251
  410150
  411125
  414944
  415092
  418648
  418653
  420374
  420600
  422925
  426007
  427221
  429147
  435468
  464648
  484822
  491067
  497337
  504669
  511691
  529566
  540736
  543734
  544873
  548300
  549582
  550691
  561007
  566511
  567240
  569962
  574964
  590346
  597820
  598725
  599791
  600287
  600455
  614201
  617128
  617835
  622880
  623519
  624592
  631280
  640320
  640427
  642908
  649191
  651977
  663434
  666654
  671229
  677258
  677337
  679579
  680633
  682691
  683011
  683247
  687929
  690000
  691326
  693028
  693873
  695840
  696126
  697976
  698091
  705320
  708432
  711639
  712955
  713701
  715144
  718614
  724186
  724519
  725532
  727631
  730204
  731404
  732086
  735709
  737408
  740618
  740738
  741268
  742434
  747966
  749028
  750127
  757105
  757182
  758615
  759317
  760335
  760547
  761161
  766670
  771903
  778303
  781099
  783530
  785291
  789526
  794978
  796532
  798533
  806680
  808116
  811533
  817746
  819444
  823049
  825140
  827474
]
1.93 ms
(0.46%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(0.42%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "close up young"
]
1.68 ms
(0.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "close up 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.