Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.92 ms
(80.35%)
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
  387347
  404122
  408170
  415577
  418134
  429938
  440900
  441280
  444776
  445948
  447694
  449099
  449262
  451761
  451827
  452364
  452387
  456977
  458612
  460015
  463782
  464874
  468026
  468459
  474569
  475815
  475864
  476058
  477243
  478388
  486613
  490187
  490594
  492318
  492753
  494255
  496396
  496890
  499356
  505530
  505665
  509598
  510457
  510904
  510947
  511080
  515092
  515634
  516475
  517848
  519262
  519450
  520940
  520949
  522180
  522624
  523914
  524545
  525415
  525733
  525769
  526986
  527472
  529542
  536884
  541734
  546566
  551386
  551828
  552282
  553253
  555959
  556192
  557582
  558611
  560060
  560927
  565290
  568823
  570459
  573676
  573724
  576487
  576647
  581702
  582740
  584304
  586262
  591661
  591866
  597101
  597803
  601808
  603722
  612772
  616503
  618796
  626457
  632114
  634810
  636558
  642861
  649368
  650741
  662011
  668465
  684997
  691693
  726434
  729567
  733403
  742067
  761299
  764153
  768675
  777079
  797775
  800338
  800429
  803700
]
19.60 ms
(12.81%)
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
  404122
  387347
  510904
  490594
  476058
  415577
  618796
  463782
  478388
  452364
  525733
  510947
  527472
  523914
  552282
  568823
  546566
  553253
  556192
  570459
  573676
  573724
  576487
  584304
  560060
  565290
  581702
  650741
  691693
  649368
  662011
  668465
  684997
  551386
  551828
  555959
  557582
  558611
  560927
  576647
  582740
  591866
  616503
  636558
  591661
  601808
  626457
  586262
  597101
  597803
  642861
  800338
  777079
  803700
  729567
  797775
  800429
  742067
  764153
  768675
  726434
  761299
  733403
  603722
  612772
  632114
  634810
  449262
  460015
  445948
  499356
  511080
  541734
  496890
  408170
  418134
  429938
  440900
  441280
  444776
  451761
  456977
  458612
  468459
  474569
  492753
  451827
  475815
  477243
  486613
  490187
  447694
  449099
  452387
  464874
  468026
  475864
  492318
  494255
  505530
  510457
  516475
  517848
  519262
  520940
  520949
  522180
  522624
  524545
  525415
  536884
  505665
  509598
  515092
  515634
  519450
  525769
  526986
  529542
  496396
]
3.05 ms
(1.99%)
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
  387347
  404122
  408170
  415577
  418134
  429938
  440900
  441280
  444776
  445948
  447694
  449099
  449262
  451761
  451827
  452364
  452387
  456977
  458612
  460015
  463782
  464874
  468026
  468459
  474569
  475815
  475864
  476058
  477243
  478388
  486613
  490187
  490594
  492318
  492753
  494255
  496396
  496890
  499356
  505530
  505665
  509598
  510457
  510904
  510947
  511080
  515092
  515634
  516475
  517848
  519262
  519450
  520940
  520949
  522180
  522624
  523914
  524545
  525415
  525733
  525769
  526986
  527472
  529542
  536884
  541734
  546566
  551386
  551828
  552282
  553253
  555959
  556192
  557582
  558611
  560060
  560927
  565290
  568823
  570459
  573676
  573724
  576487
  576647
  581702
  582740
  584304
  586262
  591661
  591866
  597101
  597803
  601808
  603722
  612772
  616503
  618796
  626457
  632114
  634810
  636558
  642861
  649368
  650741
  662011
  668465
  684997
  691693
  726434
  729567
  733403
  742067
  761299
  764153
  768675
  777079
  797775
  800338
  800429
  803700
]
2.12 ms
(1.38%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.08 ms
(1.36%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "клитор крупный"
]
1.79 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "клитор большой большие"
]
1.42 ms
(0.93%)
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.