Query Metrics
7
Database Queries
7
Different statements
162.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.87 ms (82.88%) |
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 415834 418440 420517 423685 423732 430066 430103 435244 443492 443572 443944 449398 449821 455329 455687 455787 456695 456779 458457 459557 459717 460421 460450 460988 463000 467402 468119 470317 470868 471480 476216 477000 477034 481083 484065 488776 492321 492459 495319 496851 499194 499734 500292 501015 502257 504614 504765 508522 508938 511012 511514 511677 512427 513568 514262 514781 516889 516969 518096 518607 520161 521150 522734 522995 523029 524509 527003 535447 539280 540747 544206 546030 546994 552067 552407 556680 558863 559532 559930 561155 561931 567503 567910 568404 571235 571724 572333 573296 573391 576959 577583 578835 584672 589074 589972 595192 595852 599187 601894 602199 603384 604286 606017 607377 610552 616315 618718 620739 620783 639460 677108 681399 709723 736564 748695 752704 761201 784871 809523 810119 ] |
||||||||||||||||||||||||||||||
|
17.08 ms (10.50%) |
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 576959 546994 552067 573296 573391 709723 556680 578835 589972 595852 601894 604286 809523 810119 752704 481083 415834 459557 430066 455687 518607 522995 496851 511012 523029 524509 495319 423732 430103 435244 443492 520161 501015 508938 516969 522734 492321 544206 577583 567503 561155 552407 602199 599187 761201 784871 455787 460421 443944 460450 459717 460988 477000 449821 500292 504614 488776 502257 511677 499194 514262 514781 618718 748695 681399 559930 420517 470317 607377 477034 504765 558863 559532 568404 571724 571235 561931 606017 616315 620783 620739 458457 467402 470868 499734 535447 736564 677108 418440 443572 471480 455329 492459 484065 567910 584672 546030 603384 589074 610552 595192 423685 449398 456779 476216 463000 539280 508522 513568 516889 540747 512427 511514 527003 639460 518096 572333 468119 456695 521150 ] |
||||||||||||||||||||||||||||||
|
3.29 ms (2.02%) |
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 415834 418440 420517 423685 423732 430066 430103 435244 443492 443572 443944 449398 449821 455329 455687 455787 456695 456779 458457 459557 459717 460421 460450 460988 463000 467402 468119 470317 470868 471480 476216 477000 477034 481083 484065 488776 492321 492459 495319 496851 499194 499734 500292 501015 502257 504614 504765 508522 508938 511012 511514 511677 512427 513568 514262 514781 516889 516969 518096 518607 520161 521150 522734 522995 523029 524509 527003 535447 539280 540747 544206 546030 546994 552067 552407 556680 558863 559532 559930 561155 561931 567503 567910 568404 571235 571724 572333 573296 573391 576959 577583 578835 584672 589074 589972 595192 595852 599187 601894 602199 603384 604286 606017 607377 610552 616315 618718 620739 620783 639460 677108 681399 709723 736564 748695 752704 761201 784871 809523 810119 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade little"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск little"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск little"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.04%) |
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.