Query Metrics
7
Database Queries
7
Different statements
143.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.36 ms (82.01%) |
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 38313 153490 188337 191343 360336 366296 381951 382387 386367 388350 391045 394642 397406 397902 398901 402030 404113 407250 412941 413238 413391 414753 414799 415901 417040 418225 418895 419211 423128 423529 423540 423887 424612 425470 425552 425641 426798 429776 432430 432511 434531 443365 443665 443870 445221 446336 449605 450600 453947 454158 454168 457421 458308 458897 459629 460127 460491 460785 461428 461483 461557 461558 461671 461751 461851 462039 462771 463232 465535 465970 468020 468123 469609 470435 470712 471554 473591 473785 473803 474397 474489 475803 476274 477726 484905 484992 486269 487865 494561 494890 495129 496194 496882 499396 501036 501987 503794 504349 506221 508861 511312 513665 518401 522840 523185 523565 525452 534469 545993 557735 560974 561991 565433 575113 576363 578020 612256 664529 797354 801666 ] |
||||||||||||||||||||||||||||||
|
15.52 ms (10.85%) |
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 664529 801666 417040 424612 38313 191343 443665 454158 508861 494890 381951 578020 443365 486269 470435 188337 394642 360336 382387 397406 398901 402030 413238 423529 425552 432511 445221 425470 415901 449605 453947 460491 461671 468123 462771 471554 522840 460785 474397 545993 576363 565433 419211 462039 465535 473803 475803 407250 423128 461428 461483 153490 388350 429776 460127 461851 473591 412941 426798 461558 463232 470712 461557 506221 495129 494561 496194 366296 423540 450600 469609 575113 557735 414799 612256 432430 443870 459629 523185 434531 414753 386367 391045 425641 418225 413391 468020 534469 797354 404113 473785 461751 501987 499396 458308 503794 525452 501036 523565 513665 474489 454168 457421 476274 560974 561991 397902 423887 446336 458897 465970 477726 518401 484905 496882 511312 484992 487865 504349 418895 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.76%) |
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 38313 153490 188337 191343 360336 366296 381951 382387 386367 388350 391045 394642 397406 397902 398901 402030 404113 407250 412941 413238 413391 414753 414799 415901 417040 418225 418895 419211 423128 423529 423540 423887 424612 425470 425552 425641 426798 429776 432430 432511 434531 443365 443665 443870 445221 446336 449605 450600 453947 454158 454168 457421 458308 458897 459629 460127 460491 460785 461428 461483 461557 461558 461671 461751 461851 462039 462771 463232 465535 465970 468020 468123 469609 470435 470712 471554 473591 473785 473803 474397 474489 475803 476274 477726 484905 484992 486269 487865 494561 494890 495129 496194 496882 499396 501036 501987 503794 504349 506221 508861 511312 513665 518401 522840 523185 523565 525452 534469 545993 557735 560974 561991 565433 575113 576363 578020 612256 664529 797354 801666 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"любовник кончился в ж%…"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любовник сперм в"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.21%) |
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.