Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.32 ms
(84.56%)
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
  403081
  425569
  430446
  434044
  442198
  448861
  452234
  452249
  457645
  458838
  460600
  465661
  466209
  466954
  468647
  472658
  473505
  477493
  479682
  481470
  482780
  482795
  488772
  496074
  516421
  521287
  524928
  530716
  531193
  532797
  532958
  533855
  534961
  536291
  536309
  536318
  536550
  536576
  537195
  537886
  542203
  544753
  550360
  557747
  563827
  565270
  566065
  567843
  597858
  598344
  599255
  599894
  599916
  599928
  599958
  600004
  600009
  600017
  600339
  600344
  603178
  603643
  604304
  604310
  604558
  610343
  618964
  619480
  623978
  625289
  631199
  632970
  636316
  639710
  640602
  640795
  644257
  647950
  649583
  650470
  662604
  666585
  670293
  673035
  690323
  709261
  714256
  716857
  718979
  720291
  721728
  723098
  724216
  724261
  726667
  726677
  727282
  728288
  733539
  733603
  734488
  737076
  737085
  741309
  742428
  743040
  743817
  745435
  748236
  756200
  756243
  760032
  769401
  775940
  775943
  788566
  795537
  802959
  807417
  818439
]
13.22 ms
(9.14%)
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
  775943
  807417
  741309
  795537
  734488
  737076
  726677
  756200
  724261
  733603
  726667
  727282
  733539
  769401
  618964
  640602
  723098
  775940
  802959
  567843
  599255
  619480
  603643
  521287
  482795
  466209
  425569
  434044
  818439
  452234
  457645
  466954
  468647
  458838
  460600
  482780
  530716
  531193
  532797
  532958
  536291
  536318
  536576
  537195
  533855
  536550
  516421
  534961
  537886
  563827
  566065
  544753
  565270
  647950
  650470
  673035
  649583
  666585
  716857
  662604
  670293
  690323
  718979
  721728
  598344
  599894
  599958
  603178
  640795
  644257
  600004
  604558
  599916
  599928
  600339
  600344
  610343
  632970
  636316
  600009
  600017
  604304
  604310
  623978
  631199
  639710
  788566
  756243
  742428
  748236
  760032
  724216
  720291
  442198
  465661
  472658
  524928
  403081
  550360
  625289
  479682
  536309
  542203
  709261
  557747
  597858
  743040
  737085
  743817
  745435
  714256
  477493
  452249
  728288
  448861
  430446
  496074
  488772
  473505
  481470
]
2.27 ms
(1.57%)
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
  403081
  425569
  430446
  434044
  442198
  448861
  452234
  452249
  457645
  458838
  460600
  465661
  466209
  466954
  468647
  472658
  473505
  477493
  479682
  481470
  482780
  482795
  488772
  496074
  516421
  521287
  524928
  530716
  531193
  532797
  532958
  533855
  534961
  536291
  536309
  536318
  536550
  536576
  537195
  537886
  542203
  544753
  550360
  557747
  563827
  565270
  566065
  567843
  597858
  598344
  599255
  599894
  599916
  599928
  599958
  600004
  600009
  600017
  600339
  600344
  603178
  603643
  604304
  604310
  604558
  610343
  618964
  619480
  623978
  625289
  631199
  632970
  636316
  639710
  640602
  640795
  644257
  647950
  649583
  650470
  662604
  666585
  670293
  673035
  690323
  709261
  714256
  716857
  718979
  720291
  721728
  723098
  724216
  724261
  726667
  726677
  727282
  728288
  733539
  733603
  734488
  737076
  737085
  741309
  742428
  743040
  743817
  745435
  748236
  756200
  756243
  760032
  769401
  775940
  775943
  788566
  795537
  802959
  807417
  818439
]
1.96 ms
(1.35%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "зрелые женщины кастинги"
]
1.82 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "зрелая женщин кастинг"
]
1.57 ms
(1.09%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.