Query Metrics
7
Database Queries
7
Different statements
190.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.00 ms (88.23%) |
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 396361 401958 404388 415430 429200 432316 449347 454725 457815 461208 461209 463231 463332 463781 464186 468015 477066 478803 479920 481129 483027 484543 486518 487618 490639 492182 492278 492651 493034 493283 494959 495208 495497 498097 498890 499715 504998 510391 511279 513921 514468 517488 525128 526064 527523 528598 528950 528965 529045 529507 531683 535944 536118 538586 539855 549296 554725 556131 556573 556603 563711 563736 567305 568621 571050 572678 572704 575326 576462 577614 577762 577767 579672 580118 581641 581677 581694 582894 587547 587575 588889 589722 591036 591556 592052 595674 595967 596144 601097 603109 605755 607798 610132 610974 623677 626431 632984 647605 653678 653697 664562 666024 666688 668952 669250 671085 674041 681881 685767 692712 695913 699449 729930 732139 738255 749516 757955 772483 785674 810489 ] |
||||||||||||||||||||||||||||||
|
13.20 ms (6.93%) |
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 449347 464186 477066 490639 492278 457815 525128 538586 511279 535944 514468 527523 495208 513921 526064 531683 481129 493034 567305 576462 577762 579672 554725 556131 572704 575326 577767 563711 572678 699449 681881 647605 669250 556603 581677 587547 626431 588889 591556 596144 603109 610974 591036 785674 810489 772483 738255 749516 729930 732139 757955 632984 401958 404388 461208 463332 478803 468015 510391 528965 504998 529507 396361 463781 454725 493283 487618 549296 415430 479920 483027 499715 571050 666024 432316 429200 484543 461209 492651 486518 498097 528598 539855 498890 517488 529045 528950 494959 495497 536118 463231 492182 577614 580118 581641 563736 581694 582894 556573 568621 668952 671085 692712 653678 664562 666688 685767 695913 653697 674041 595674 595967 605755 592052 601097 623677 587575 589722 607798 610132 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.58%) |
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 396361 401958 404388 415430 429200 432316 449347 454725 457815 461208 461209 463231 463332 463781 464186 468015 477066 478803 479920 481129 483027 484543 486518 487618 490639 492182 492278 492651 493034 493283 494959 495208 495497 498097 498890 499715 504998 510391 511279 513921 514468 517488 525128 526064 527523 528598 528950 528965 529045 529507 531683 535944 536118 538586 539855 549296 554725 556131 556573 556603 563711 563736 567305 568621 571050 572678 572704 575326 576462 577614 577762 577767 579672 580118 581641 581677 581694 582894 587547 587575 588889 589722 591036 591556 592052 595674 595967 596144 601097 603109 605755 607798 610132 610974 623677 626431 632984 647605 653678 653697 664562 666024 666688 668952 669250 671085 674041 681881 685767 692712 695913 699449 729930 732139 738255 749516 757955 772483 785674 810489 ] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teens hairy"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.85%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teens волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.83%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.70%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teens волосатая"
]
|
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.