GET https://search.jues.net/search/embeds/7?q=public%20money%20group

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.82 ms
(84.93%)
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
  391247
  395143
  396330
  401032
  412083
  417344
  417632
  419882
  420182
  428382
  428406
  436042
  444820
  446344
  447314
  447618
  449809
  451550
  451552
  451824
  452080
  452967
  453089
  455011
  455851
  455857
  457041
  457163
  457783
  457791
  460958
  461624
  463107
  470864
  471365
  472645
  473637
  474058
  474509
  474520
  474561
  476103
  478575
  479866
  482539
  482788
  482938
  484848
  486459
  487120
  490024
  493190
  497553
  497569
  498497
  499807
  500901
  505642
  515167
  516750
  519385
  519618
  522380
  522696
  522891
  522900
  525628
  526875
  527647
  529105
  529114
  530480
  530483
  532989
  533798
  534784
  540346
  540490
  542798
  543478
  544862
  546083
  546614
  546773
  550130
  550752
  551950
  559133
  559214
  560439
  563399
  566696
  568193
  569083
  570719
  575733
  579351
  580254
  591324
  595792
  595808
  598099
  604094
  606561
  619830
  621318
  628394
  629899
  633312
  637025
  644244
  647901
  660424
  677952
  682205
  702679
  705785
  706945
  715670
  792558
]
18.07 ms
(9.85%)
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
  447314
  428382
  519618
  395143
  472645
  451824
  457791
  540346
  505642
  529105
  487120
  551950
  559214
  566696
  569083
  575733
  595792
  619830
  621318
  417632
  474058
  451550
  460958
  490024
  529114
  500901
  606561
  471365
  412083
  478575
  486459
  452967
  463107
  522696
  533798
  499807
  522380
  470864
  482539
  559133
  542798
  570719
  579351
  546614
  560439
  568193
  706945
  546083
  546773
  580254
  591324
  629899
  702679
  457041
  479866
  391247
  455011
  401032
  428406
  451552
  526875
  484848
  522891
  515167
  563399
  598099
  498497
  474509
  474561
  457783
  527647
  525628
  519385
  497553
  544862
  550130
  633312
  417344
  436042
  419882
  497569
  482788
  447618
  453089
  455857
  493190
  446344
  449809
  455851
  474520
  522900
  530483
  532989
  534784
  516750
  530480
  540490
  473637
  482938
  543478
  550752
  647901
  705785
  715670
  660424
  677952
  682205
  604094
  628394
  637025
  595808
  644244
  792558
  396330
  444820
  420182
  461624
  452080
  476103
  457163
]
2.29 ms
(1.25%)
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
  391247
  395143
  396330
  401032
  412083
  417344
  417632
  419882
  420182
  428382
  428406
  436042
  444820
  446344
  447314
  447618
  449809
  451550
  451552
  451824
  452080
  452967
  453089
  455011
  455851
  455857
  457041
  457163
  457783
  457791
  460958
  461624
  463107
  470864
  471365
  472645
  473637
  474058
  474509
  474520
  474561
  476103
  478575
  479866
  482539
  482788
  482938
  484848
  486459
  487120
  490024
  493190
  497553
  497569
  498497
  499807
  500901
  505642
  515167
  516750
  519385
  519618
  522380
  522696
  522891
  522900
  525628
  526875
  527647
  529105
  529114
  530480
  530483
  532989
  533798
  534784
  540346
  540490
  542798
  543478
  544862
  546083
  546614
  546773
  550130
  550752
  551950
  559133
  559214
  560439
  563399
  566696
  568193
  569083
  570719
  575733
  579351
  580254
  591324
  595792
  595808
  598099
  604094
  606561
  619830
  621318
  628394
  629899
  633312
  637025
  644244
  647901
  660424
  677952
  682205
  702679
  705785
  706945
  715670
  792558
]
2.22 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public money group"
]
1.81 ms
(0.99%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(0.93%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на money улиц group"
]
1.54 ms
(0.84%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на money улиц group"
]

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.