Query Metrics
7
Database Queries
7
Different statements
157.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
130.98 ms (83.34%) |
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 78307 156688 383107 386514 396115 411219 415858 418064 423426 431488 433566 445751 445946 448040 448987 450219 456265 458742 459593 459655 460194 460691 461124 461516 461545 465930 466322 467617 472172 472349 477467 478260 478325 478526 478534 479814 480831 481664 482120 485996 487025 487086 491535 491637 491671 495715 500463 502086 508881 511720 511743 511746 512239 512242 512297 512335 516161 516270 517604 518756 519927 520185 522590 540530 542056 552783 560464 560476 574746 574758 574765 574843 574871 575148 575757 575806 576408 603179 603623 605520 606690 624650 630916 654575 654583 655094 655110 655715 656453 656696 656965 656988 657315 657352 657375 657608 657697 658646 658713 660523 661333 663430 663456 663863 663952 668440 678967 681893 721219 731326 732892 745844 747919 755447 802067 807725 812305 817122 819747 823562 ] |
||||||||||||||||||||||||||||||
|
15.72 ms (10.00%) |
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 386514 460691 663952 445751 491637 491535 575757 681893 603179 605520 732892 78307 472349 433566 480831 411219 512242 745844 755447 383107 819747 540530 656696 657315 657697 663430 663863 654583 657375 721219 654575 655715 657608 658713 668440 624650 747919 478534 500463 485996 552783 678967 802067 731326 630916 481664 450219 482120 478526 479814 518756 516270 396115 418064 423426 431488 477467 445946 448040 461124 517604 511720 478325 560476 576408 574746 560464 574871 663456 574843 575148 606690 807725 458742 156688 459655 460194 466322 478260 415858 456265 459593 461516 461545 465930 467617 472172 511743 511746 520185 522590 487086 512335 516161 487025 495715 508881 512297 491671 512239 448987 542056 575806 603623 519927 817122 823562 661333 660523 812305 502086 574758 574765 656988 658646 655094 655110 657352 656453 656965 ] |
||||||||||||||||||||||||||||||
|
3.23 ms (2.06%) |
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 78307 156688 383107 386514 396115 411219 415858 418064 423426 431488 433566 445751 445946 448040 448987 450219 456265 458742 459593 459655 460194 460691 461124 461516 461545 465930 466322 467617 472172 472349 477467 478260 478325 478526 478534 479814 480831 481664 482120 485996 487025 487086 491535 491637 491671 495715 500463 502086 508881 511720 511743 511746 512239 512242 512297 512335 516161 516270 517604 518756 519927 520185 522590 540530 542056 552783 560464 560476 574746 574758 574765 574843 574871 575148 575757 575806 576408 603179 603623 605520 606690 624650 630916 654575 654583 655094 655110 655715 656453 656696 656965 656988 657315 657352 657375 657608 657697 658646 658713 660523 661333 663430 663456 663863 663952 668440 678967 681893 721219 731326 732892 745844 747919 755447 802067 807725 812305 817122 819747 823562 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.27%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cuckold licking"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"куколд лиза"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.06%) |
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.