GET https://search.jues.net/search/embeds/5?q=red%20mature

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.64 ms
(83.01%)
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
  213429
  229555
  397629
  398227
  398547
  400861
  401899
  406567
  407177
  407483
  411690
  411967
  439724
  440938
  442066
  442814
  443199
  444000
  454563
  457450
  467055
  467255
  468877
  472891
  473249
  474635
  474680
  475874
  476234
  479097
  479099
  479105
  482345
  484203
  490885
  490907
  491906
  491988
  493104
  499482
  505640
  505652
  511391
  516473
  519811
  520211
  531418
  531535
  532043
  534733
  535348
  535587
  537848
  544496
  547007
  548389
  555094
  563009
  564813
  565119
  565275
  569266
  586527
  599792
  601975
  605245
  611365
  611507
  618601
  618784
  622410
  623982
  634858
  641684
  643011
  644706
  646946
  667579
  670372
  671043
  673651
  673656
  710511
  714409
  715394
  718910
  722301
  726474
  726547
  727751
  729228
  731757
  731777
  733587
  740553
  746045
  756003
  756407
  771484
  781697
  781812
  782232
  782253
  784358
  794360
  795060
  796945
  797785
  797969
  800671
  801917
  803486
  803563
  804207
  804218
  808063
  810355
  811478
  818206
  819271
]
14.86 ms
(10.31%)
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
  473249
  439724
  444000
  467055
  474635
  475874
  479097
  479099
  479105
  442814
  457450
  454563
  467255
  472891
  490885
  516473
  490907
  491988
  493104
  491906
  229555
  397629
  398547
  819271
  532043
  535348
  531418
  548389
  547007
  569266
  646946
  710511
  714409
  667579
  599792
  605245
  644706
  795060
  797969
  800671
  803563
  740553
  746045
  771484
  794360
  810355
  811478
  726474
  729228
  731757
  756003
  601975
  718910
  803486
  804218
  213429
  442066
  474680
  398227
  400861
  401899
  406567
  407483
  443199
  407177
  411690
  411967
  440938
  818206
  468877
  482345
  484203
  505640
  535587
  537848
  511391
  519811
  520211
  534733
  499482
  505652
  531535
  476234
  555094
  544496
  563009
  564813
  565119
  671043
  673651
  670372
  673656
  715394
  722301
  565275
  634858
  641684
  586527
  622410
  643011
  611365
  611507
  618784
  618601
  623982
  781697
  781812
  784358
  796945
  808063
  782253
  782232
  797785
  801917
  804207
  726547
  731777
  756407
  733587
  727751
]
2.95 ms
(2.05%)
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
  213429
  229555
  397629
  398227
  398547
  400861
  401899
  406567
  407177
  407483
  411690
  411967
  439724
  440938
  442066
  442814
  443199
  444000
  454563
  457450
  467055
  467255
  468877
  472891
  473249
  474635
  474680
  475874
  476234
  479097
  479099
  479105
  482345
  484203
  490885
  490907
  491906
  491988
  493104
  499482
  505640
  505652
  511391
  516473
  519811
  520211
  531418
  531535
  532043
  534733
  535348
  535587
  537848
  544496
  547007
  548389
  555094
  563009
  564813
  565119
  565275
  569266
  586527
  599792
  601975
  605245
  611365
  611507
  618601
  618784
  622410
  623982
  634858
  641684
  643011
  644706
  646946
  667579
  670372
  671043
  673651
  673656
  710511
  714409
  715394
  718910
  722301
  726474
  726547
  727751
  729228
  731757
  731777
  733587
  740553
  746045
  756003
  756407
  771484
  781697
  781812
  782232
  782253
  784358
  794360
  795060
  796945
  797785
  797969
  800671
  801917
  803486
  803563
  804207
  804218
  808063
  810355
  811478
  818206
  819271
]
2.04 ms
(1.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "red mature"
]
1.79 ms
(1.24%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "red mature"
]
1.31 ms
(0.91%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "red mature"
]

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.