Query Metrics
7
Database Queries
7
Different statements
152.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.90 ms (83.80%) |
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 396275 397616 400422 401232 408326 418197 419407 420910 423482 427282 428920 435244 435498 443205 443300 443492 443619 443944 446328 446353 446932 448924 449821 451706 451753 455687 455787 457186 457972 459557 459717 460988 463071 464874 465293 465924 467460 477000 477776 479468 480201 480437 480523 482391 484009 485287 485414 486648 488776 488852 490758 491595 491828 493349 496376 496454 499194 500392 502257 504722 506595 510851 511012 515178 515199 516969 518607 520161 522734 522995 523760 523766 523788 525460 527203 527592 528234 529492 536089 536115 549048 554245 556519 559664 561313 569549 577583 588258 595852 597258 602504 605420 615063 617865 619389 624184 624273 630576 646219 649730 652131 655188 655275 658224 684701 693897 698708 711555 713727 715116 718683 720441 731064 737161 738679 747451 778671 809523 810119 814253 ] |
||||||||||||||||||||||||||||||
|
15.71 ms (10.29%) |
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 624273 443300 464874 630576 467460 496376 397616 713727 718683 658224 720441 615063 400422 418197 491595 446932 684701 569549 443205 522734 655188 778671 577583 814253 554245 488852 443944 460988 427282 479468 559664 549048 693897 711555 737161 496454 491828 649730 624184 602504 480523 480201 652131 738679 506595 465293 527203 529492 477776 561313 747451 484009 528234 459557 455687 408326 809523 515199 715116 619389 588258 617865 518607 502257 465924 428920 446328 490758 455787 435498 556519 605420 731064 698708 446353 485287 488776 435244 493349 423482 597258 396275 401232 420910 480437 457972 486648 595852 419407 520161 525460 477000 500392 504722 646219 443492 451753 527592 463071 448924 522995 499194 536115 443619 523760 523788 485414 810119 457186 536089 655275 451706 516969 523766 459717 510851 482391 515178 449821 511012 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.63%) |
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 396275 397616 400422 401232 408326 418197 419407 420910 423482 427282 428920 435244 435498 443205 443300 443492 443619 443944 446328 446353 446932 448924 449821 451706 451753 455687 455787 457186 457972 459557 459717 460988 463071 464874 465293 465924 467460 477000 477776 479468 480201 480437 480523 482391 484009 485287 485414 486648 488776 488852 490758 491595 491828 493349 496376 496454 499194 500392 502257 504722 506595 510851 511012 515178 515199 516969 518607 520161 522734 522995 523760 523766 523788 525460 527203 527592 528234 529492 536089 536115 549048 554245 556519 559664 561313 569549 577583 588258 595852 597258 602504 605420 615063 617865 619389 624184 624273 630576 646219 649730 652131 655188 655275 658224 684701 693897 698708 711555 713727 715116 718683 720441 731064 737161 738679 747451 778671 809523 810119 814253 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"little dick fuck"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"little член секс"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"little член секс"
]
|
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.