Query Metrics
7
Database Queries
7
Different statements
158.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.71 ms (79.86%) |
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 390402 393562 395562 395871 401015 401140 407881 412976 418881 419213 421215 427069 428653 433976 436098 436721 438353 441572 442146 444046 444063 445501 446070 448104 448378 448439 448694 450985 452622 453039 453135 453538 454402 454481 455200 455483 455677 456453 456578 460586 460986 461319 461716 462862 463933 463961 464725 466022 466034 466066 467127 469748 470782 472302 473308 473575 476376 476822 476860 478400 479327 481657 481666 481817 481908 482124 483993 484285 484942 485145 485257 485258 486388 486920 487100 489179 489746 492119 495425 499189 502582 502625 502636 505218 505750 505815 506271 508732 508743 509057 510220 510519 511358 514385 517924 518095 518459 518460 519424 519608 521546 523364 524814 525210 525656 526197 526281 526415 527039 527705 527859 528777 528820 529469 532307 535453 542484 542872 597060 705327 ] |
||||||||||||||||||||||||||||||
|
19.82 ms (12.49%) |
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 705327 390402 419213 433976 463933 467127 401015 407881 461319 461716 466034 466066 470782 479327 481657 482124 395562 444063 453039 455200 456453 460986 427069 438353 448378 463961 478400 446070 450985 466022 472302 476860 502636 505218 505750 505815 517924 521546 527859 486920 502582 502625 509057 510519 514385 525210 525656 526415 527705 528820 483993 495425 518095 524814 535453 485258 489179 489746 499189 508732 508743 519608 526197 528777 529469 412976 421215 436721 442146 418881 428653 445501 452622 453135 454481 473575 476376 481908 484285 487100 448104 455677 456578 464725 481666 481817 484942 485145 492119 453538 454402 460586 486388 510220 523364 526281 532307 506271 511358 518459 518460 519424 527039 485257 542484 542872 597060 441572 448694 455483 462862 469748 473308 393562 401140 448439 476822 395871 436098 444046 ] |
||||||||||||||||||||||||||||||
|
4.86 ms (3.06%) |
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 390402 393562 395562 395871 401015 401140 407881 412976 418881 419213 421215 427069 428653 433976 436098 436721 438353 441572 442146 444046 444063 445501 446070 448104 448378 448439 448694 450985 452622 453039 453135 453538 454402 454481 455200 455483 455677 456453 456578 460586 460986 461319 461716 462862 463933 463961 464725 466022 466034 466066 467127 469748 470782 472302 473308 473575 476376 476822 476860 478400 479327 481657 481666 481817 481908 482124 483993 484285 484942 485145 485257 485258 486388 486920 487100 489179 489746 492119 495425 499189 502582 502625 502636 505218 505750 505815 506271 508732 508743 509057 510220 510519 511358 514385 517924 518095 518459 518460 519424 519608 521546 523364 524814 525210 525656 526197 526281 526415 527039 527705 527859 528777 528820 529469 532307 535453 542484 542872 597060 705327 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"white boyfriend"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"white boyfriend"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"white boyfriend"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.98%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.