Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
170.53 ms
(87.05%)
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
  7981
  389440
  400237
  400602
  401114
  407656
  408306
  408774
  412362
  414014
  414126
  415004
  419475
  421043
  430486
  440620
  446501
  451932
  454788
  457446
  460135
  471945
  475752
  481584
  482679
  486594
  487344
  487517
  487708
  492523
  492534
  498030
  499636
  502767
  506009
  507512
  508474
  511895
  514097
  519497
  520253
  521723
  524262
  531415
  531545
  531996
  533014
  534823
  534961
  535485
  536724
  544596
  549507
  550064
  550672
  557534
  559952
  559953
  566321
  566606
  566825
  574298
  575656
  577402
  581620
  583238
  587854
  587907
  589647
  602259
  603249
  603431
  604386
  614097
  620160
  622335
  628641
  629363
  631199
  634475
  637060
  640710
  640721
  642742
  647328
  647901
  650806
  664212
  674056
  682107
  714973
  720291
  724656
  790878
  792558
  792610
  792612
  797447
  798683
  802826
  806430
  807363
  808579
  808600
  809414
  809479
  810899
  810976
  813101
  814392
  814892
  814901
  815232
  815250
  815374
  815545
  816249
  816569
  817857
  820973
]
15.55 ms
(7.94%)
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
  816249
  815545
  820973
  460135
  536724
  524262
  534961
  475752
  566321
  566825
  575656
  549507
  550672
  664212
  642742
  589647
  603249
  620160
  587907
  628641
  634475
  631199
  798683
  806430
  808600
  810899
  797447
  802826
  809414
  809479
  629363
  714973
  720291
  790878
  813101
  7981
  400602
  430486
  492523
  650806
  535485
  724656
  498030
  507512
  519497
  814901
  492534
  487344
  414014
  408774
  814392
  816569
  815232
  815374
  482679
  487517
  531996
  502767
  506009
  514097
  531415
  559952
  566606
  577402
  583238
  550064
  682107
  647901
  674056
  647328
  544596
  559953
  574298
  604386
  614097
  637060
  587854
  602259
  622335
  792610
  792612
  603431
  792558
  389440
  401114
  400237
  412362
  414126
  415004
  446501
  471945
  421043
  451932
  499636
  487708
  511895
  457446
  407656
  521723
  533014
  486594
  815250
  817857
  408306
  440620
  814892
  454788
  508474
  520253
  531545
  534823
  481584
  557534
  581620
  640721
  807363
  808579
  810976
  640710
  419475
]
2.78 ms
(1.42%)
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
  7981
  389440
  400237
  400602
  401114
  407656
  408306
  408774
  412362
  414014
  414126
  415004
  419475
  421043
  430486
  440620
  446501
  451932
  454788
  457446
  460135
  471945
  475752
  481584
  482679
  486594
  487344
  487517
  487708
  492523
  492534
  498030
  499636
  502767
  506009
  507512
  508474
  511895
  514097
  519497
  520253
  521723
  524262
  531415
  531545
  531996
  533014
  534823
  534961
  535485
  536724
  544596
  549507
  550064
  550672
  557534
  559952
  559953
  566321
  566606
  566825
  574298
  575656
  577402
  581620
  583238
  587854
  587907
  589647
  602259
  603249
  603431
  604386
  614097
  620160
  622335
  628641
  629363
  631199
  634475
  637060
  640710
  640721
  642742
  647328
  647901
  650806
  664212
  674056
  682107
  714973
  720291
  724656
  790878
  792558
  792610
  792612
  797447
  798683
  802826
  806430
  807363
  808579
  808600
  809414
  809479
  810899
  810976
  813101
  814392
  814892
  814901
  815232
  815250
  815374
  815545
  816249
  816569
  817857
  820973
]
1.97 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "латинская mature mom"
]
1.97 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "latina mature mom"
]
1.58 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.51 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "латинская mature mom"
]

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.