Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
149.91 ms
(87.16%)
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
  294
  118885
  147280
  191406
  198253
  205443
  367863
  383225
  383350
  383493
  386569
  387631
  388118
  395438
  397173
  397176
  398523
  401450
  420450
  467847
  472498
  481069
  495885
  496324
  497813
  503911
  506238
  520148
  528295
  529661
  530356
  530398
  533033
  534975
  535780
  536756
  537785
  538731
  538858
  540081
  540088
  540103
  540129
  540158
  540669
  811896
  813704
  813819
  814441
  815891
  815942
  815993
  816297
  816608
  816854
  817107
  817324
  817353
  817525
  817804
  817939
  818028
  818066
  819031
  819284
  820169
  820558
  820982
  821002
  821003
  821029
  821061
  821110
  821199
  821367
  821547
  821600
  821601
  821785
  822313
  822610
  822677
  823009
  823036
  823093
  823190
  823375
  823437
  823633
  823771
  823774
  823823
  823906
  823991
  823994
  824112
  824288
  824596
  825194
  825246
  825295
  825335
  825367
  825658
  825800
  826630
  826856
  826892
  827383
  827440
  827630
  827730
  827831
  828449
  828481
  828587
  828799
]
12.61 ms
(7.33%)
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
  811896
  118885
  387631
  383225
  198253
  205443
  367863
  395438
  401450
  467847
  398523
  495885
  503911
  386569
  383493
  383350
  147280
  191406
  294
  388118
  397176
  397173
  420450
  817353
  820169
  821600
  822610
  823036
  823774
  825295
  826630
  825335
  814441
  815891
  816608
  817107
  817804
  817939
  820982
  821003
  821029
  821547
  822677
  823683
  825194
  826856
  826892
  827383
  827440
  827630
  827730
  816297
  818028
  818066
  819031
  821199
  821367
  822313
  823093
  823437
  823492
  823771
  823823
  823991
  824112
  824288
  824596
  825658
  813704
  813819
  815942
  815993
  816854
  817324
  817525
  819284
  820558
  821002
  821061
  821110
  821601
  821785
  823009
  823190
  823375
  823633
  823906
  823994
  825195
  825246
  825367
  825800
  827831
  828799
  828587
  828481
  828449
  520148
  529661
  530398
  533033
  537785
  538731
  540158
  530356
  538858
  540669
  496324
  497813
  506238
  534975
  536756
  540081
  540088
  540103
  540129
  528295
  535780
  472498
  481069
]
2.87 ms
(1.67%)
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
  294
  118885
  147280
  191406
  198253
  205443
  367863
  383225
  383350
  383493
  386569
  387631
  388118
  395438
  397173
  397176
  398523
  401450
  420450
  467847
  472498
  481069
  495885
  496324
  497813
  503911
  506238
  520148
  528295
  529661
  530356
  530398
  533033
  534975
  535780
  536756
  537785
  538731
  538858
  540081
  540088
  540103
  540129
  540158
  540669
  811896
  813704
  813819
  814441
  815891
  815942
  815993
  816297
  816608
  816854
  817107
  817324
  817353
  817525
  817804
  817939
  818028
  818066
  819031
  819284
  820169
  820558
  820982
  821002
  821003
  821029
  821061
  821110
  821199
  821367
  821547
  821600
  821601
  821785
  822313
  822610
  822677
  823009
  823036
  823093
  823190
  823375
  823437
  823633
  823771
  823774
  823823
  823906
  823991
  823994
  824112
  824288
  824596
  825194
  825246
  825295
  825335
  825367
  825658
  825800
  826630
  826856
  826892
  827383
  827440
  827630
  827730
  827831
  828449
  828481
  828587
  828799
]
1.94 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "ван ван"
]
1.68 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "душ в ванной"
]
1.60 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.39 ms
(0.81%)
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.