Query Metrics
7
Database Queries
7
Different statements
207.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.87 ms (83.37%) |
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 194224 327786 383347 384878 389234 390542 400947 401817 420467 423261 424742 426334 426746 430333 432995 433758 433768 435239 437949 440830 441935 449657 452731 453110 457008 458509 458960 459542 461808 463314 463445 464992 466390 466690 467102 472362 472643 472921 473335 478577 480278 480700 481029 483086 484393 484910 489556 491133 492400 492623 495950 496418 498175 499418 499517 501357 502288 504343 505109 506737 509901 510903 511500 512647 513507 514018 514461 514763 514780 515668 519791 519852 520117 520119 520164 521092 522587 524783 524981 525605 525746 526809 527176 527300 528756 532026 533644 538123 539820 539825 542920 543535 549653 551095 554373 559615 562532 564813 565709 565961 571741 574418 574425 584126 596429 603135 615712 617827 669763 680202 683380 687270 693020 694010 697263 773327 786255 799615 799645 800350 ] |
||||||||||||||||||||||||||||||
|
17.16 ms (8.27%) |
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 389234 400947 424742 432995 435239 441935 457008 453110 480278 492623 466390 478577 492400 510903 539820 539825 519852 525605 538123 495950 502288 514461 520164 463314 565709 549653 543535 551095 554373 574418 683380 694010 697263 559615 562532 584126 596429 603135 617827 786255 773327 799615 800350 615712 799645 327786 383347 433768 459542 464992 466690 473335 194224 426334 437949 458960 480700 384878 401817 426746 433758 449657 463445 481029 420467 461808 472362 512647 526809 483086 484393 498175 499418 499517 501357 505109 509901 513507 515668 524981 528756 514780 520117 520119 521092 522587 527300 496418 506737 514018 514763 519791 527176 390542 423261 430333 440830 484910 489556 458509 452731 472643 524783 525746 533644 504343 511500 532026 467102 472921 491133 542920 574425 564813 565961 669763 680202 687270 693020 571741 ] |
||||||||||||||||||||||||||||||
|
10.03 ms (4.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.29%) |
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 194224 327786 383347 384878 389234 390542 400947 401817 420467 423261 424742 426334 426746 430333 432995 433758 433768 435239 437949 440830 441935 449657 452731 453110 457008 458509 458960 459542 461808 463314 463445 464992 466390 466690 467102 472362 472643 472921 473335 478577 480278 480700 481029 483086 484393 484910 489556 491133 492400 492623 495950 496418 498175 499418 499517 501357 502288 504343 505109 506737 509901 510903 511500 512647 513507 514018 514461 514763 514780 515668 519791 519852 520117 520119 520164 521092 522587 524783 524981 525605 525746 526809 527176 527300 528756 532026 533644 538123 539820 539825 542920 543535 549653 551095 554373 559615 562532 564813 565709 565961 571741 574418 574425 584126 596429 603135 615712 617827 669763 680202 683380 687270 693020 694010 697263 773327 786255 799615 799645 800350 ] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"семьях"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сем"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.63%) |
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.