Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
208.15 ms
(57.37%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
134.77 ms
(37.15%)
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
  16913
  82133
  350980
  385632
  387631
  391383
  392745
  393408
  396317
  398523
  401774
  467847
  545099
  553671
  554835
  555217
  565445
  590747
  593023
  595898
  596906
  605258
  606830
  609732
  612918
  615596
  618166
  620333
  621447
  623859
  625492
  627012
  628213
  631122
  631382
  661438
  707278
  707973
  715047
  720109
  726289
  728131
  728682
  730572
  732216
  735291
  735962
  738445
  738807
  740509
  741401
  744231
  745509
  745513
  745584
  749801
  749865
  750641
  751106
  752763
  753524
  753630
  753656
  754267
  755814
  758065
  758416
  759012
  759309
  762167
  764880
  765985
  768293
  771339
  771400
  771584
  771794
  777228
  778442
  778839
  779316
  779382
  779482
  780663
  781891
  783201
  783491
  784295
  785776
  786160
  786429
  787720
  787821
  787935
  788623
  789148
  789966
  789984
  790780
  791556
  792299
  794455
  795439
  795445
  799851
  800788
  801325
  801420
  802160
  803991
  805689
  807318
  807370
  809306
  810181
  810322
  811162
  811810
  812386
]
11.68 ms
(3.22%)
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
  661438
  707278
  707973
  715047
  720109
  553671
  555217
  565445
  590747
  621447
  625492
  595898
  605258
  609732
  612918
  618166
  628213
  593023
  596906
  615596
  620333
  623859
  631382
  779382
  780663
  783491
  787720
  789984
  790780
  791556
  802160
  807318
  811162
  777228
  778442
  778839
  779316
  783201
  786429
  787935
  792299
  795445
  800788
  805689
  812386
  726289
  732216
  755814
  771400
  784295
  786160
  795439
  801420
  810181
  811810
  735291
  741401
  745509
  745513
  750641
  751106
  753656
  754267
  762167
  728131
  738445
  745584
  758416
  759012
  768293
  771339
  728682
  730572
  735962
  738807
  759309
  771584
  771794
  749801
  749865
  752763
  758065
  764880
  606830
  631122
  776114
  779482
  781891
  785776
  787821
  788623
  789148
  789966
  794455
  799851
  801325
  803991
  807370
  809306
  810322
  387631
  350980
  391383
  392745
  393408
  401774
  467847
  82133
  385632
  396317
  398523
  554835
  545099
  16913
  627012
  744231
  765985
  753524
  753630
  740509
]
3.02 ms
(0.83%)
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
  16913
  82133
  350980
  385632
  387631
  391383
  392745
  393408
  396317
  398523
  401774
  467847
  545099
  553671
  554835
  555217
  565445
  590747
  593023
  595898
  596906
  605258
  606830
  609732
  612918
  615596
  618166
  620333
  621447
  623859
  625492
  627012
  628213
  631122
  631382
  661438
  707278
  707973
  715047
  720109
  726289
  728131
  728682
  730572
  732216
  735291
  735962
  738445
  738807
  740509
  741401
  744231
  745509
  745513
  745584
  749801
  749865
  750641
  751106
  752763
  753524
  753630
  753656
  754267
  755814
  758065
  758416
  759012
  759309
  762167
  764880
  765985
  768293
  771339
  771400
  771584
  771794
  777228
  778442
  778839
  779316
  779382
  779482
  780663
  781891
  783201
  783491
  784295
  785776
  786160
  786429
  787720
  787821
  787935
  788623
  789148
  789966
  789984
  790780
  791556
  792299
  794455
  795439
  795445
  799851
  800788
  801325
  801420
  802160
  803991
  805689
  807318
  807370
  809306
  810181
  810322
  811162
  811810
  812386
]
1.88 ms
(0.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "кончил в туалете"
]
1.76 ms
(0.49%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм туалет"
]
1.55 ms
(0.43%)
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.