Query Metrics
7
Database Queries
7
Different statements
179.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.64 ms (83.96%) |
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 154491 196431 202032 385589 386202 390242 397510 397911 401841 402094 403389 404946 422684 439079 441894 442015 447908 449091 456853 458887 458892 461219 464449 476439 479948 480481 483010 489786 492516 495335 496054 500311 504998 505176 507134 507370 507379 515230 515272 515282 516832 533991 548573 551031 551073 554217 554907 559289 560148 564432 570429 581190 582292 592501 593512 606842 607269 617176 617680 621870 622066 628331 641749 641755 648810 651611 655550 666763 673063 675510 675523 681012 682538 684177 688322 690100 690125 690294 694482 696082 696964 696970 696972 696977 696981 703512 704596 711745 713497 713557 716835 719852 721006 721942 723170 723677 724124 724855 729640 734868 739327 740595 742047 753064 758315 761621 780720 780796 781022 788572 790004 795355 797499 804689 807695 807733 808180 808183 810336 811774 ] |
||||||||||||||||||||||||||||||
|
17.39 ms (9.69%) |
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 559289 564432 570429 548573 581190 554907 648810 655550 666763 673063 675510 681012 684177 688322 690100 696082 696972 696977 696981 703512 704596 713497 719852 682538 690125 690294 694482 696964 696970 713557 721942 582292 593512 621870 622066 641749 641755 606842 592501 607269 617176 780720 780796 790004 811774 788572 797499 810336 723677 739327 742047 753064 807695 808180 761621 734868 724124 724855 729640 740595 758315 617680 628331 711745 723170 781022 795355 804689 807733 808183 402094 456853 403389 449091 404946 439079 476439 397510 401841 504998 495335 496054 507134 422684 480481 651611 675523 716835 721006 397911 390242 515272 507370 385589 386202 196431 202032 154491 441894 442015 458887 458892 461219 479948 483010 492516 447908 464449 489786 507379 515230 516832 505176 533991 500311 515282 551031 551073 554217 560148 ] |
||||||||||||||||||||||||||||||
|
3.79 ms (2.12%) |
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 154491 196431 202032 385589 386202 390242 397510 397911 401841 402094 403389 404946 422684 439079 441894 442015 447908 449091 456853 458887 458892 461219 464449 476439 479948 480481 483010 489786 492516 495335 496054 500311 504998 505176 507134 507370 507379 515230 515272 515282 516832 533991 548573 551031 551073 554217 554907 559289 560148 564432 570429 581190 582292 592501 593512 606842 607269 617176 617680 621870 622066 628331 641749 641755 648810 651611 655550 666763 673063 675510 675523 681012 682538 684177 688322 690100 690125 690294 694482 696082 696964 696970 696972 696977 696981 703512 704596 711745 713497 713557 716835 719852 721006 721942 723170 723677 724124 724855 729640 734868 739327 740595 742047 753064 758315 761621 780720 780796 781022 788572 790004 795355 797499 804689 807695 807733 808180 808183 810336 811774 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"medical exam"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"медицин exam"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"медицин exam"
]
|
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.