Query Metrics
7
Database Queries
7
Different statements
165.63 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.49 ms (83.01%) |
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 8497 40051 148101 270386 304572 304698 381871 384133 390070 394355 395603 397207 401766 405174 405485 405690 406030 406566 407867 409021 410346 412378 413184 413216 414621 419128 420547 421043 423698 428432 430446 430602 433188 446002 449760 450226 452156 452193 452274 454084 455088 464302 464659 465812 466958 468667 468829 469513 472944 473954 475258 476136 477875 478074 479851 480510 481820 485130 485160 486253 487435 488549 491938 493899 495384 504102 510976 511141 512063 513203 514024 515611 519085 519578 520711 522867 524257 531423 544125 544299 557747 559881 560076 561134 562829 567743 568546 571194 575688 576622 586644 588624 592872 598115 601653 620219 628322 660431 672406 681085 705382 714868 736408 742763 743780 747312 758276 769683 770930 777361 777581 781326 784312 789485 793523 797734 798365 803327 805110 813393 ] |
||||||||||||||||||||||||||||||
|
16.87 ms (10.19%) |
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 781326 304572 304698 567743 468829 576622 407867 446002 449760 520711 485160 519085 8497 477875 784312 598115 493899 430602 452193 559881 575688 620219 747312 758276 742763 769683 413216 466958 660431 681085 777581 797734 805110 777361 473954 513203 390070 452274 423698 412378 514024 487435 714868 397207 406030 469513 568546 562829 586644 410346 480510 409021 479851 406566 481820 485130 488549 401766 464302 571194 486253 405485 430446 491938 524257 40051 628322 420547 395603 544125 557747 270386 472944 413184 381871 464659 601653 478074 515611 495384 544299 798365 803327 736408 770930 743780 428432 512063 531423 510976 405690 672406 414621 394355 384133 588624 592872 813393 405174 789485 705382 793523 148101 433188 560076 561134 476136 454084 465812 450226 419128 452156 455088 475258 421043 468667 504102 522867 519578 511141 ] |
||||||||||||||||||||||||||||||
|
3.78 ms (2.28%) |
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 8497 40051 148101 270386 304572 304698 381871 384133 390070 394355 395603 397207 401766 405174 405485 405690 406030 406566 407867 409021 410346 412378 413184 413216 414621 419128 420547 421043 423698 428432 430446 430602 433188 446002 449760 450226 452156 452193 452274 454084 455088 464302 464659 465812 466958 468667 468829 469513 472944 473954 475258 476136 477875 478074 479851 480510 481820 485130 485160 486253 487435 488549 491938 493899 495384 504102 510976 511141 512063 513203 514024 515611 519085 519578 520711 522867 524257 531423 544125 544299 557747 559881 560076 561134 562829 567743 568546 571194 575688 576622 586644 588624 592872 598115 601653 620219 628322 660431 672406 681085 705382 714868 736408 742763 743780 747312 758276 769683 770930 777361 777581 781326 784312 789485 793523 797734 798365 803327 805110 813393 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"красивые мамочка"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"красивая мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.00%) |
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.