Query Metrics
7
Database Queries
7
Different statements
201.73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
175.31 ms (86.90%) |
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 28294 152157 305892 387941 401440 418628 423384 428374 428582 430742 430815 431002 445086 448396 457195 459443 461253 463212 468961 473865 476335 476780 479200 481327 481963 483092 486823 495472 500266 505073 506314 507354 512816 513709 521466 521826 522165 524487 525865 526429 526636 528689 528773 528907 529349 531016 531483 531599 532065 532348 532510 534124 538991 544525 545304 545609 546510 548383 549485 550574 553852 554549 554782 554793 556247 556673 557144 557467 558017 558318 558794 559000 559558 561081 563906 569142 570036 572136 573428 573724 577814 581619 581825 584774 585697 586172 586680 587576 588151 590987 591286 593053 594195 595363 595828 596272 597171 597922 602417 603031 603160 606921 607353 607376 608827 623835 626283 636219 637492 641481 655406 655689 665205 667226 667497 669589 678966 681393 684335 685447 ] |
||||||||||||||||||||||||||||||
|
15.75 ms (7.81%) |
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 596272 448396 526636 573428 581619 678966 636219 431002 152157 418628 428374 401440 463212 481963 305892 681393 606921 549485 512816 525865 538991 528773 534124 532510 524487 479200 548383 544525 554782 557144 559558 561081 685447 667226 545304 558017 608827 585697 637492 591286 430815 468961 500266 506314 528907 577814 553852 476335 513709 28294 532065 507354 521466 573724 554549 669589 593053 457195 486823 569142 558794 597171 428582 529349 531016 570036 572136 684335 655406 655689 546510 550574 586172 603160 461253 430742 459443 473865 483092 481327 521826 603031 607353 387941 528689 532348 476780 526429 495472 522165 505073 584774 558318 563906 665205 556673 557467 590987 623835 597922 595828 531483 531599 554793 556247 559000 581825 667497 607376 594195 587576 641481 602417 588151 545609 586680 595363 626283 445086 423384 ] |
||||||||||||||||||||||||||||||
|
4.21 ms (2.09%) |
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 28294 152157 305892 387941 401440 418628 423384 428374 428582 430742 430815 431002 445086 448396 457195 459443 461253 463212 468961 473865 476335 476780 479200 481327 481963 483092 486823 495472 500266 505073 506314 507354 512816 513709 521466 521826 522165 524487 525865 526429 526636 528689 528773 528907 529349 531016 531483 531599 532065 532348 532510 534124 538991 544525 545304 545609 546510 548383 549485 550574 553852 554549 554782 554793 556247 556673 557144 557467 558017 558318 558794 559000 559558 561081 563906 569142 570036 572136 573428 573724 577814 581619 581825 584774 585697 586172 586680 587576 588151 590987 591286 593053 594195 595363 595828 596272 597171 597922 602417 603031 603160 606921 607353 607376 608827 623835 626283 636219 637492 641481 655406 655689 665205 667226 667497 669589 678966 681393 684335 685447 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пирсинг большие сиськ…"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пирсинг большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.72%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.69%) |
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.