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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.45 ms
(82.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
  383387
  386016
  400461
  401840
  419382
  421536
  426518
  428672
  446481
  451570
  453066
  453082
  456859
  457290
  457332
  459159
  459161
  463229
  464491
  465905
  470532
  472358
  473245
  473362
  473364
  474538
  474566
  486390
  486699
  487999
  490843
  490868
  494687
  495402
  495608
  496298
  504964
  512823
  512830
  514704
  514733
  516313
  522395
  523293
  526185
  530312
  533320
  533340
  533628
  534789
  537848
  537969
  539106
  539112
  539116
  541891
  543260
  543606
  543756
  545408
  546857
  549859
  550846
  551055
  552251
  553916
  559200
  560083
  562367
  562371
  566347
  569021
  569202
  572736
  575787
  579138
  579372
  582476
  585124
  590188
  591329
  595735
  598452
  598515
  603270
  606566
  609954
  612402
  619457
  619822
  623231
  624789
  629886
  629892
  630024
  630755
  634468
  644310
  644800
  644968
  645247
  649935
  661250
  666381
  671739
  673358
  705686
  717676
  718968
  720050
  722544
  733172
  759658
  764491
  775834
  776339
  811040
  813520
  817928
  821532
]
22.97 ms
(11.93%)
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
  630024
  451570
  456859
  487999
  516313
  457290
  495402
  428672
  551055
  722544
  383387
  400461
  464491
  459161
  533628
  539106
  539112
  539116
  496298
  533340
  494687
  473362
  486699
  559200
  560083
  569021
  566347
  579138
  718968
  546857
  623231
  634468
  590188
  619822
  775834
  764491
  419382
  459159
  472358
  453082
  473245
  473364
  490843
  514704
  553916
  811040
  514733
  562367
  463229
  543606
  579372
  645247
  661250
  630755
  457332
  585124
  526185
  543756
  562371
  572736
  619457
  490868
  486390
  512823
  512830
  386016
  644800
  644968
  817928
  821532
  465905
  537848
  537969
  533320
  534789
  474538
  549859
  550846
  569202
  541891
  543260
  582476
  545408
  575787
  649935
  666381
  671739
  673358
  720050
  552251
  595735
  609954
  612402
  629892
  598452
  624789
  591329
  598515
  606566
  629886
  776339
  813520
  733172
  759658
  603270
  644310
  705686
  717676
  401840
  453066
  474566
  446481
  470532
  523293
  504964
  530312
  495608
  421536
  426518
  522395
]
3.05 ms
(1.58%)
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
  383387
  386016
  400461
  401840
  419382
  421536
  426518
  428672
  446481
  451570
  453066
  453082
  456859
  457290
  457332
  459159
  459161
  463229
  464491
  465905
  470532
  472358
  473245
  473362
  473364
  474538
  474566
  486390
  486699
  487999
  490843
  490868
  494687
  495402
  495608
  496298
  504964
  512823
  512830
  514704
  514733
  516313
  522395
  523293
  526185
  530312
  533320
  533340
  533628
  534789
  537848
  537969
  539106
  539112
  539116
  541891
  543260
  543606
  543756
  545408
  546857
  549859
  550846
  551055
  552251
  553916
  559200
  560083
  562367
  562371
  566347
  569021
  569202
  572736
  575787
  579138
  579372
  582476
  585124
  590188
  591329
  595735
  598452
  598515
  603270
  606566
  609954
  612402
  619457
  619822
  623231
  624789
  629886
  629892
  630024
  630755
  634468
  644310
  644800
  644968
  645247
  649935
  661250
  666381
  671739
  673358
  705686
  717676
  718968
  720050
  722544
  733172
  759658
  764491
  775834
  776339
  811040
  813520
  817928
  821532
]
2.24 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "на money улиц group"
]
2.13 ms
(1.11%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "public money group"
]
2.09 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "на money улиц group"
]
1.66 ms
(0.86%)
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.