Query Metrics
7
Database Queries
7
Different statements
174.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.45 ms (85.07%) |
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 73322 88220 107651 121057 191237 346141 382301 382610 383287 387055 388729 389355 391289 396370 401858 411985 413140 419525 423199 423956 427113 428109 428160 432449 432531 432562 437174 439482 439597 439797 441806 444179 448072 449596 452447 453102 455605 458008 458662 461731 464708 467525 469324 471113 475296 479195 482519 488476 488964 489268 490883 501374 509261 512500 512894 513204 515621 516156 521166 528529 533346 541749 541823 544484 546767 550827 552493 556502 556690 565837 567213 567548 591051 593405 595572 598617 599879 603373 603384 604923 606702 610532 618415 641043 646191 651664 664290 665305 666107 678896 679369 696376 713188 716201 717504 721670 725355 726829 729886 730702 736159 737811 743891 745806 755315 778782 780788 785877 785932 788848 789790 795135 804218 805913 808668 814478 824270 824450 826613 ] |
||||||||||||||||||||||||||||||
|
15.23 ms (8.73%) |
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 432449 501374 482519 512500 432531 467525 391289 401858 423956 814478 824270 805913 736159 479195 603384 824450 828081 595572 449596 550827 428160 726829 455605 546767 382301 419525 427113 513204 191237 528529 716201 678896 696376 780788 743891 785877 745806 788848 441806 593405 469324 387055 512894 713188 795135 804218 826613 646191 721670 396370 541749 591051 448072 439797 521166 666107 533346 471113 383287 121057 382610 411985 437174 737811 423199 490883 428109 413140 541823 556690 458662 515621 475296 489268 665305 606702 641043 778782 730702 725355 755315 346141 73322 388729 389355 444179 488476 544484 565837 651664 679369 664290 717504 618415 603373 610532 598617 599879 785932 789790 729886 88220 107651 439482 567213 452447 461731 509261 552493 567548 556502 604923 464708 439597 458008 808668 453102 432562 488964 516156 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.60%) |
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 73322 88220 107651 121057 191237 346141 382301 382610 383287 387055 388729 389355 391289 396370 401858 411985 413140 419525 423199 423956 427113 428109 428160 432449 432531 432562 437174 439482 439597 439797 441806 444179 448072 449596 452447 453102 455605 458008 458662 461731 464708 467525 469324 471113 475296 479195 482519 488476 488964 489268 490883 501374 509261 512500 512894 513204 515621 516156 521166 528529 533346 541749 541823 544484 546767 550827 552493 556502 556690 565837 567213 567548 591051 593405 595572 598617 599879 603373 603384 604923 606702 610532 618415 641043 646191 651664 664290 665305 666107 678896 679369 696376 713188 716201 717504 721670 725355 726829 729886 730702 736159 737811 743891 745806 755315 778782 780788 785877 785932 788848 789790 795135 804218 805913 808668 814478 824270 824450 826613 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"stockings tits"
]
|
||||||||||||||||||||||||||||||
|
2.16 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"чулк нижн бел сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.04%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.