Query Metrics
7
Database Queries
7
Different statements
153.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.36 ms (83.06%) |
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 287459 383597 387359 390209 394548 395720 399648 400148 401971 404478 404491 404600 404644 405194 407494 407507 407552 409109 409258 411840 413979 415702 418922 419124 419145 424023 435263 447357 448310 457458 461364 462101 462466 465500 467273 467544 471347 474754 476301 476344 490184 495772 496549 505836 506629 512593 517217 525115 534319 540958 550585 551326 552198 560396 561356 561667 561686 561721 565218 566848 570077 571839 572014 572827 575823 577320 579188 586034 590897 599451 601630 603736 606731 610179 610201 626891 628044 628614 636270 643411 652901 663483 663515 665277 665840 677039 680745 687500 701487 702455 712821 717860 722751 722851 724502 725399 727400 731014 732387 737169 738910 740138 744966 747976 760938 772142 774613 777859 781678 788290 788822 789660 790888 799402 808114 809361 814847 824345 824806 827919 ] |
||||||||||||||||||||||||||||||
|
16.98 ms (11.07%) |
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 799402 777859 601630 610179 411840 447357 474754 534319 561721 744966 740138 399648 512593 525115 712821 586034 610201 636270 725399 772142 808114 287459 424023 407494 407507 566848 467273 570077 701487 663515 665277 677039 561667 517217 395720 418922 560396 404491 404478 413979 496549 626891 628614 404644 401971 387359 476301 540958 788822 789660 551326 774613 747976 727400 732387 760938 809361 572014 552198 643411 462101 824806 702455 383597 603736 506629 409109 448310 561686 561356 663483 565218 407552 419145 467544 471347 476344 409258 465500 490184 457458 572827 722751 577320 606731 790888 722851 404600 419124 495772 680745 737169 579188 628044 394548 405194 814847 575823 599451 400148 462466 461364 505836 390209 824345 827919 550585 652901 665840 788290 781678 724502 731014 738910 435263 571839 687500 717860 590897 415702 ] |
||||||||||||||||||||||||||||||
|
2.27 ms (1.48%) |
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 287459 383597 387359 390209 394548 395720 399648 400148 401971 404478 404491 404600 404644 405194 407494 407507 407552 409109 409258 411840 413979 415702 418922 419124 419145 424023 435263 447357 448310 457458 461364 462101 462466 465500 467273 467544 471347 474754 476301 476344 490184 495772 496549 505836 506629 512593 517217 525115 534319 540958 550585 551326 552198 560396 561356 561667 561686 561721 565218 566848 570077 571839 572014 572827 575823 577320 579188 586034 590897 599451 601630 603736 606731 610179 610201 626891 628044 628614 636270 643411 652901 663483 663515 665277 665840 677039 680745 687500 701487 702455 712821 717860 722751 722851 724502 725399 727400 731014 732387 737169 738910 740138 744966 747976 760938 772142 774613 777859 781678 788290 788822 789660 790888 799402 808114 809361 814847 824345 824806 827919 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young massage"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.26%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young массаж"
]
|
||||||||||||||||||||||||||||||
|
1.20 ms (0.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young массаж"
]
|
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.