Query Metrics
7
Database Queries
7
Different statements
209.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
179.97 ms (85.74%) |
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 145288 326017 365875 388878 389798 391683 396808 398655 399966 401226 407146 408179 413161 417850 420593 421867 432834 439635 439791 439856 444917 446293 449360 450220 453155 453230 453242 453453 455378 455406 455428 456967 457444 458692 458730 458942 459946 460258 461989 462100 462140 464679 469034 470772 475269 479027 485754 490001 490454 499323 500046 502600 505622 508522 509414 510590 511778 513032 513393 514374 514681 518016 518158 518980 519151 521932 522987 523729 523850 525843 526176 527731 529160 531063 533889 544834 545492 550640 552071 552493 555995 558883 559960 561345 561455 567436 574433 578678 581306 586398 588802 590987 591052 591512 599010 630083 639788 644344 668645 697002 709257 711685 725458 726546 726712 736137 759724 784681 790874 790882 796105 797756 803428 809502 810297 810986 814933 822767 823016 827921 ] |
||||||||||||||||||||||||||||||
|
18.67 ms (8.90%) |
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 711685 552071 561455 590987 591052 599010 639788 796105 784681 736137 725458 726546 697002 797756 803428 365875 455406 455428 450220 514374 449360 389798 545492 790882 790874 809502 388878 458942 417850 559960 396808 822767 827921 459946 446293 458730 522987 401226 461989 462140 509414 511778 521932 408179 453230 518980 525843 518016 558883 581306 709257 567436 439635 326017 399966 505622 510590 529160 455378 814933 464679 531063 462100 550640 555995 578678 726712 759724 810297 810986 413161 561345 668645 453242 460258 544834 591512 523729 407146 453155 475269 500046 502600 514681 513032 518158 526176 456967 479027 458692 519151 490454 513393 490001 499323 527731 391683 533889 432834 485754 552493 574433 586398 453453 469034 508522 644344 823016 398655 588802 630083 457444 470772 420593 439856 421867 439791 444917 523850 145288 ] |
||||||||||||||||||||||||||||||
|
3.51 ms (1.67%) |
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 145288 326017 365875 388878 389798 391683 396808 398655 399966 401226 407146 408179 413161 417850 420593 421867 432834 439635 439791 439856 444917 446293 449360 450220 453155 453230 453242 453453 455378 455406 455428 456967 457444 458692 458730 458942 459946 460258 461989 462100 462140 464679 469034 470772 475269 479027 485754 490001 490454 499323 500046 502600 505622 508522 509414 510590 511778 513032 513393 514374 514681 518016 518158 518980 519151 521932 522987 523729 523850 525843 526176 527731 529160 531063 533889 544834 545492 550640 552071 552493 555995 558883 559960 561345 561455 567436 574433 578678 581306 586398 588802 590987 591052 591512 599010 630083 639788 644344 668645 697002 709257 711685 725458 726546 726712 736137 759724 784681 790874 790882 796105 797756 803428 809502 810297 810986 814933 822767 823016 827921 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"kitchen big boobs"
]
|
||||||||||||||||||||||||||||||
|
2.11 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кухн большие boobs"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"кухн большие boobs"
]
|
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.