Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
240.22 ms
(90.41%)
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
  461425
  461701
  463326
  472102
  489009
  495412
  498988
  505293
  506487
  507808
  510483
  512004
  516746
  518359
  520582
  527095
  530554
  533234
  534072
  540969
  541013
  541547
  541907
  543829
  546274
  547980
  550226
  551145
  551544
  555652
  557398
  567750
  571095
  571727
  572219
  572230
  581054
  584889
  585237
  586148
  588116
  591779
  593223
  595098
  599693
  603564
  605565
  608519
  614695
  619011
  619296
  619727
  620905
  621105
  623884
  623909
  624315
  625637
  628227
  628909
  638906
  641691
  641865
  646012
  654230
  660467
  663567
  670238
  670546
  672877
  673506
  675628
  677918
  677922
  686285
  686977
  688745
  690621
  697101
  697717
  701505
  710902
  713160
  714542
  714548
  715826
  716364
  720395
  722276
  724713
  724916
  727343
  728987
  737307
  739236
  743937
  746137
  747954
  748639
  755918
  756655
  761096
  761123
  761185
  763360
  764285
  764802
  769233
  773586
  780029
  782868
  783612
  783871
  785584
  786820
  787928
  788313
  791997
  800270
  800975
]
13.25 ms
(4.99%)
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
  520582
  527095
  498988
  505293
  506487
  507808
  512004
  518359
  530554
  533234
  534072
  461425
  472102
  540969
  546274
  547980
  567750
  581054
  541013
  572219
  584889
  541547
  541907
  550226
  551145
  555652
  646012
  670546
  673506
  688745
  697101
  714542
  715826
  660467
  677918
  697717
  713160
  722276
  663567
  670238
  672877
  675628
  677922
  690621
  701505
  714548
  716364
  720395
  571095
  571727
  572230
  588116
  593223
  595098
  603564
  619727
  628227
  628909
  641865
  585237
  599693
  608519
  619296
  623909
  624315
  638906
  586148
  591779
  619011
  620905
  623884
  641691
  780029
  783612
  791997
  800975
  782868
  727343
  769233
  785584
  800270
  748639
  761123
  724713
  746137
  764285
  728987
  743937
  761185
  763360
  724916
  737307
  755918
  756655
  764802
  773586
  614695
  621105
  710902
  783871
  786820
  787928
  788313
  461701
  489009
  495412
  510483
  516746
  463326
  543829
  557398
  551544
  654230
  686977
  686285
  605565
  739236
  747954
  761096
  625637
]
4.64 ms
(1.75%)
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
  461425
  461701
  463326
  472102
  489009
  495412
  498988
  505293
  506487
  507808
  510483
  512004
  516746
  518359
  520582
  527095
  530554
  533234
  534072
  540969
  541013
  541547
  541907
  543829
  546274
  547980
  550226
  551145
  551544
  555652
  557398
  567750
  571095
  571727
  572219
  572230
  581054
  584889
  585237
  586148
  588116
  591779
  593223
  595098
  599693
  603564
  605565
  608519
  614695
  619011
  619296
  619727
  620905
  621105
  623884
  623909
  624315
  625637
  628227
  628909
  638906
  641691
  641865
  646012
  654230
  660467
  663567
  670238
  670546
  672877
  673506
  675628
  677918
  677922
  686285
  686977
  688745
  690621
  697101
  697717
  701505
  710902
  713160
  714542
  714548
  715826
  716364
  720395
  722276
  724713
  724916
  727343
  728987
  737307
  739236
  743937
  746137
  747954
  748639
  755918
  756655
  761096
  761123
  761185
  763360
  764285
  764802
  769233
  773586
  780029
  782868
  783612
  783871
  785584
  786820
  787928
  788313
  791997
  800270
  800975
]
2.06 ms
(0.77%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "маленькая cock вебкамер"
]
2.01 ms
(0.76%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.94 ms
(0.73%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "small cock webcam"
]
1.60 ms
(0.60%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "маленькая cock вебкамер"
]

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.