Query Metrics
7
Database Queries
7
Different statements
146.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.88 ms (80.35%) |
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 188269 413033 414375 419475 420336 420604 421691 436770 441466 442186 442556 444316 445243 449883 450472 451469 452838 454262 454392 456766 456980 460067 460115 460120 460784 461613 462531 465079 468267 472063 473395 473457 475119 475544 477797 481654 482061 482790 486399 486422 486672 490704 491450 495259 497026 498038 498054 504001 505202 507217 507561 508221 508778 512205 512505 513061 513084 513536 513538 514279 515226 515786 515836 517094 517961 519061 519547 519785 519948 519949 522000 524341 524607 525369 526087 527089 529477 538281 544865 549643 552978 555118 555968 555970 563146 573175 573486 576616 580391 583677 584168 586494 586503 593238 593275 593299 593348 593359 593363 593368 593413 593485 593529 593532 593536 599414 601634 604923 607618 615925 625171 641130 644567 647964 648817 653407 675537 688332 717860 814749 ] |
||||||||||||||||||||||||||||||
|
18.25 ms (12.44%) |
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 450472 451469 456980 460784 465079 460120 475544 482061 468267 505202 513538 517961 522000 486422 504001 508778 527089 507217 517094 524607 490704 491450 507561 514279 515786 515836 519785 441466 436770 814749 475119 449883 460115 452838 454392 472063 477797 512205 513084 513536 519948 508221 544865 552978 563146 717860 647964 653407 555970 576616 580391 593299 593485 593532 593536 604923 644567 593368 593359 599414 615925 601634 607618 625171 641130 442186 445243 454262 481654 188269 420336 456766 461613 414375 420604 421691 473395 519949 525369 486672 519547 497026 495259 529477 444316 473457 482790 519061 524341 549643 584168 573175 555968 688332 555118 593238 593348 593363 593529 593275 593413 586494 586503 413033 419475 442556 462531 460067 512505 513061 526087 486399 515226 498038 538281 498054 573486 583677 675537 648817 ] |
||||||||||||||||||||||||||||||
|
3.40 ms (2.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 188269 413033 414375 419475 420336 420604 421691 436770 441466 442186 442556 444316 445243 449883 450472 451469 452838 454262 454392 456766 456980 460067 460115 460120 460784 461613 462531 465079 468267 472063 473395 473457 475119 475544 477797 481654 482061 482790 486399 486422 486672 490704 491450 495259 497026 498038 498054 504001 505202 507217 507561 508221 508778 512205 512505 513061 513084 513536 513538 514279 515226 515786 515836 517094 517961 519061 519547 519785 519948 519949 522000 524341 524607 525369 526087 527089 529477 538281 544865 549643 552978 555118 555968 555970 563146 573175 573486 576616 580391 583677 584168 586494 586503 593238 593275 593299 593348 593359 593363 593368 593413 593485 593529 593532 593536 599414 601634 604923 607618 615925 625171 641130 644567 647964 648817 653407 675537 688332 717860 814749 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"nurse 2009"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"врачих"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (1.06%) |
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.