Query Metrics
7
Database Queries
7
Different statements
224.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
199.15 ms (88.65%) |
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 414138 423655 427241 427970 428280 429012 430884 431020 431829 434371 437523 438464 444487 446548 447072 451257 457176 457349 457758 457968 457974 457975 458308 459198 461185 464994 465058 469507 469569 469966 469985 470017 470449 472743 475272 475338 478471 482140 482315 482936 482938 482999 483005 484891 491299 493896 494151 494171 494419 500571 502348 504614 504807 510160 512512 512895 514248 515363 517315 519701 521110 521353 522000 522907 522910 524949 528921 528925 536819 537377 537899 538267 543337 544563 544964 549130 550884 552585 561951 565265 565800 567723 568038 570899 571257 573188 575676 578290 578401 579869 580160 580180 587527 604732 605474 619177 621482 621760 629607 629893 632084 636288 666983 705785 710767 716496 724209 728820 755030 762159 763398 766590 773257 786463 788132 788268 792554 792555 792558 ] |
||||||||||||||||||||||||||||||
|
16.26 ms (7.24%) |
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 573188 565265 580160 587527 595376 619177 604732 763398 755030 457974 482315 414138 469966 459198 515363 522000 536819 491299 502348 514248 438464 428280 444487 446548 457176 458308 482999 457968 457975 465058 482140 561951 578290 549130 565800 666983 544964 550884 629607 792555 762159 773257 728820 469985 427970 434371 461185 469569 470017 478471 504614 517315 521353 528921 521110 528925 512895 537377 431829 482936 494151 494419 716496 621482 522907 493896 500571 538267 537899 632084 470449 423655 475272 483005 510160 724209 451257 464994 543337 552585 705785 792554 621760 786463 522910 429012 427241 447072 494171 475338 482938 567723 568038 710767 605474 636288 788132 437523 472743 484891 504807 430884 431020 524949 512512 519701 469507 570899 578401 579869 580180 544563 575676 571257 766590 629893 788268 792558 457349 457758 ] |
||||||||||||||||||||||||||||||
|
2.96 ms (1.32%) |
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 414138 423655 427241 427970 428280 429012 430884 431020 431829 434371 437523 438464 444487 446548 447072 451257 457176 457349 457758 457968 457974 457975 458308 459198 461185 464994 465058 469507 469569 469966 469985 470017 470449 472743 475272 475338 478471 482140 482315 482936 482938 482999 483005 484891 491299 493896 494151 494171 494419 500571 502348 504614 504807 510160 512512 512895 514248 515363 517315 519701 521110 521353 522000 522907 522910 524949 528921 528925 536819 537377 537899 538267 543337 544563 544964 549130 550884 552585 561951 565265 565800 567723 568038 570899 571257 573188 575676 578290 578401 579869 580160 580180 587527 604732 605474 619177 621482 621760 629607 629893 632084 636288 666983 705785 710767 716496 724209 728820 755030 762159 763398 766590 773257 786463 788132 788268 792554 792555 792558 ] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.73%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"games секс"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.73%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"games секс"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"games sex"
]
|
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.