Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
189.83 ms
(84.95%)
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
  2651
  29166
  56805
  156487
  202846
  304698
  371202
  382567
  383122
  384887
  386990
  395174
  398492
  400311
  401801
  403628
  404024
  411133
  413140
  416342
  417745
  420642
  421466
  422051
  422824
  425102
  428109
  431719
  433201
  435001
  438397
  439597
  445850
  448769
  449246
  450398
  454353
  456476
  457059
  457149
  458318
  461635
  463403
  463567
  466616
  467099
  467980
  468206
  469031
  471774
  472732
  473258
  478370
  478742
  479023
  479926
  482579
  483079
  484544
  485017
  485361
  489579
  489833
  491904
  492202
  492947
  493413
  494791
  496374
  496853
  497179
  498664
  499803
  506117
  508619
  509704
  515354
  515939
  515948
  516113
  516924
  517768
  520378
  520640
  520942
  521167
  522953
  525668
  526664
  527491
  527588
  528404
  533721
  534084
  534355
  536022
  540035
  547726
  552752
  556440
  557486
  561696
  562735
  566226
  569623
  569831
  570144
  571349
  574779
  601049
  605152
  621298
  663287
  723674
  756522
  767458
  771763
  789580
  792002
  814499
]
21.48 ms
(9.61%)
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
  520640
  403628
  516924
  466616
  483079
  517768
  497179
  496374
  463403
  605152
  506117
  547726
  515948
  789580
  458318
  467099
  382567
  445850
  469031
  767458
  498664
  509704
  515939
  400311
  526664
  723674
  156487
  527588
  450398
  496853
  533721
  422051
  515354
  471774
  520378
  485361
  528404
  492202
  663287
  571349
  461635
  421466
  401801
  29166
  420642
  472732
  413140
  479926
  435001
  448769
  485017
  508619
  468206
  557486
  457059
  499803
  467980
  489833
  570144
  411133
  449246
  814499
  534355
  771763
  536022
  439597
  416342
  569623
  534084
  491904
  438397
  484544
  562735
  556440
  478742
  516113
  569831
  561696
  425102
  56805
  404024
  383122
  574779
  566226
  621298
  473258
  525668
  422824
  479023
  522953
  456476
  463567
  371202
  428109
  478370
  431719
  489579
  493413
  202846
  2651
  454353
  494791
  527491
  457149
  384887
  601049
  304698
  386990
  395174
  417745
  792002
  756522
  520942
  492947
  521167
  398492
  433201
  482579
  540035
  552752
]
4.67 ms
(2.09%)
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
  2651
  29166
  56805
  156487
  202846
  304698
  371202
  382567
  383122
  384887
  386990
  395174
  398492
  400311
  401801
  403628
  404024
  411133
  413140
  416342
  417745
  420642
  421466
  422051
  422824
  425102
  428109
  431719
  433201
  435001
  438397
  439597
  445850
  448769
  449246
  450398
  454353
  456476
  457059
  457149
  458318
  461635
  463403
  463567
  466616
  467099
  467980
  468206
  469031
  471774
  472732
  473258
  478370
  478742
  479023
  479926
  482579
  483079
  484544
  485017
  485361
  489579
  489833
  491904
  492202
  492947
  493413
  494791
  496374
  496853
  497179
  498664
  499803
  506117
  508619
  509704
  515354
  515939
  515948
  516113
  516924
  517768
  520378
  520640
  520942
  521167
  522953
  525668
  526664
  527491
  527588
  528404
  533721
  534084
  534355
  536022
  540035
  547726
  552752
  556440
  557486
  561696
  562735
  566226
  569623
  569831
  570144
  571349
  574779
  601049
  605152
  621298
  663287
  723674
  756522
  767458
  771763
  789580
  792002
  814499
]
2.19 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.10 ms
(0.94%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "красотки в нижнем бел%…"
]
1.70 ms
(0.76%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "красивая в нижн бел"
]
1.50 ms
(0.67%)
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.