Query Metrics
7
Database Queries
7
Different statements
203.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
177.09 ms (87.12%) |
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 53515 96484 388353 390525 391372 395929 396214 396408 407171 416195 417136 417272 418724 418732 421220 421448 422441 423283 423580 424497 428726 434491 443224 446682 450910 450966 451175 451622 451670 453788 456215 459096 461941 462854 463775 463884 463915 468007 470087 470580 472350 473967 474889 476075 482076 482084 484097 484464 484476 485336 489523 491611 491667 491689 494999 495066 496448 499069 508832 510368 510545 510550 510612 512174 512877 512879 516615 522617 523501 523893 524396 524794 525748 525957 527189 527215 527625 527927 530629 532806 532965 534480 536264 536266 536668 537669 539101 541584 543843 543851 546780 546829 548253 548258 548262 550067 552010 552298 559179 559856 563876 565246 567349 573409 588048 600111 600402 603482 614566 632015 632557 637486 639803 650320 658216 696606 729957 729962 814640 817057 ] |
||||||||||||||||||||||||||||||
|
15.89 ms (7.82%) |
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 524794 496448 525748 491667 510612 491689 484464 484476 532806 552298 559179 563876 614566 637486 639803 407171 461941 451175 696606 434491 468007 470087 491611 512877 546780 548253 588048 600111 600402 470580 539101 484097 499069 543843 548258 573409 476075 536264 510545 537669 395929 96484 390525 417272 424497 814640 817057 451670 522617 534480 541584 546829 567349 729957 396408 474889 508832 523893 527189 421220 418724 423283 565246 450910 450966 510550 516615 527215 536668 536266 388353 418732 443224 453788 524396 510368 512174 543851 548262 658216 650320 632557 632015 729962 53515 396214 416195 451622 523501 530629 489523 550067 552010 446682 428726 463775 463915 456215 495066 532965 559856 459096 421448 422441 472350 525957 494999 527625 391372 423580 473967 485336 512879 527927 463884 603482 462854 482076 482084 417136 ] |
||||||||||||||||||||||||||||||
|
3.29 ms (1.62%) |
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 53515 96484 388353 390525 391372 395929 396214 396408 407171 416195 417136 417272 418724 418732 421220 421448 422441 423283 423580 424497 428726 434491 443224 446682 450910 450966 451175 451622 451670 453788 456215 459096 461941 462854 463775 463884 463915 468007 470087 470580 472350 473967 474889 476075 482076 482084 484097 484464 484476 485336 489523 491611 491667 491689 494999 495066 496448 499069 508832 510368 510545 510550 510612 512174 512877 512879 516615 522617 523501 523893 524396 524794 525748 525957 527189 527215 527625 527927 530629 532806 532965 534480 536264 536266 536668 537669 539101 541584 543843 543851 546780 546829 548253 548258 548262 550067 552010 552298 559179 559856 563876 565246 567349 573409 588048 600111 600402 603482 614566 632015 632557 637486 639803 650320 658216 696606 729957 729962 814640 817057 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teen domination bdsm"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teen domination бдсм"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teen domination бдсм"
]
|
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.