Query Metrics
7
Database Queries
7
Different statements
144.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.41 ms (80.73%) |
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 395394 419912 428387 428406 432899 441017 442390 442439 443587 444343 444972 445184 445607 448574 451441 452443 455210 455822 455840 456798 458199 461221 462170 465745 466073 466490 466727 470339 470350 471400 471503 471517 471548 472127 473790 473799 475181 475223 475556 476544 477456 480759 482226 482256 483805 484760 486116 486134 486953 487144 492705 493284 495302 495326 496864 496865 496870 499795 499970 500600 501227 502000 504769 506258 506562 513520 513521 514045 515816 516754 516902 517626 520299 521914 521916 522197 522540 524573 525892 526777 527074 529497 540794 541109 541193 542526 544040 546374 551267 551448 552616 553949 556422 557592 557596 558210 562806 565400 567089 569532 572198 572385 584990 590829 590860 592408 592417 598186 598921 603744 605913 607321 608553 618230 619186 619508 619522 624843 626428 663789 ] |
||||||||||||||||||||||||||||||
|
18.87 ms (13.08%) |
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 486134 506258 515816 521916 475556 471517 484760 513520 461221 442390 465745 558210 482256 458199 443587 502000 456798 455840 487144 476544 495302 475181 546374 562806 567089 444343 516902 514045 395394 444972 445607 473790 525892 500600 516754 480759 542526 541193 544040 557596 569532 572198 541109 663789 565400 592417 626428 598186 590860 619522 603744 451441 475223 472127 471503 428387 471548 477456 499970 496864 524573 492705 486116 486953 495326 513521 572385 432899 455822 470350 520299 499795 522197 522540 482226 442439 473799 471400 428406 441017 462170 470339 501227 521914 452443 556422 557592 506562 552616 445184 527074 466490 493284 624843 590829 592408 598921 619508 455210 496865 517626 540794 448574 419912 526777 483805 551267 605913 504769 584990 553949 551448 607321 618230 466727 466073 496870 529497 608553 619186 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (1.64%) |
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 395394 419912 428387 428406 432899 441017 442390 442439 443587 444343 444972 445184 445607 448574 451441 452443 455210 455822 455840 456798 458199 461221 462170 465745 466073 466490 466727 470339 470350 471400 471503 471517 471548 472127 473790 473799 475181 475223 475556 476544 477456 480759 482226 482256 483805 484760 486116 486134 486953 487144 492705 493284 495302 495326 496864 496865 496870 499795 499970 500600 501227 502000 504769 506258 506562 513520 513521 514045 515816 516754 516902 517626 520299 521914 521916 522197 522540 524573 525892 526777 527074 529497 540794 541109 541193 542526 544040 546374 551267 551448 552616 553949 556422 557592 557596 558210 562806 565400 567089 569532 572198 572385 584990 590829 590860 592408 592417 598186 598921 603744 605913 607321 608553 618230 619186 619508 619522 624843 626428 663789 ] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur pickup"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск пикап"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск пикап"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.08%) |
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.