Query Metrics
7
Database Queries
7
Different statements
127.36 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2.10 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.07 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal sex fat"
]
|
||||||||||||||||||||||||||||||
| 3 | 18.38 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 680177 647935 602617 447750 804803 535439 526526 443807 525501 454585 404931 523197 723091 741539 523861 476352 429523 392754 451248 507291 447948 435391 543745 521367 473475 530110 474914 561021 677142 742651 530836 805638 454081 617116 724176 591349 415874 465552 482094 509988 644674 505130 535464 405485 544828 500896 486408 517722 680206 496802 444916 473205 650614 457428 466007 623933 457473 452284 413791 532701 467118 450281 455685 447888 515986 445868 518131 411189 601488 438772 581096 569132 453409 458051 615978 520413 493122 592651 583729 482808 597975 810663 522616 502793 451108 506269 616994 ] |
||||||||||||||||||||||||||||||
| 4 | 2.76 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 392754 404931 405485 411189 413791 415874 429523 435391 438772 443807 444916 445868 447750 447888 447948 450281 451108 451248 452284 453409 454081 454585 455685 457428 457473 458051 465552 466007 467118 473205 473475 474914 476352 482094 482808 486408 493122 496802 500896 502793 505130 506269 507291 509988 515986 517722 518131 520413 521367 522616 523197 523861 525501 526526 530110 530836 532701 535439 535464 543745 544828 561021 569132 581096 583729 591349 592651 597975 601488 602617 615978 616994 617116 623933 644674 647935 650614 677142 680177 680206 723091 724176 741539 742651 804803 805638 810663 ] |
||||||||||||||||||||||||||||||
| 5 | 97.94 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 392754 404931 405485 411189 413791 415874 429523 435391 438772 443807 444916 445868 447750 447888 447948 450281 451108 451248 452284 453409 454081 454585 455685 457428 457473 458051 465552 466007 467118 473205 473475 474914 476352 482094 482808 486408 493122 496802 500896 502793 505130 506269 507291 509988 515986 517722 518131 520413 521367 522616 523197 523861 525501 526526 530110 530836 532701 535439 535464 543745 544828 561021 569132 581096 583729 591349 592651 597975 601488 602617 615978 616994 617116 623933 644674 647935 650614 677142 680177 680206 723091 724176 741539 742651 804803 805638 810663 ] |
||||||||||||||||||||||||||||||
| 6 | 2.34 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал секс fat"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.76 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал секс fat"
]
|
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.