Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
171.58 ms
(87.18%)
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
  992
  91891
  96445
  114631
  391715
  395867
  396609
  397366
  400237
  402835
  403834
  404922
  409995
  413185
  414038
  421839
  425466
  425832
  426031
  426117
  430324
  433966
  436040
  439226
  445575
  445608
  447142
  447861
  447928
  448038
  448097
  470791
  475975
  475989
  478463
  478779
  478787
  479523
  481149
  481339
  484161
  484609
  486694
  490035
  492338
  499588
  504268
  512261
  512265
  514738
  516449
  524121
  528181
  535585
  538190
  542502
  543609
  544268
  544640
  545584
  547300
  549412
  550432
  550681
  550741
  551262
  559384
  559867
  559878
  560616
  562765
  565369
  569672
  573263
  576343
  583608
  587267
  587723
  590860
  600005
  603206
  603548
  619168
  620616
  624998
  641757
  644321
  644538
  649138
  650593
  651317
  655720
  656028
  657426
  658669
  668996
  672466
  673555
  676530
  676945
  678541
  692172
  703391
  720883
  722836
  724709
  736663
  742199
  745663
  746889
  749465
  770856
  788717
  795148
  797574
  799754
  821157
  821163
  822953
  825628
]
15.32 ms
(7.78%)
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
  478779
  492338
  447861
  478463
  551262
  583608
  475989
  436040
  479523
  470791
  538190
  528181
  395867
  481149
  992
  545584
  565369
  651317
  676530
  624998
  414038
  486694
  543609
  544640
  569672
  720883
  439226
  475975
  397366
  400237
  402835
  409995
  512261
  512265
  722836
  96445
  821163
  547300
  649138
  650593
  692172
  678541
  559878
  724709
  749465
  799754
  788717
  403834
  549412
  447142
  484161
  490035
  448038
  448097
  560616
  550432
  590860
  426117
  404922
  425466
  433966
  478787
  484609
  516449
  562765
  91891
  822953
  559867
  559384
  676945
  672466
  795148
  770856
  821157
  825628
  544268
  655720
  656028
  673555
  657426
  658669
  587723
  600005
  425832
  430324
  445608
  481339
  573263
  587267
  413185
  504268
  742199
  445575
  703391
  576343
  499588
  535585
  668996
  524121
  644538
  603206
  447928
  619168
  114631
  550681
  644321
  797574
  514738
  542502
  603548
  620616
  746889
  391715
  396609
  421839
  550741
  641757
  736663
  745663
  426031
]
3.34 ms
(1.70%)
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
  992
  91891
  96445
  114631
  391715
  395867
  396609
  397366
  400237
  402835
  403834
  404922
  409995
  413185
  414038
  421839
  425466
  425832
  426031
  426117
  430324
  433966
  436040
  439226
  445575
  445608
  447142
  447861
  447928
  448038
  448097
  470791
  475975
  475989
  478463
  478779
  478787
  479523
  481149
  481339
  484161
  484609
  486694
  490035
  492338
  499588
  504268
  512261
  512265
  514738
  516449
  524121
  528181
  535585
  538190
  542502
  543609
  544268
  544640
  545584
  547300
  549412
  550432
  550681
  550741
  551262
  559384
  559867
  559878
  560616
  562765
  565369
  569672
  573263
  576343
  583608
  587267
  587723
  590860
  600005
  603206
  603548
  619168
  620616
  624998
  641757
  644321
  644538
  649138
  650593
  651317
  655720
  656028
  657426
  658669
  668996
  672466
  673555
  676530
  676945
  678541
  692172
  703391
  720883
  722836
  724709
  736663
  742199
  745663
  746889
  749465
  770856
  788717
  795148
  797574
  799754
  821157
  821163
  822953
  825628
]
1.83 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "худая втроём"
]
1.67 ms
(0.85%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "худая секс втро"
]
1.53 ms
(0.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.