Query Metrics
7
Database Queries
7
Different statements
177.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
153.99 ms (86.59%) |
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 406390 415635 421761 429764 430132 430290 430400 437687 443094 443231 445038 445726 446972 448628 452201 452269 458624 459527 465218 468031 468490 468530 471409 471601 474772 475286 476296 478488 479858 480432 482797 483497 491271 492330 494359 494361 495725 499894 501589 512728 514113 514618 514710 517896 518467 519465 521580 522701 523133 523190 529188 530792 530850 531200 531657 532245 533196 534151 534387 536870 537498 537663 537912 537936 540508 540572 542212 542818 543548 543867 556428 557248 559293 575845 576009 585573 589060 589551 591623 601544 603475 604021 604575 607527 612855 617411 627811 630550 631074 632978 633764 634115 634543 637077 641999 642781 645284 645322 646427 647972 649137 650192 651627 651647 666819 666869 666895 671354 674968 676073 676095 676636 680202 702058 720340 741527 742244 745174 758876 761040 ] |
||||||||||||||||||||||||||||||
|
14.12 ms (7.94%) |
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 585573 589551 604575 612855 591623 601544 631074 637077 642781 741527 742244 758876 761040 745174 603475 627811 633764 641999 468530 471601 415635 430132 448628 471409 512728 514710 491271 494359 514618 517896 483497 634543 523190 540572 532245 537663 534387 666895 674968 645284 646427 647972 651647 666819 676636 630550 634115 607527 617411 589060 604021 632978 459527 514113 429764 443094 480432 518467 406390 421761 430290 443231 445038 430400 437687 482797 445726 452269 478488 446972 458624 468031 475286 492330 452201 465218 468490 479858 495725 499894 523133 531200 522701 529188 519465 521580 530850 531657 533196 536870 537498 494361 501589 530792 534151 537912 537936 540508 474772 476296 543548 557248 575845 542212 542818 543867 556428 559293 576009 645322 650192 676073 680202 702058 720340 649137 651627 666869 671354 676095 ] |
||||||||||||||||||||||||||||||
|
2.57 ms (1.45%) |
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 406390 415635 421761 429764 430132 430290 430400 437687 443094 443231 445038 445726 446972 448628 452201 452269 458624 459527 465218 468031 468490 468530 471409 471601 474772 475286 476296 478488 479858 480432 482797 483497 491271 492330 494359 494361 495725 499894 501589 512728 514113 514618 514710 517896 518467 519465 521580 522701 523133 523190 529188 530792 530850 531200 531657 532245 533196 534151 534387 536870 537498 537663 537912 537936 540508 540572 542212 542818 543548 543867 556428 557248 559293 575845 576009 585573 589060 589551 591623 601544 603475 604021 604575 607527 612855 617411 627811 630550 631074 632978 633764 634115 634543 637077 641999 642781 645284 645322 646427 647972 649137 650192 651627 651647 666819 666869 666895 671354 674968 676073 676095 676636 680202 702058 720340 741527 742244 745174 758876 761040 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bbc casting"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (0.90%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"bbc кастинг"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.77%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"bbc кастинг"
]
|
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.