Query Metrics
7
Database Queries
7
Different statements
179.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.24 ms (83.22%) |
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 430436 437470 443480 522142 530010 530028 530376 530489 530491 530533 530633 530709 530789 531109 531116 531173 531230 531257 532172 532741 532852 532960 533519 533926 533949 534627 534995 535006 535048 536249 536562 536579 536586 536588 536610 536618 536621 536650 537200 537206 537763 537771 537908 540404 540405 540434 540518 540577 541197 541846 544803 544812 545383 545441 545608 550194 565243 565249 582217 582323 587013 588301 590411 599915 600185 600312 600321 600355 601150 617428 624175 627807 628366 628390 630522 630526 631178 632614 632645 632979 633756 636304 637434 639717 639748 640797 642002 642658 642751 644962 645238 646242 646450 646771 646786 647320 647340 647663 647879 648816 648841 650330 666874 666904 670758 674952 676014 676090 677781 678127 678493 679016 680185 680203 683261 687257 696579 703831 703833 733840 ] |
||||||||||||||||||||||||||||||
|
19.34 ms (10.78%) |
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 535006 536249 536588 540577 530028 530376 534995 540405 540518 545441 582323 541846 541197 545608 550194 646242 666904 674952 676090 677781 678493 679016 680185 687257 696579 646450 646771 648816 648841 670758 676014 678127 680203 683261 703831 646786 647340 650330 582217 599915 600185 630522 642002 642658 587013 588301 590411 600312 600321 633756 600355 601150 628366 628390 632614 632979 636304 642751 624175 630526 632645 637434 639748 640797 733840 617428 627807 631178 639717 703833 430436 437470 522142 443480 644962 530010 530491 530533 531230 531257 533519 533926 534627 535048 536562 536610 536618 537763 537771 537908 540434 530489 530633 532741 532960 533949 536579 536586 536621 530709 531109 531116 531173 532172 532852 536650 530789 537200 537206 540404 545383 565243 565249 544803 544812 645238 647320 647663 647879 666874 ] |
||||||||||||||||||||||||||||||
|
3.41 ms (1.90%) |
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 430436 437470 443480 522142 530010 530028 530376 530489 530491 530533 530633 530709 530789 531109 531116 531173 531230 531257 532172 532741 532852 532960 533519 533926 533949 534627 534995 535006 535048 536249 536562 536579 536586 536588 536610 536618 536621 536650 537200 537206 537763 537771 537908 540404 540405 540434 540518 540577 541197 541846 544803 544812 545383 545441 545608 550194 565243 565249 582217 582323 587013 588301 590411 599915 600185 600312 600321 600355 601150 617428 624175 627807 628366 628390 630522 630526 631178 632614 632645 632979 633756 636304 637434 639717 639748 640797 642002 642658 642751 644962 645238 646242 646450 646771 646786 647320 647340 647663 647879 648816 648841 650330 666874 666904 670758 674952 676014 676090 677781 678127 678493 679016 680185 680203 683261 687257 696579 703831 703833 733840 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"group anal casting"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.03%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"group анал кастинг"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"group анал кастинг"
]
|
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.