Query Metrics
7
Database Queries
7
Different statements
143.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.36 ms (82.98%) |
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 7170 96461 388091 389315 389409 390680 396753 400940 401580 409452 410940 413404 429764 442035 447851 452608 453352 461086 468176 468622 476649 490304 496465 502732 514069 517840 522130 522133 527412 530387 530663 531177 531261 532792 532948 533371 535597 536215 536399 536616 536681 536686 537206 540291 540404 540608 542975 549092 565102 565247 565250 565255 571192 587761 589042 595977 613456 626021 628376 628392 633782 633806 634122 634158 645980 647879 649148 649579 649615 650174 650325 650762 653447 662022 666897 670096 670719 673361 674515 675179 675809 677798 677801 677986 678067 678073 679445 683259 685013 689525 689642 689949 691984 692324 692438 695278 695280 702164 703070 703098 703586 705119 709684 710056 713023 715750 718327 720836 721412 721417 722648 727850 775776 775896 776994 818938 824421 825442 827915 ] |
||||||||||||||||||||||||||||||
|
14.34 ms (9.97%) |
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 727850 613456 703070 709684 775896 776994 389409 396753 530387 531177 540404 678067 683259 677801 666897 565247 628376 628392 633806 775776 390680 429764 452608 447851 490304 530663 533371 536681 540291 522130 532792 540608 522133 531261 532948 536215 535597 536616 536686 537206 468622 542975 565250 565255 647879 720836 649579 650174 650325 650762 653447 677986 678073 702164 677798 565102 634158 595977 634122 633782 453352 400940 410940 461086 476649 514069 527412 502732 713023 7170 96461 389315 388091 401580 442035 409452 413404 825442 818938 824421 827915 517840 536399 496465 468176 549092 571192 670719 689642 691984 692324 692438 695280 703098 703586 715750 649148 649615 670096 673361 674515 675179 675809 685013 705119 722648 645980 662022 679445 689525 689949 695278 710056 718327 721412 721417 587761 588719 626021 589042 ] |
||||||||||||||||||||||||||||||
|
2.38 ms (1.66%) |
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 7170 96461 388091 389315 389409 390680 396753 400940 401580 409452 410940 413404 429764 442035 447851 452608 453352 461086 468176 468622 476649 490304 496465 502732 514069 517840 522130 522133 527412 530387 530663 531177 531261 532792 532948 533371 535597 536215 536399 536616 536681 536686 537206 540291 540404 540608 542975 549092 565102 565247 565250 565255 571192 587761 589042 595977 613456 626021 628376 628392 633782 633806 634122 634158 645980 647879 649148 649579 649615 650174 650325 650762 653447 662022 666897 670096 670719 673361 674515 675179 675809 677798 677801 677986 678067 678073 679445 683259 685013 689525 689642 689949 691984 692324 692438 695278 695280 702164 703070 703098 703586 705119 709684 710056 713023 715750 718327 720836 721412 721417 722648 727850 775776 775896 776994 818938 824421 825442 827915 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (1.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"double penetration teens"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.34%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"double penetration teens"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"double penetration 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.