Query Metrics
7
Database Queries
7
Different statements
386.59 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
359.70 ms (93.05%) |
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 389264 396329 401626 420320 421881 421939 422046 422834 423123 435792 447403 448951 451513 451932 452114 455176 455180 455316 455836 457275 457459 457663 462569 463021 463306 464611 465346 466148 469799 474401 474950 474999 480916 482263 483606 484057 486964 488978 489984 490182 490453 490644 491415 496289 498425 499857 499951 502027 502191 505986 507047 507235 507245 507801 511878 512378 513503 514445 515641 515717 515757 516835 517258 518354 518842 519610 521243 522452 522623 523379 523660 524384 524637 525043 526129 527766 528528 533636 535414 535436 536938 540694 548596 549830 552256 563007 565322 565366 565494 565673 566566 566709 567139 567910 568724 568822 569581 571057 572771 573375 583729 585671 586180 590329 590573 596823 599177 603812 604894 605913 610628 613934 614991 618008 621020 624150 657775 658952 659564 661547 ] |
||||||||||||||||||||||||||||||
|
16.09 ms (4.16%) |
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 447403 457663 463021 474950 464611 469799 499951 502027 519610 533636 483606 491415 505986 512378 515757 517258 526129 527766 484057 522623 535414 540694 490644 499857 507801 514445 516835 523660 396329 422834 420320 455176 463306 474999 488978 489984 566709 552256 565494 567910 568724 590573 421939 422046 455316 401626 421881 389264 455180 451932 455836 518842 524637 496289 502191 511878 522452 498425 513503 535436 448951 457275 462569 569581 423123 474401 451513 482263 480916 457459 465346 466148 518354 521243 507245 507047 525043 515641 571057 621020 618008 452114 536938 486964 490453 523379 528528 657775 549830 524384 490182 515717 566566 568822 586180 604894 610628 590329 614991 435792 507235 548596 563007 565322 565366 565673 567139 572771 573375 658952 661547 659564 583729 605913 596823 603812 624150 585671 599177 613934 ] |
||||||||||||||||||||||||||||||
|
2.54 ms (0.66%) |
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 389264 396329 401626 420320 421881 421939 422046 422834 423123 435792 447403 448951 451513 451932 452114 455176 455180 455316 455836 457275 457459 457663 462569 463021 463306 464611 465346 466148 469799 474401 474950 474999 480916 482263 483606 484057 486964 488978 489984 490182 490453 490644 491415 496289 498425 499857 499951 502027 502191 505986 507047 507235 507245 507801 511878 512378 513503 514445 515641 515717 515757 516835 517258 518354 518842 519610 521243 522452 522623 523379 523660 524384 524637 525043 526129 527766 528528 533636 535414 535436 536938 540694 548596 549830 552256 563007 565322 565366 565494 565673 566566 566709 567139 567910 568724 568822 569581 571057 572771 573375 583729 585671 586180 590329 590573 596823 599177 603812 604894 605913 610628 613934 614991 618008 621020 624150 657775 658952 659564 661547 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (0.57%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"нагнул"
]
|
||||||||||||||||||||||||||||||
|
2.13 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"нагнул"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (0.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"нагнул"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.49%) |
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.