Query Metrics
7
Database Queries
7
Different statements
188.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.17 ms (85.84%) |
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 13011 14232 14328 33431 78786 78926 78976 79388 146523 161485 336072 360065 382662 385174 385341 391306 395504 395583 396556 396570 396594 397805 398789 399089 399310 399411 404015 405916 405979 410366 410956 413786 416869 417081 418202 421740 421743 424734 427217 428603 428783 429823 430380 432020 432611 432736 432741 435715 443457 444422 445736 445946 453373 455453 455611 456044 456048 457038 457240 457401 457843 458106 458622 458971 459012 459015 459637 460689 461023 464090 464214 465109 465702 466382 467915 468041 471140 472614 473343 475463 475481 475489 475630 479698 482705 482714 483497 484150 484302 485225 490576 492125 493808 494318 496372 497681 502179 503816 505465 510257 512903 513736 513746 513783 514289 516655 537948 567158 585321 604478 620499 655431 657361 658082 658405 712776 712789 747879 750466 805739 ] |
||||||||||||||||||||||||||||||
|
15.71 ms (8.31%) |
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 747879 502179 13011 655431 604478 146523 78926 421743 410956 435715 457401 459012 493808 496372 461023 336072 405979 712776 457240 14232 658082 512903 78786 391306 399411 432741 457038 483497 513746 33431 396556 398789 405916 432611 424734 417081 444422 459015 456044 472614 464214 473343 494318 399310 430380 385174 385341 397805 404015 429823 453373 455453 456048 458622 467915 457843 497681 513783 712789 475481 421740 484150 657361 620499 513736 79388 428783 466382 471140 468041 750466 396594 14328 360065 432020 396570 395583 78976 399089 505465 492125 161485 382662 395504 416869 490576 445736 445946 418202 464090 475630 428603 443457 410366 432736 482714 482705 459637 479698 458971 465109 465702 475463 475489 485225 503816 537948 567158 585321 805739 413786 455611 458106 514289 484302 658405 427217 460689 510257 516655 ] |
||||||||||||||||||||||||||||||
|
4.49 ms (2.37%) |
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 13011 14232 14328 33431 78786 78926 78976 79388 146523 161485 336072 360065 382662 385174 385341 391306 395504 395583 396556 396570 396594 397805 398789 399089 399310 399411 404015 405916 405979 410366 410956 413786 416869 417081 418202 421740 421743 424734 427217 428603 428783 429823 430380 432020 432611 432736 432741 435715 443457 444422 445736 445946 453373 455453 455611 456044 456048 457038 457240 457401 457843 458106 458622 458971 459012 459015 459637 460689 461023 464090 464214 465109 465702 466382 467915 468041 471140 472614 473343 475463 475481 475489 475630 479698 482705 482714 483497 484150 484302 485225 490576 492125 493808 494318 496372 497681 502179 503816 505465 510257 512903 513736 513746 513783 514289 516655 537948 567158 585321 604478 620499 655431 657361 658082 658405 712776 712789 747879 750466 805739 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife and negro"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен чернокожий"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.35 ms (0.72%) |
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.