Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.29 ms
(86.58%)
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
  410663
  413093
  415835
  420833
  422415
  431608
  443837
  473785
  474062
  474069
  474982
  481383
  481734
  482770
  486327
  487246
  489155
  490127
  499651
  501507
  502930
  504169
  511586
  522262
  533754
  533777
  533781
  533787
  535618
  540730
  543717
  546876
  550552
  552780
  574108
  578909
  588982
  590240
  590539
  594632
  601946
  603752
  610830
  611494
  612521
  613377
  621364
  623137
  624050
  624514
  626453
  627746
  652449
  653335
  656138
  659984
  664753
  685193
  687859
  699969
  703656
  703699
  703718
  703982
  705874
  730819
  733644
  756194
  756724
  757803
  763128
  768468
  768543
  771822
  777532
  779632
  779825
  780218
  782033
  782809
  783199
  783609
  783796
  786090
  786233
  787189
  787658
  787703
  788467
  790307
  790915
  791498
  791788
  791918
  792263
  793983
  795617
  798811
  801460
  804924
  805666
  809560
  809575
  809953
  811150
  818016
  818037
  819765
  819933
  821796
  824057
  825575
  825616
  825702
  825730
  826543
  828545
  828563
  828704
]
12.76 ms
(7.55%)
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
  805666
  422415
  533754
  533781
  533787
  703699
  578909
  611494
  590240
  733644
  699969
  499651
  819765
  546876
  487246
  627746
  511586
  780218
  818016
  826543
  821796
  825702
  825730
  782033
  795617
  777532
  792263
  482770
  543717
  624514
  782809
  787658
  787703
  757803
  768468
  779825
  481383
  533777
  809560
  431608
  574108
  659984
  652449
  703982
  705874
  594632
  603752
  624050
  613377
  768543
  626453
  788467
  825575
  825616
  828704
  828545
  828563
  790307
  804924
  420833
  824057
  413093
  786090
  790915
  809953
  783199
  756194
  763128
  771059
  771822
  791498
  415835
  486327
  522262
  489155
  481734
  818037
  819933
  798811
  552780
  550552
  664753
  685193
  656138
  612521
  623137
  783796
  793983
  703718
  473785
  410663
  474069
  610830
  474982
  474062
  501507
  590539
  779632
  703656
  791788
  540730
  653335
  588982
  601946
  621364
  502930
  787189
  801460
  786233
  791918
  811150
  756724
  490127
  443837
  535618
  504169
  687859
  783609
  809575
  730819
]
2.36 ms
(1.40%)
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
  410663
  413093
  415835
  420833
  422415
  431608
  443837
  473785
  474062
  474069
  474982
  481383
  481734
  482770
  486327
  487246
  489155
  490127
  499651
  501507
  502930
  504169
  511586
  522262
  533754
  533777
  533781
  533787
  535618
  540730
  543717
  546876
  550552
  552780
  574108
  578909
  588982
  590240
  590539
  594632
  601946
  603752
  610830
  611494
  612521
  613377
  621364
  623137
  624050
  624514
  626453
  627746
  652449
  653335
  656138
  659984
  664753
  685193
  687859
  699969
  703656
  703699
  703718
  703982
  705874
  730819
  733644
  756194
  756724
  757803
  763128
  768468
  768543
  771822
  777532
  779632
  779825
  780218
  782033
  782809
  783199
  783609
  783796
  786090
  786233
  787189
  787658
  787703
  788467
  790307
  790915
  791498
  791788
  791918
  792263
  793983
  795617
  798811
  801460
  804924
  805666
  809560
  809575
  809953
  811150
  818016
  818037
  819765
  819933
  821796
  824057
  825575
  825616
  825702
  825730
  826543
  828545
  828563
  828704
]
2.11 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov amateurs rus"
]
1.99 ms
(1.18%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов любительск русск"
]
1.69 ms
(1.00%)
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.