Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.32 ms
(82.29%)
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
  61051
  386156
  414259
  414675
  415294
  415855
  415961
  415981
  415992
  416508
  416511
  416515
  416525
  416536
  416580
  416600
  416609
  416616
  416621
  416624
  416626
  416639
  416648
  416653
  416670
  416683
  416696
  416712
  416715
  416722
  419200
  420615
  423783
  425398
  426284
  426301
  428174
  429523
  429844
  430261
  430355
  432274
  432466
  436230
  437084
  437859
  437863
  441032
  441095
  441354
  443236
  444888
  444921
  446797
  452781
  459198
  467097
  467588
  468949
  469615
  475405
  476059
  477761
  478993
  482280
  483705
  483730
  484286
  487418
  491860
  493687
  493696
  493825
  493839
  494493
  498319
  498346
  500256
  500338
  505139
  505386
  509429
  511893
  515490
  518548
  520786
  531351
  540032
  540990
  541409
  545369
  545379
  545426
  564237
  577468
  582802
  583377
  583593
  602024
  604338
  614966
  619659
  624168
  630081
  636958
  666355
  676808
  709128
  709917
  750121
  751424
  752706
  770405
  776059
  779840
  785614
  798291
  799937
  800442
  814443
]
15.14 ms
(10.35%)
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
  436230
  416609
  416624
  416653
  441095
  432274
  437863
  443236
  414675
  415992
  416515
  416536
  416580
  416621
  416639
  416648
  416670
  416712
  416715
  416525
  441032
  416696
  441354
  814443
  476059
  478993
  482280
  475405
  483705
  484286
  491860
  468949
  483730
  493825
  494493
  500256
  515490
  540032
  500338
  505139
  505386
  511893
  487418
  540990
  541409
  545379
  564237
  582802
  545369
  583377
  709917
  666355
  676808
  545426
  577468
  583593
  602024
  614966
  619659
  624168
  604338
  636958
  776059
  779840
  785614
  799937
  800442
  770405
  750121
  752706
  751424
  630081
  709128
  798291
  61051
  414259
  416508
  430355
  432466
  437859
  467097
  415294
  416511
  416600
  416616
  420615
  426301
  467588
  386156
  430261
  444888
  477761
  415961
  415981
  416683
  416722
  426284
  459198
  469615
  518548
  493696
  493839
  498346
  509429
  520786
  493687
  498319
  452781
  423783
  531351
  415855
  425398
  416626
  419200
  444921
  429523
  429844
  428174
  437084
  446797
]
3.27 ms
(2.24%)
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
  61051
  386156
  414259
  414675
  415294
  415855
  415961
  415981
  415992
  416508
  416511
  416515
  416525
  416536
  416580
  416600
  416609
  416616
  416621
  416624
  416626
  416639
  416648
  416653
  416670
  416683
  416696
  416712
  416715
  416722
  419200
  420615
  423783
  425398
  426284
  426301
  428174
  429523
  429844
  430261
  430355
  432274
  432466
  436230
  437084
  437859
  437863
  441032
  441095
  441354
  443236
  444888
  444921
  446797
  452781
  459198
  467097
  467588
  468949
  469615
  475405
  476059
  477761
  478993
  482280
  483705
  483730
  484286
  487418
  491860
  493687
  493696
  493825
  493839
  494493
  498319
  498346
  500256
  500338
  505139
  505386
  509429
  511893
  515490
  518548
  520786
  531351
  540032
  540990
  541409
  545369
  545379
  545426
  564237
  577468
  582802
  583377
  583593
  602024
  604338
  614966
  619659
  624168
  630081
  636958
  666355
  676808
  709128
  709917
  750121
  751424
  752706
  770405
  776059
  779840
  785614
  798291
  799937
  800442
  814443
]
2.51 ms
(1.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "webcam teen huge"
]
1.71 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.69 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вебкамер teen огромные"
]
1.58 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "вебкамер teen огромные"
]

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.