Query Metrics
7
Database Queries
7
Different statements
156.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.95 ms (83.21%) |
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 20617 21323 38857 324568 326944 379377 384433 388642 401816 405727 407156 407522 408988 411829 411880 415988 416297 420135 420202 428450 432687 439174 445596 457396 458844 467639 467955 469366 474465 478032 478427 480365 484363 492646 495121 495666 496112 499485 500674 510590 512184 512210 512212 515734 516430 519291 519437 531554 533499 535617 541598 542565 545484 546219 550642 550776 550991 551086 551969 551994 552042 552053 552897 552913 554432 554766 554790 554866 556363 557494 557514 557537 557823 558429 559852 559855 559897 562900 563310 565982 565993 565998 566015 566605 567321 575329 579347 579721 580266 583280 590966 592422 599820 600539 601081 606674 619199 621035 622266 622972 623513 623554 623599 636658 670526 697354 706373 712154 717298 767029 768164 774773 776911 810813 813226 815674 818148 819082 823636 828866 ] |
||||||||||||||||||||||||||||||
|
16.06 ms (10.28%) |
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 717298 408988 469366 557494 411829 379377 420135 324568 512184 767029 484363 458844 516430 499485 551969 550776 552897 559855 583280 621035 474465 557514 415988 407522 457396 495121 565982 445596 510590 388642 407156 420202 416297 38857 563310 819082 566015 554432 541598 818148 828866 535617 405727 492646 552042 712154 552913 622266 601081 823636 774773 623554 557537 432687 579721 810813 515734 590966 556363 559852 565993 566605 768164 478427 554866 542565 519437 428450 551086 575329 533499 496112 326944 554790 21323 411880 439174 495666 551994 580266 558429 579347 546219 670526 706373 545484 557823 599820 600539 623599 636658 776911 401816 512210 519291 384433 552053 559897 554766 562900 550642 565998 20617 512212 478032 567321 606674 619199 623513 467955 480365 500674 815674 697354 813226 467639 592422 531554 550991 622972 ] |
||||||||||||||||||||||||||||||
|
3.30 ms (2.11%) |
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 20617 21323 38857 324568 326944 379377 384433 388642 401816 405727 407156 407522 408988 411829 411880 415988 416297 420135 420202 428450 432687 439174 445596 457396 458844 467639 467955 469366 474465 478032 478427 480365 484363 492646 495121 495666 496112 499485 500674 510590 512184 512210 512212 515734 516430 519291 519437 531554 533499 535617 541598 542565 545484 546219 550642 550776 550991 551086 551969 551994 552042 552053 552897 552913 554432 554766 554790 554866 556363 557494 557514 557537 557823 558429 559852 559855 559897 562900 563310 565982 565993 565998 566015 566605 567321 575329 579347 579721 580266 583280 590966 592422 599820 600539 601081 606674 619199 621035 622266 622972 623513 623554 623599 636658 670526 697354 706373 712154 717298 767029 768164 774773 776911 810813 813226 815674 818148 819082 823636 828866 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mother asian"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин азиатк"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.96%) |
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.