Query Metrics
7
Database Queries
7
Different statements
146.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.35 ms (79.62%) |
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 14806 53532 385137 408469 415870 415921 418213 422291 422524 422557 422602 422626 422640 422688 423264 423291 428977 429174 430392 430428 436358 437517 443116 445057 446874 447569 447904 448926 452532 456633 456639 458297 462573 466161 468557 468608 470334 476157 476818 480280 481806 481847 482151 486489 486620 491273 493126 496037 499843 502705 504564 508126 512177 513311 516436 518467 518472 519682 521177 521462 523757 523987 529047 529048 530018 530663 530709 531208 532798 533306 536681 537206 538361 540272 540313 540608 541586 541879 544475 545325 547061 550374 551226 551980 554287 558042 558049 558135 558410 562626 565255 565335 566034 566789 574297 575123 575423 576051 577515 582548 584134 584168 584797 595787 597263 598828 611933 633798 714444 721719 722535 724170 731549 732033 732420 741518 756819 758208 773683 805508 ] |
||||||||||||||||||||||||||||||
|
19.91 ms (13.63%) |
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 731549 741518 724170 758208 732033 732420 756819 773683 611933 714444 721719 722535 805508 456639 14806 470334 415870 458297 53532 422640 493126 512177 422688 422626 530663 531208 536681 530018 540608 530709 537206 541879 584168 562626 565255 633798 597263 598828 466161 446874 418213 518472 566789 436358 447904 456633 551226 558135 576051 554287 575123 595787 481847 448926 468608 518467 491273 523757 385137 415921 423291 428977 430392 430428 423264 429174 437517 408469 422524 443116 445057 422291 422557 422602 452532 462573 486489 476157 482151 486620 447569 468557 476818 481806 502705 504564 513311 523987 529047 532798 519682 521177 529048 496037 499843 521462 533306 538361 508126 516436 540272 540313 480280 544475 550374 558042 558049 565335 566034 574297 575423 577515 582548 584134 584797 541586 545325 547061 551980 558410 ] |
||||||||||||||||||||||||||||||
|
2.66 ms (1.82%) |
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 14806 53532 385137 408469 415870 415921 418213 422291 422524 422557 422602 422626 422640 422688 423264 423291 428977 429174 430392 430428 436358 437517 443116 445057 446874 447569 447904 448926 452532 456633 456639 458297 462573 466161 468557 468608 470334 476157 476818 480280 481806 481847 482151 486489 486620 491273 493126 496037 499843 502705 504564 508126 512177 513311 516436 518467 518472 519682 521177 521462 523757 523987 529047 529048 530018 530663 530709 531208 532798 533306 536681 537206 538361 540272 540313 540608 541586 541879 544475 545325 547061 550374 551226 551980 554287 558042 558049 558135 558410 562626 565255 565335 566034 566789 574297 575123 575423 576051 577515 582548 584134 584168 584797 595787 597263 598828 611933 633798 714444 721719 722535 724170 731549 732033 732420 741518 756819 758208 773683 805508 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"casting skinny"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кастинг худые"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.12%) |
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.