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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
124.10 ms
(83.92%)
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
  6741
  395826
  395856
  395981
  401305
  404939
  405809
  409901
  411069
  421537
  424023
  431498
  444142
  444414
  447920
  453624
  454272
  456063
  462506
  466023
  473139
  477020
  477409
  502717
  504764
  511889
  515202
  518566
  520003
  523680
  527116
  530578
  542942
  552534
  554068
  555530
  561897
  562114
  566886
  568440
  574089
  576043
  580276
  581206
  583210
  584666
  587431
  587532
  593172
  593900
  594095
  594261
  595127
  595654
  599011
  605329
  605841
  606258
  607086
  609712
  615622
  616481
  617603
  622509
  623413
  624487
  624508
  628289
  663414
  672744
  675424
  692337
  693341
  693457
  694116
  702320
  707881
  714822
  715077
  716675
  718889
  719143
  720821
  721120
  721496
  723932
  732775
  733295
  736866
  740489
  743009
  747954
  753548
  753677
  756521
  756567
  758465
  761862
  762559
  770444
  775284
  775630
  786715
  787616
  787950
  789870
  790101
  790391
  797247
  800275
  800377
  801272
  801305
  803144
  803244
  803261
  805257
  807183
  807663
  823300
]
14.86 ms
(10.05%)
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
  523680
  542942
  562114
  568440
  566886
  581206
  583210
  584666
  552534
  554068
  693341
  707881
  714822
  675424
  720821
  617603
  606258
  609712
  624508
  587532
  599011
  587431
  595654
  775630
  789870
  786715
  790101
  801305
  803144
  803261
  770444
  787950
  797247
  800377
  736866
  740489
  723932
  732775
  743009
  753548
  758465
  761862
  762559
  753677
  747954
  702320
  715077
  775284
  800275
  803244
  805257
  807663
  424023
  477409
  405809
  454272
  456063
  462506
  444142
  444414
  453624
  502717
  530578
  473139
  6741
  515202
  607086
  594261
  787616
  431498
  623413
  504764
  511889
  580276
  672744
  692337
  716675
  616481
  605841
  615622
  622509
  593172
  593900
  594095
  733295
  624487
  628289
  411069
  409901
  823300
  718889
  694116
  721496
  663414
  693457
  721120
  605329
  801272
  790391
  807183
  756521
  756567
  719143
  466023
  395826
  401305
  404939
  421537
  447920
  576043
  395981
  395856
  518566
  520003
  477020
  555530
  595127
  527116
  561897
  574089
]
2.40 ms
(1.63%)
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
  6741
  395826
  395856
  395981
  401305
  404939
  405809
  409901
  411069
  421537
  424023
  431498
  444142
  444414
  447920
  453624
  454272
  456063
  462506
  466023
  473139
  477020
  477409
  502717
  504764
  511889
  515202
  518566
  520003
  523680
  527116
  530578
  542942
  552534
  554068
  555530
  561897
  562114
  566886
  568440
  574089
  576043
  580276
  581206
  583210
  584666
  587431
  587532
  593172
  593900
  594095
  594261
  595127
  595654
  599011
  605329
  605841
  606258
  607086
  609712
  615622
  616481
  617603
  622509
  623413
  624487
  624508
  628289
  663414
  672744
  675424
  692337
  693341
  693457
  694116
  702320
  707881
  714822
  715077
  716675
  718889
  719143
  720821
  721120
  721496
  723932
  732775
  733295
  736866
  740489
  743009
  747954
  753548
  753677
  756521
  756567
  758465
  761862
  762559
  770444
  775284
  775630
  786715
  787616
  787950
  789870
  790101
  790391
  797247
  800275
  800377
  801272
  801305
  803144
  803244
  803261
  805257
  807183
  807663
  823300
]
1.84 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur old man"
]
1.68 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск old мужчин"
]
1.53 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.46 ms
(0.99%)
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.