Query Metrics
7
Database Queries
7
Different statements
146.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.61 ms (82.99%) |
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 7178 11160 11330 188389 325863 359084 379559 382692 385034 388738 388740 389726 395276 401465 401621 401935 403965 406563 406566 409877 409946 411345 415292 415342 419566 419636 421939 422185 423299 425657 430002 432679 433143 433183 441207 443199 444558 445930 453735 457891 462386 463934 464157 464247 464929 465522 465550 465958 467146 468434 469294 475904 476142 476352 478413 478643 479821 482314 482633 484242 485136 485311 485646 486192 490423 490535 490886 491639 492523 493658 493684 493758 496565 497516 498447 499617 500796 511431 513114 519233 522614 526074 532763 544163 546763 564731 580712 586644 604331 606384 637430 639755 649859 657159 670753 673767 687211 693208 693356 698496 698554 707307 713486 715522 716805 720808 721562 721693 725142 728443 746689 748935 759873 770949 784170 794533 799650 807353 812941 823240 ] |
||||||||||||||||||||||||||||||
|
15.10 ms (10.31%) |
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 693356 385034 401465 464247 720808 715522 411345 401935 406563 430002 490886 532763 698554 687211 721562 422185 721693 415342 482314 401621 478643 484242 498447 409946 468434 479821 485646 493684 464929 482633 485311 564731 580712 807353 379559 7178 441207 453735 499617 522614 513114 486192 409877 445930 423299 725142 359084 433183 465958 467146 433143 389726 476352 403965 425657 432679 476142 463934 493658 478413 485136 493758 511431 465522 544163 415292 465550 490535 491639 419566 444558 546763 419636 462386 11160 188389 490423 606384 388740 670753 519233 443199 382692 693208 794533 812941 325863 388738 673767 759873 657159 526074 823240 713486 649859 639755 637430 799650 746689 770949 748935 698496 707307 11330 784170 421939 475904 457891 469294 496565 497516 586644 604331 464157 395276 406566 492523 500796 728443 716805 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (1.71%) |
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 7178 11160 11330 188389 325863 359084 379559 382692 385034 388738 388740 389726 395276 401465 401621 401935 403965 406563 406566 409877 409946 411345 415292 415342 419566 419636 421939 422185 423299 425657 430002 432679 433143 433183 441207 443199 444558 445930 453735 457891 462386 463934 464157 464247 464929 465522 465550 465958 467146 468434 469294 475904 476142 476352 478413 478643 479821 482314 482633 484242 485136 485311 485646 486192 490423 490535 490886 491639 492523 493658 493684 493758 496565 497516 498447 499617 500796 511431 513114 519233 522614 526074 532763 544163 546763 564731 580712 586644 604331 606384 637430 639755 649859 657159 670753 673767 687211 693208 693356 698496 698554 707307 713486 715522 716805 720808 721562 721693 725142 728443 746689 748935 759873 770949 784170 794533 799650 807353 812941 823240 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big mother anal"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие мам женщин анал"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (1.12%) |
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.