GET https://search.jues.net/search/embeds/6?q=big%20load

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.33 ms
(80.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
  198179
  394548
  411471
  413464
  417126
  419147
  426862
  427355
  434889
  434908
  435477
  437443
  437450
  437790
  438060
  444080
  447140
  450567
  451144
  452463
  452756
  453058
  453061
  456797
  456940
  458427
  458526
  459002
  459346
  459381
  463562
  471326
  471772
  472843
  473393
  474910
  479874
  480806
  481670
  482850
  486742
  487552
  488297
  489259
  489260
  495444
  495965
  498076
  498435
  499341
  500692
  504423
  505320
  505550
  508521
  509288
  509293
  510478
  510704
  510834
  511235
  511356
  514966
  516666
  517169
  517384
  517998
  518093
  518317
  518802
  519120
  519124
  524344
  526882
  527978
  528814
  533030
  548643
  552333
  553101
  561657
  565393
  571322
  577632
  579631
  581988
  587995
  590200
  590286
  594525
  595794
  598020
  600320
  600558
  605396
  612581
  614073
  616376
  624787
  625582
  628823
  633689
  636434
  639051
  650177
  652945
  660606
  677064
  687190
  716072
  717173
  717606
  721728
  724209
  724636
  725458
  774563
  776731
  795216
  821036
]
19.52 ms
(13.01%)
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
  628823
  590286
  795216
  774563
  724636
  725458
  716072
  413464
  434908
  438060
  473393
  426862
  518317
  533030
  434889
  821036
  452756
  456797
  458526
  479874
  450567
  518802
  499341
  511356
  500692
  472843
  489259
  489260
  581988
  463562
  474910
  437450
  453058
  471326
  411471
  427355
  453061
  417126
  471772
  528814
  488297
  495965
  717173
  508521
  419147
  487552
  548643
  456940
  509293
  498435
  435477
  721728
  614073
  624787
  594525
  517998
  518093
  437790
  495444
  577632
  579631
  561657
  677064
  660606
  571322
  587995
  595794
  600320
  639051
  598020
  600558
  590200
  636434
  776731
  633689
  198179
  447140
  687190
  605396
  437443
  486742
  527978
  459346
  505550
  517169
  505320
  510478
  510834
  552333
  565393
  444080
  480806
  509288
  482850
  510704
  511235
  514966
  519120
  526882
  498076
  519124
  481670
  394548
  458427
  459381
  452463
  524344
  724209
  717606
  517384
  504423
  459002
  516666
  553101
  650177
  652945
  616376
  625582
  612581
  451144
]
2.24 ms
(1.50%)
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
  198179
  394548
  411471
  413464
  417126
  419147
  426862
  427355
  434889
  434908
  435477
  437443
  437450
  437790
  438060
  444080
  447140
  450567
  451144
  452463
  452756
  453058
  453061
  456797
  456940
  458427
  458526
  459002
  459346
  459381
  463562
  471326
  471772
  472843
  473393
  474910
  479874
  480806
  481670
  482850
  486742
  487552
  488297
  489259
  489260
  495444
  495965
  498076
  498435
  499341
  500692
  504423
  505320
  505550
  508521
  509288
  509293
  510478
  510704
  510834
  511235
  511356
  514966
  516666
  517169
  517384
  517998
  518093
  518317
  518802
  519120
  519124
  524344
  526882
  527978
  528814
  533030
  548643
  552333
  553101
  561657
  565393
  571322
  577632
  579631
  581988
  587995
  590200
  590286
  594525
  595794
  598020
  600320
  600558
  605396
  612581
  614073
  616376
  624787
  625582
  628823
  633689
  636434
  639051
  650177
  652945
  660606
  677064
  687190
  716072
  717173
  717606
  721728
  724209
  724636
  725458
  774563
  776731
  795216
  821036
]
1.93 ms
(1.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.88 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big load"
]
1.61 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие load"
]
1.49 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие load"
]

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.