Query Metrics
7
Database Queries
7
Different statements
145.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.84 ms (83.63%) |
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 373724 392498 397080 397568 412790 412830 413685 416689 419832 421437 428033 428177 428305 429323 434491 435421 436080 440045 443916 447159 447703 452777 452847 453822 455494 456190 456214 461713 464837 466098 468348 470471 475784 476786 479662 480206 485919 486841 505387 523751 537959 573493 592425 598360 602858 604199 604211 604291 609267 610220 610905 611003 612683 613435 615058 617034 626575 627332 630039 631070 632094 636671 638194 639137 640126 643612 655142 656291 656538 656576 657186 666378 668086 671854 677147 679171 680259 681198 684482 695380 698226 707164 711094 715652 717469 720080 720283 724129 725009 733713 734922 737117 737525 749202 752752 761115 761484 764963 765064 768867 773419 773421 778938 783035 783714 787714 788435 788899 790468 791607 805046 810314 810387 810407 824069 825733 826572 827632 827721 ] |
||||||||||||||||||||||||||||||
|
13.90 ms (9.54%) |
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 768867 720283 778938 783035 783714 810407 724129 626575 826572 827721 765064 790468 435421 761484 428033 475784 824069 397080 825733 734922 737525 715652 788899 479662 434491 447703 447159 461713 464837 480206 443916 476786 455494 466098 486841 671854 373724 749202 737117 761115 397568 429323 452847 453822 412830 456214 428305 436080 485919 523751 805046 717469 537959 657186 668086 680259 695380 656538 656576 679171 711094 681198 684482 698226 707164 610220 611003 613435 631070 604199 604211 639137 640126 610905 615058 617034 598360 602858 627332 773421 609267 630039 632094 638194 573493 612683 643612 725009 720080 604291 655142 666378 656291 636671 592425 721975 788435 764963 791607 827632 787714 810314 773419 752752 810387 733713 392498 413685 416689 421437 428177 452777 468348 470471 505387 677147 412790 456190 419832 440045 ] |
||||||||||||||||||||||||||||||
|
2.64 ms (1.81%) |
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 373724 392498 397080 397568 412790 412830 413685 416689 419832 421437 428033 428177 428305 429323 434491 435421 436080 440045 443916 447159 447703 452777 452847 453822 455494 456190 456214 461713 464837 466098 468348 470471 475784 476786 479662 480206 485919 486841 505387 523751 537959 573493 592425 598360 602858 604199 604211 604291 609267 610220 610905 611003 612683 613435 615058 617034 626575 627332 630039 631070 632094 636671 638194 639137 640126 643612 655142 656291 656538 656576 657186 666378 668086 671854 677147 679171 680259 681198 684482 695380 698226 707164 711094 715652 717469 720080 720283 724129 725009 733713 734922 737117 737525 749202 752752 761115 761484 764963 765064 768867 773419 773421 778938 783035 783714 787714 788435 788899 790468 791607 805046 810314 810387 810407 824069 825733 826572 827632 827721 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade webcam anal"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск вебкамер анал"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.13%) |
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.