Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.78 ms
(58.36%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
133.20 ms
(37.06%)
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
  484063
  496324
  497792
  507123
  528295
  531858
  532100
  533266
  534963
  535744
  536306
  543282
  543656
  544135
  544175
  544239
  546137
  546142
  547041
  547046
  548081
  549896
  550655
  550659
  553439
  560121
  561511
  565670
  567553
  567962
  577268
  582900
  584026
  584177
  587759
  591474
  591576
  599809
  606875
  614360
  626807
  627343
  631865
  635182
  643292
  649476
  654648
  663911
  664518
  664547
  667397
  667896
  695379
  714220
  714228
  718444
  733318
  734255
  740111
  742574
  776419
  781806
  781821
  781934
  781949
  784902
  788317
  793624
  796325
  803322
  804430
  804579
  804717
  806309
  808499
  808656
  817548
  818692
  818761
  818792
  819428
  819437
  819641
  823446
  823737
  824136
  824350
  825166
  825363
  825398
  825438
  825978
  826236
  826281
  826289
  826370
  826388
  826438
  826440
  826481
  826497
  826603
  826641
  826712
  826886
  827208
  827399
  827630
  828037
  828039
  828234
  828422
  828712
  828714
  828799
]
8.98 ms
(2.50%)
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
  826481
  826497
  826388
  826603
  825398
  826641
  818692
  818761
  823737
  824136
  825978
  826390
  826440
  826289
  826886
  827208
  827630
  827399
  817548
  818792
  819641
  823446
  824282
  825166
  825363
  826236
  826281
  826438
  819428
  819437
  824009
  824350
  824597
  825438
  826370
  826712
  828037
  828234
  828422
  828117
  828039
  828799
  828714
  828712
  497792
  533266
  532100
  536306
  496324
  507123
  534963
  528295
  531858
  535744
  484063
  543656
  544135
  544239
  550655
  560121
  561511
  565670
  567962
  577268
  584177
  543282
  544175
  546137
  550659
  553439
  584026
  547041
  567553
  582900
  663911
  649476
  654648
  664547
  695379
  718444
  664518
  667397
  667896
  714220
  714228
  546142
  547046
  548081
  549896
  606875
  587759
  599809
  626807
  627343
  631865
  591474
  635182
  643292
  591576
  614360
  776419
  781821
  781934
  781949
  784902
  803322
  804430
  808499
  781806
  788317
  793624
  796325
  804579
  804717
  806309
  808656
  733318
  734255
  740111
  742574
]
2.52 ms
(0.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
  484063
  496324
  497792
  507123
  528295
  531858
  532100
  533266
  534963
  535744
  536306
  543282
  543656
  544135
  544175
  544239
  546137
  546142
  547041
  547046
  548081
  549896
  550655
  550659
  553439
  560121
  561511
  565670
  567553
  567962
  577268
  582900
  584026
  584177
  587759
  591474
  591576
  599809
  606875
  614360
  626807
  627343
  631865
  635182
  643292
  649476
  654648
  663911
  664518
  664547
  667397
  667896
  695379
  714220
  714228
  718444
  733318
  734255
  740111
  742574
  776419
  781806
  781821
  781934
  781949
  784902
  788317
  793624
  796325
  803322
  804430
  804579
  804717
  806309
  808499
  808656
  817548
  818692
  818761
  818792
  819428
  819437
  819641
  823446
  823737
  824136
  824350
  825166
  825363
  825398
  825438
  825978
  826236
  826281
  826289
  826370
  826388
  826438
  826440
  826481
  826497
  826603
  826641
  826712
  826886
  827208
  827399
  827630
  828037
  828039
  828234
  828422
  828712
  828714
  828799
]
1.99 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "chubby big boobs"
]
1.54 ms
(0.43%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "chubby большие boobs"
]
1.44 ms
(0.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "chubby большие boobs"
]

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.