Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
214.39 ms
(52.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "brunettes love член"
]
168.10 ms
(41.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
  382060
  395913
  401615
  406685
  411320
  417863
  422290
  425849
  429817
  431530
  436655
  439214
  442841
  446208
  446724
  455947
  457165
  460211
  460929
  462677
  466178
  467724
  468125
  469007
  469011
  470187
  473798
  475245
  476220
  478038
  480719
  482644
  482688
  491248
  493110
  494353
  495915
  496662
  498614
  499812
  500590
  501870
  502436
  510195
  511308
  511710
  511791
  511841
  513750
  514814
  514995
  515347
  516812
  516968
  517687
  521491
  521757
  522081
  522914
  525095
  526042
  530216
  540504
  541373
  542294
  546485
  553204
  554169
  556063
  558335
  559820
  561510
  564859
  565710
  570765
  574427
  574828
  574867
  575497
  575724
  575781
  577080
  581424
  584524
  587964
  590203
  591022
  593009
  595671
  602946
  605794
  606624
  609826
  621348
  628072
  633435
  712248
  714026
  717887
  717940
  726494
  726714
  727031
  736354
  742891
  794135
  797065
  800191
  801235
  815351
  821069
  823222
]
17.21 ms
(4.21%)
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
  714026
  797065
  382060
  510195
  514995
  462677
  554169
  556063
  590203
  595671
  425849
  436655
  466178
  460211
  470187
  511710
  633435
  468125
  493110
  574867
  559820
  575781
  717940
  717887
  712248
  584524
  742891
  726494
  455947
  522081
  495915
  587964
  469011
  482688
  476220
  521491
  501870
  460929
  469007
  593009
  525095
  494353
  821069
  446208
  516812
  575724
  581424
  800191
  794135
  801235
  736354
  446724
  498614
  542294
  496662
  521757
  574427
  577080
  609826
  727031
  422290
  467724
  431530
  499812
  605794
  406685
  502436
  823222
  478038
  564859
  473798
  401615
  417863
  815351
  516968
  561510
  574828
  546485
  553204
  511841
  526042
  530216
  575497
  411320
  439214
  515347
  482644
  500590
  565710
  395913
  513750
  514814
  541373
  628072
  475245
  511308
  511791
  491248
  517687
  558335
  429817
  726714
  602946
  442841
  457165
  522914
  540504
  480719
  621348
  591022
  606624
  570765
]
3.18 ms
(0.78%)
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
  382060
  395913
  401615
  406685
  411320
  417863
  422290
  425849
  429817
  431530
  436655
  439214
  442841
  446208
  446724
  455947
  457165
  460211
  460929
  462677
  466178
  467724
  468125
  469007
  469011
  470187
  473798
  475245
  476220
  478038
  480719
  482644
  482688
  491248
  493110
  494353
  495915
  496662
  498614
  499812
  500590
  501870
  502436
  510195
  511308
  511710
  511791
  511841
  513750
  514814
  514995
  515347
  516812
  516968
  517687
  521491
  521757
  522081
  522914
  525095
  526042
  530216
  540504
  541373
  542294
  546485
  553204
  554169
  556063
  558335
  559820
  561510
  564859
  565710
  570765
  574427
  574828
  574867
  575497
  575724
  575781
  577080
  581424
  584524
  587964
  590203
  591022
  593009
  595671
  602946
  605794
  606624
  609826
  621348
  628072
  633435
  712248
  714026
  717887
  717940
  726494
  726714
  727031
  736354
  742891
  794135
  797065
  800191
  801235
  815351
  821069
  823222
]
2.15 ms
(0.53%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "brunettes love dick"
]
1.76 ms
(0.43%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(0.42%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "brunettes love член"
]

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.