GET https://search.jues.net/search/embeds/4?q=way

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.12 ms
(81.63%)
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
  388869
  389798
  405897
  411967
  413503
  429630
  430400
  437086
  438756
  439038
  439456
  442058
  444803
  447232
  454793
  456965
  458472
  459875
  470265
  477448
  484269
  487454
  487674
  492723
  505501
  505656
  509880
  510006
  511798
  512922
  513746
  515607
  527763
  538300
  540428
  542921
  549081
  552345
  557660
  558059
  558236
  558295
  560252
  560588
  564361
  565045
  569994
  571351
  573788
  575207
  578185
  579192
  580823
  585286
  587054
  588712
  591091
  595671
  598535
  599139
  599240
  599418
  599496
  599527
  601829
  601893
  605465
  616100
  618841
  629315
  632082
  632656
  635880
  642389
  643424
  651923
  674413
  677098
  681271
  682912
  683247
  683660
  690683
  692604
  692654
  702835
  705516
  705537
  710534
  713630
  714442
  715221
  719197
  723277
  725711
  728191
  730390
  752790
  754111
  759541
  770269
  772565
  772832
  780868
  781178
  781961
  783481
  788428
  794609
  796168
  800073
  801239
  801615
  805033
  805595
  807898
  809238
  811627
  812675
  818463
]
18.48 ms
(11.77%)
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
  710534
  677098
  692604
  692654
  705537
  714442
  719197
  558236
  605465
  629315
  585286
  598535
  599139
  599240
  599496
  601829
  618841
  635880
  591091
  599527
  587054
  588712
  632082
  796168
  801239
  780868
  788428
  794609
  809238
  772565
  772832
  800073
  805595
  811627
  725711
  728191
  759541
  752790
  770269
  730390
  754111
  616100
  705516
  715221
  781961
  801615
  438756
  439456
  459875
  442058
  456965
  470265
  388869
  444803
  458472
  429630
  509880
  512922
  538300
  505501
  513746
  487674
  492723
  389798
  405897
  439038
  430400
  411967
  413503
  437086
  818463
  447232
  454793
  484269
  540428
  505656
  515607
  511798
  510006
  527763
  477448
  487454
  557660
  558059
  560252
  560588
  571351
  558295
  565045
  578185
  542921
  549081
  564361
  573788
  575207
  690683
  681271
  683660
  702835
  651923
  674413
  682912
  683247
  713630
  723277
  552345
  569994
  579192
  580823
  599418
  595671
  601893
  632656
  642389
  643424
  783481
  805033
  812675
  781178
  807898
]
2.88 ms
(1.83%)
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
  388869
  389798
  405897
  411967
  413503
  429630
  430400
  437086
  438756
  439038
  439456
  442058
  444803
  447232
  454793
  456965
  458472
  459875
  470265
  477448
  484269
  487454
  487674
  492723
  505501
  505656
  509880
  510006
  511798
  512922
  513746
  515607
  527763
  538300
  540428
  542921
  549081
  552345
  557660
  558059
  558236
  558295
  560252
  560588
  564361
  565045
  569994
  571351
  573788
  575207
  578185
  579192
  580823
  585286
  587054
  588712
  591091
  595671
  598535
  599139
  599240
  599418
  599496
  599527
  601829
  601893
  605465
  616100
  618841
  629315
  632082
  632656
  635880
  642389
  643424
  651923
  674413
  677098
  681271
  682912
  683247
  683660
  690683
  692604
  692654
  702835
  705516
  705537
  710534
  713630
  714442
  715221
  719197
  723277
  725711
  728191
  730390
  752790
  754111
  759541
  770269
  772565
  772832
  780868
  781178
  781961
  783481
  788428
  794609
  796168
  800073
  801239
  801615
  805033
  805595
  807898
  809238
  811627
  812675
  818463
]
2.06 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "way"
]
1.83 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "way"
]
1.83 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "way"
]
1.76 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.