Query Metrics
7
Database Queries
7
Different statements
196.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.95 ms (85.79%) |
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 88591 381912 387328 392023 399354 402625 408692 411285 415147 415946 416142 416230 416527 416621 416653 416691 416693 416733 418697 418861 420643 421732 423837 431120 432288 432613 432692 433204 433230 440746 441126 441131 444406 444533 446612 447160 448115 448819 448838 452325 452646 453165 455408 456222 456236 459331 464205 464550 464905 465708 466474 469219 469567 471660 475059 476737 483564 483787 494272 496642 497482 500256 500292 500734 510413 510945 511893 513464 513479 513486 513578 520910 530677 534536 544847 546955 546964 547890 550218 551123 555098 573204 575601 584029 588077 594491 600329 605725 615921 637503 640777 640785 642004 669074 669080 671044 692094 693529 700996 701763 709693 714665 725608 729105 734380 744689 745807 746199 746972 758226 765424 770306 776233 777042 783369 797447 800333 805722 810085 ] |
||||||||||||||||||||||||||||||
|
17.43 ms (8.85%) |
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 692094 701763 693529 642004 776233 800333 729105 734380 743671 746199 765424 805722 810085 770306 725608 744689 745807 746972 783369 416527 423837 459331 448115 494272 510945 534536 544847 555098 714665 550218 637503 510413 496642 777042 444533 500734 605725 432288 513578 399354 416653 418697 432692 433204 433230 441131 415946 416621 444406 448838 452646 471660 448819 464905 465708 483564 447160 464205 469219 500256 511893 475059 573204 575601 546955 546964 547890 671044 700996 669074 669080 551123 584029 594491 600329 588077 615921 640777 640785 797447 758226 709693 392023 408692 418861 456222 440746 455408 456236 387328 452325 453165 466474 476737 446612 464550 469567 411285 415147 500292 513464 530677 513486 520910 497482 483787 513479 381912 88591 402625 416230 421732 431120 441126 416142 416693 416733 420643 432613 416691 ] |
||||||||||||||||||||||||||||||
|
3.37 ms (1.71%) |
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 88591 381912 387328 392023 399354 402625 408692 411285 415147 415946 416142 416230 416527 416621 416653 416691 416693 416733 418697 418861 420643 421732 423837 431120 432288 432613 432692 433204 433230 440746 441126 441131 444406 444533 446612 447160 448115 448819 448838 452325 452646 453165 455408 456222 456236 459331 464205 464550 464905 465708 466474 469219 469567 471660 475059 476737 483564 483787 494272 496642 497482 500256 500292 500734 510413 510945 511893 513464 513479 513486 513578 520910 530677 534536 544847 546955 546964 547890 550218 551123 555098 573204 575601 584029 588077 594491 600329 605725 615921 637503 640777 640785 642004 669074 669080 671044 692094 693529 700996 701763 709693 714665 725608 729105 734380 744689 745807 746199 746972 758226 765424 770306 776233 777042 783369 797447 800333 805722 810085 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"дырк анал"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hole anal"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.84%) |
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.