Query Metrics
7
Database Queries
7
Different statements
188.61 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.90 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.13 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"table pussy"
]
|
||||||||||||||||||||||||||||||
| 3 | 19.47 ms |
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 579617 185861 411686 488283 500118 523716 500852 526488 552502 720985 662880 663474 565602 565750 575701 581938 588268 788909 807481 790481 764206 727934 742313 731201 602227 463435 402926 447542 461586 461581 406701 521473 525251 489021 498865 506420 525562 526513 185834 459098 458844 496361 505631 522258 552533 561852 573383 566765 581949 653247 545507 548697 782008 644397 443974 471521 514467 488653 489597 498882 512260 512269 485453 498671 494039 428681 454950 512608 518483 573445 584403 556121 558645 574504 586486 799060 428890 466309 389623 438809 466130 447548 526877 496965 438058 407015 585140 575550 663399 424013 437988 503389 512257 490274 577365 567429 721646 548755 462872 496874 431117 598441 455922 440569 588329 522690 598161 ] |
||||||||||||||||||||||||||||||
| 4 | 2.46 ms |
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 185834 185861 389623 402926 406701 407015 411686 424013 428681 428890 431117 437988 438058 438809 440569 443974 447542 447548 454950 455922 458844 459098 461581 461586 462872 463435 466130 466309 471521 485453 488283 488653 489021 489597 490274 494039 496361 496874 496965 498671 498865 498882 500118 500852 503389 505631 506420 512257 512260 512269 512608 514467 518483 521473 522258 522690 523716 525251 525562 526488 526513 526877 545507 548697 548755 552502 552533 556121 558645 561852 565602 565750 566765 567429 573383 573445 574504 575550 575701 577365 579617 581938 581949 584403 585140 586486 588268 588329 598161 598441 602227 644397 653247 662880 663399 663474 720985 721646 727934 731201 742313 764206 782008 788909 790481 799060 807481 ] |
||||||||||||||||||||||||||||||
| 5 | 158.69 ms |
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 185834 185861 389623 402926 406701 407015 411686 424013 428681 428890 431117 437988 438058 438809 440569 443974 447542 447548 454950 455922 458844 459098 461581 461586 462872 463435 466130 466309 471521 485453 488283 488653 489021 489597 490274 494039 496361 496874 496965 498671 498865 498882 500118 500852 503389 505631 506420 512257 512260 512269 512608 514467 518483 521473 522258 522690 523716 525251 525562 526488 526513 526877 545507 548697 548755 552502 552533 556121 558645 561852 565602 565750 566765 567429 573383 573445 574504 575550 575701 577365 579617 581938 581949 584403 585140 586486 588268 588329 598161 598441 602227 644397 653247 662880 663399 663474 720985 721646 727934 731201 742313 764206 782008 788909 790481 799060 807481 ] |
||||||||||||||||||||||||||||||
| 6 | 1.93 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"table pussy"
]
|
||||||||||||||||||||||||||||||
| 7 | 2.03 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"table pussy"
]
|
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.