GET https://search.jues.net/search/embeds/3?q=creampie%20public

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
210.11 ms
(48.16%)
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
  391600
  395224
  396360
  398360
  398622
  402458
  402866
  418005
  419196
  419269
  422348
  423531
  423963
  424010
  425474
  425485
  438042
  438056
  441156
  442631
  443617
  445611
  445747
  448089
  448177
  452976
  453092
  455522
  458013
  458635
  459378
  462070
  465097
  468385
  469715
  470350
  472090
  473007
  473320
  474884
  476489
  477205
  477590
  477742
  477790
  478223
  480178
  484458
  487599
  487862
  491888
  492559
  495459
  497201
  502975
  507103
  509548
  509825
  510497
  510937
  512987
  514447
  515899
  515901
  526155
  526585
  527223
  527598
  528437
  529995
  531062
  533840
  534926
  537943
  538768
  540211
  542144
  543275
  549026
  549513
  552955
  553227
  555485
  563892
  563969
  569033
  569153
  570764
  580217
  580930
  582944
  583984
  586178
  599788
  607698
  617089
  623949
  624839
  633209
  656495
  656533
  656537
  712549
  714779
  714884
  720421
  737588
  743782
  756276
  757808
  760912
  761466
  769013
  773614
  782376
  785204
  799864
  819104
  822232
]
200.22 ms
(45.89%)
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
  391600
  395224
  396360
  398360
  398622
  402458
  402866
  418005
  419196
  419269
  422348
  423531
  423963
  424010
  425474
  425485
  438042
  438056
  441156
  442631
  443617
  445611
  445747
  448089
  448177
  452976
  453092
  455522
  458013
  458635
  459378
  462070
  465097
  468385
  469715
  470350
  472090
  473007
  473320
  474884
  476489
  477205
  477590
  477742
  477790
  478223
  480178
  484458
  487599
  487862
  491888
  492559
  495459
  497201
  502975
  507103
  509548
  509825
  510497
  510937
  512987
  514447
  515899
  515901
  526155
  526585
  527223
  527598
  528437
  529995
  531062
  533840
  534926
  537943
  538768
  540211
  542144
  543275
  549026
  549513
  552955
  553227
  555485
  563892
  563969
  569033
  569153
  570764
  580217
  580930
  582944
  583984
  586178
  599788
  607698
  617089
  623949
  624839
  633209
  656495
  656533
  656537
  712549
  714779
  714884
  720421
  737588
  743782
  756276
  757808
  760912
  761466
  769013
  773614
  782376
  785204
  799864
  819104
  822232
]
17.96 ms
(4.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
  617089
  425474
  458635
  656533
  599788
  418005
  448177
  537943
  424010
  462070
  480178
  474884
  477205
  510937
  402866
  540211
  515899
  714884
  623949
  782376
  799864
  760912
  773614
  756276
  402458
  583984
  553227
  398360
  419269
  476489
  543275
  737588
  465097
  438056
  484458
  491888
  497201
  487862
  470350
  487599
  419196
  423963
  822232
  819104
  445611
  453092
  465188
  529995
  533840
  534926
  512987
  563969
  720421
  656537
  586178
  624839
  607698
  757808
  761466
  785204
  769013
  441156
  452976
  472090
  445747
  448089
  514447
  477742
  526155
  438042
  443617
  549026
  442631
  455522
  468385
  555485
  580930
  509825
  549513
  569153
  391600
  515901
  422348
  477590
  527223
  477790
  714779
  633209
  473007
  473320
  478223
  528437
  495459
  552955
  502975
  538768
  570764
  458013
  569033
  527598
  459378
  531062
  580217
  469715
  396360
  582944
  395224
  398622
  423531
  492559
  510497
  509548
  563892
  656495
  712549
  743782
  425485
  542144
  507103
  526585
]
2.35 ms
(0.54%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "creampie public"
]
2.28 ms
(0.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(0.42%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "creampie на улиц"
]
1.56 ms
(0.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "creampie на улиц"
]

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.