Query Metrics
7
Database Queries
7
Different statements
159.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.41 ms (82.36%) |
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 6937 177447 278428 350425 383408 384423 385563 394116 395460 395612 402777 402882 403663 404734 405725 406841 407293 408024 412066 413816 414085 419078 420064 427336 429043 429757 431918 433582 433781 438816 439899 444746 452126 453367 456302 456340 457877 457898 458513 458639 458872 459969 459973 459989 460620 460997 461101 463381 463562 463590 463595 465122 467942 469931 470121 471173 471386 473518 473532 476029 476110 476818 477973 478609 478861 480134 480895 482014 483336 483683 484520 489897 494378 495653 499012 507755 508947 514623 516915 517786 517905 521890 522524 522766 523700 524367 525676 526078 526770 527068 527107 528777 529087 530823 531668 531689 537794 551409 553751 554098 557657 561411 567706 581922 584466 585437 588037 601179 611181 618747 647983 730884 809410 811052 811076 818925 825142 ] |
||||||||||||||||||||||||||||||
|
17.16 ms (10.76%) |
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 809410 427336 460620 412066 471386 395612 406841 438816 494378 524367 483683 526078 527107 507755 517786 825142 818925 531689 530823 531668 537794 730884 413816 588037 429757 463562 459983 452126 405725 459987 508947 529087 495653 513753 514623 525676 528777 557657 567706 647983 554098 585437 601179 611181 478861 618747 383408 394116 395460 278428 350425 403663 419078 407293 431918 429043 433582 444746 473518 476110 480134 456340 459973 459989 461101 463595 482014 483336 489897 459969 463590 473532 476818 484520 499012 527068 553751 581922 551409 561411 584466 811052 811076 6937 177447 404734 408024 453367 470121 402882 414085 433781 458639 458872 384423 385563 420064 439899 465122 471173 477973 478609 402777 457877 457898 458513 460997 463381 469931 480895 456302 467942 476029 516915 517905 521890 522524 522766 523700 526770 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.82%) |
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 6937 177447 278428 350425 383408 384423 385563 394116 395460 395612 402777 402882 403663 404734 405725 406841 407293 408024 412066 413816 414085 419078 420064 427336 429043 429757 431918 433582 433781 438816 439899 444746 452126 453367 456302 456340 457877 457898 458513 458639 458872 459969 459973 459989 460620 460997 461101 463381 463562 463590 463595 465122 467942 469931 470121 471173 471386 473518 473532 476029 476110 476818 477973 478609 478861 480134 480895 482014 483336 483683 484520 489897 494378 495653 499012 507755 508947 514623 516915 517786 517905 521890 522524 522766 523700 524367 525676 526078 526770 527068 527107 528777 529087 530823 531668 531689 537794 551409 553751 554098 557657 561411 567706 581922 584466 585437 588037 601179 611181 618747 647983 730884 809410 811052 811076 818925 825142 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"спортивные с большой %…"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (1.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"спортивная большой большие"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.18%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.11%) |
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.