GET https://search.jues.net/search/embeds/8?q=beauty%20asian

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.24 ms
(83.27%)
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
  394103
  413289
  418323
  418648
  419912
  420031
  421315
  422855
  423245
  424551
  425797
  425823
  430444
  431871
  443600
  457110
  457208
  457265
  457271
  471822
  485576
  487864
  491456
  508485
  508769
  511927
  512176
  512208
  515734
  517857
  519437
  519769
  523373
  524819
  529854
  530663
  534985
  538295
  539519
  539938
  540608
  544712
  550626
  550637
  550762
  550778
  552008
  552918
  554016
  556353
  558359
  558377
  559925
  562808
  564209
  565481
  566849
  567107
  567819
  567837
  573473
  574681
  577045
  577059
  583255
  583267
  586584
  586590
  591592
  596278
  596911
  598289
  600624
  619178
  622137
  632803
  636923
  639894
  642064
  646004
  672258
  675208
  704259
  708805
  710893
  713096
  724244
  727382
  740408
  741134
  741138
  744732
  744885
  751854
  752770
  756359
  758726
  759473
  760206
  763390
  771827
  771832
  776552
  788135
  793645
  800504
  801631
  803996
  804465
  808858
  810691
  812171
  816242
  817847
  817920
  820685
  820780
  821625
  822651
  827853
]
14.61 ms
(10.12%)
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
  544712
  619178
  810691
  740408
  744732
  741138
  756359
  708805
  817920
  672258
  803996
  804465
  515734
  554016
  430444
  512176
  550778
  583255
  567837
  512208
  519437
  423245
  424551
  529854
  530663
  539938
  540608
  534985
  556353
  559925
  646004
  565481
  642064
  586590
  598289
  418323
  443600
  457265
  419912
  517857
  519769
  485576
  508485
  508769
  816242
  675208
  636923
  808858
  776552
  800504
  771827
  771832
  822651
  820685
  817847
  821625
  827853
  539519
  550626
  577045
  552918
  704259
  713096
  710893
  577059
  622137
  632803
  639894
  727382
  741134
  744885
  758726
  760206
  788135
  751854
  763390
  724244
  752770
  793645
  801631
  812171
  413289
  421315
  431871
  820780
  491456
  487864
  511927
  523373
  538295
  562808
  567819
  574681
  550637
  558377
  550762
  552008
  566849
  583267
  558359
  564209
  567107
  573473
  586584
  591592
  600624
  596278
  596911
  759473
  418648
  425797
  457271
  394103
  425823
  420031
  422855
  471822
  457110
  457208
  524819
]
2.30 ms
(1.59%)
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
  394103
  413289
  418323
  418648
  419912
  420031
  421315
  422855
  423245
  424551
  425797
  425823
  430444
  431871
  443600
  457110
  457208
  457265
  457271
  471822
  485576
  487864
  491456
  508485
  508769
  511927
  512176
  512208
  515734
  517857
  519437
  519769
  523373
  524819
  529854
  530663
  534985
  538295
  539519
  539938
  540608
  544712
  550626
  550637
  550762
  550778
  552008
  552918
  554016
  556353
  558359
  558377
  559925
  562808
  564209
  565481
  566849
  567107
  567819
  567837
  573473
  574681
  577045
  577059
  583255
  583267
  586584
  586590
  591592
  596278
  596911
  598289
  600624
  619178
  622137
  632803
  636923
  639894
  642064
  646004
  672258
  675208
  704259
  708805
  710893
  713096
  724244
  727382
  740408
  741134
  741138
  744732
  744885
  751854
  752770
  756359
  758726
  759473
  760206
  763390
  771827
  771832
  776552
  788135
  793645
  800504
  801631
  803996
  804465
  808858
  810691
  812171
  816242
  817847
  817920
  820685
  820780
  821625
  822651
  827853
]
2.11 ms
(1.46%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "beauty asian"
]
2.02 ms
(1.40%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.68 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "beauty азиатк"
]
1.44 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "beauty азиатк"
]

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.