Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.49 ms
(84.17%)
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
  7456
  33443
  36852
  54149
  111756
  116701
  153376
  306071
  378309
  381926
  382462
  386013
  389514
  389978
  391074
  396558
  425392
  464029
  469287
  485173
  525024
  530028
  530696
  530721
  532360
  534995
  536309
  537204
  538525
  539571
  545461
  558782
  561443
  562491
  572876
  584488
  587266
  591626
  601096
  603198
  603457
  607507
  609891
  610144
  610549
  617428
  621416
  629267
  629279
  631247
  632645
  633466
  634116
  638186
  643934
  644307
  644961
  650902
  651607
  665361
  675010
  676623
  678127
  689374
  692404
  698286
  708451
  714830
  716878
  718931
  724547
  725139
  725757
  732336
  733566
  733586
  738585
  738648
  741480
  741682
  746470
  746794
  763152
  764343
  771622
  774606
  778067
  780682
  783780
  796565
  798342
  802302
  806984
  806992
  807640
  809257
  809262
  811049
  811485
  811604
  811826
  814733
  816862
  818600
  819180
  820453
  821689
  821916
  822217
  822262
  822280
  822822
  823129
  823289
  823464
  823525
  823560
  823592
  828431
  828855
]
14.57 ms
(9.05%)
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
  689374
  741480
  7456
  811485
  562491
  634116
  116701
  816862
  644961
  814733
  828431
  638186
  36852
  382462
  741682
  746794
  823129
  821689
  665361
  733586
  746470
  587266
  823289
  823560
  725139
  764343
  732336
  629279
  796565
  738648
  818600
  823592
  828855
  572876
  633466
  811826
  381926
  396558
  822217
  823525
  822262
  485173
  823464
  822822
  708451
  811049
  733566
  621416
  530028
  716878
  534995
  678127
  617428
  798342
  591626
  111756
  558782
  532360
  537204
  545461
  525024
  610549
  469287
  651607
  676623
  631247
  724547
  584488
  601096
  33443
  650902
  603457
  698286
  820453
  539571
  609891
  783780
  771622
  538525
  675010
  389514
  425392
  306071
  718931
  774606
  811604
  530721
  603198
  610144
  806984
  806992
  763152
  807640
  386013
  819180
  643934
  778067
  780682
  725757
  153376
  389978
  632645
  530696
  821916
  822280
  561443
  692404
  378309
  54149
  738585
  644307
  629267
  802302
  607507
  536309
  809262
  714830
  809257
  391074
  464029
]
3.13 ms
(1.95%)
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
  7456
  33443
  36852
  54149
  111756
  116701
  153376
  306071
  378309
  381926
  382462
  386013
  389514
  389978
  391074
  396558
  425392
  464029
  469287
  485173
  525024
  530028
  530696
  530721
  532360
  534995
  536309
  537204
  538525
  539571
  545461
  558782
  561443
  562491
  572876
  584488
  587266
  591626
  601096
  603198
  603457
  607507
  609891
  610144
  610549
  617428
  621416
  629267
  629279
  631247
  632645
  633466
  634116
  638186
  643934
  644307
  644961
  650902
  651607
  665361
  675010
  676623
  678127
  689374
  692404
  698286
  708451
  714830
  716878
  718931
  724547
  725139
  725757
  732336
  733566
  733586
  738585
  738648
  741480
  741682
  746470
  746794
  763152
  764343
  771622
  774606
  778067
  780682
  783780
  796565
  798342
  802302
  806984
  806992
  807640
  809257
  809262
  811049
  811485
  811604
  811826
  814733
  816862
  818600
  819180
  820453
  821689
  821916
  822217
  822262
  822280
  822822
  823129
  823289
  823464
  823525
  823560
  823592
  828431
  828855
]
2.34 ms
(1.45%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big tits black"
]
2.00 ms
(1.24%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие сиськ black"
]
1.78 ms
(1.10%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "большие сиськ black"
]

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.