Query Metrics
7
Database Queries
7
Different statements
162.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.76 ms (82.97%) |
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 13492 66907 181252 231760 326944 367800 381871 383801 390012 391184 391644 391945 392019 397304 398461 404032 405056 405687 407627 409080 411734 411829 413520 414071 415579 416974 418746 419043 419326 419435 421850 421931 421976 422161 422193 424032 424048 424481 426384 426864 427076 429888 433297 435512 439677 443817 444413 446022 448793 449089 449622 450649 456589 459658 462911 462932 463235 464036 464408 465309 466384 469107 469276 470096 470617 470919 470989 471415 473143 474954 476138 476228 477337 478748 479985 480680 481873 482755 483472 484205 486188 486409 491111 492986 493042 493840 495481 496614 496726 500789 503828 504175 519360 522888 526216 528142 530308 533409 536923 538498 550137 560153 570782 570842 577372 578492 586917 588647 590633 605709 644271 680646 714476 744749 752767 800541 803146 805429 809648 814754 ] |
||||||||||||||||||||||||||||||
|
17.50 ms (10.78%) |
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 367800 66907 809648 397304 383801 231760 181252 390012 398461 405687 419326 456589 449089 464036 463235 474954 483472 419435 424048 473143 504175 486188 493042 326944 744749 433297 411829 448793 486409 590633 421850 439677 429888 422161 459658 800541 803146 450649 496726 422193 392019 391644 13492 391184 416974 415579 444413 435512 413520 421976 419043 462932 470989 462911 470096 470617 482755 538498 500789 496614 466384 469276 481873 550137 577372 578492 588647 605709 752767 409080 424032 424481 443817 464408 478748 407627 449622 471415 477337 480680 411734 418746 427076 404032 479985 426864 465309 469107 476228 519360 528142 536923 491111 533409 484205 522888 492986 495481 530308 570782 381871 405056 414071 426384 814754 493840 503828 526216 476138 570842 680646 714476 560153 644271 586917 805429 446022 470919 391945 421931 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (1.95%) |
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 13492 66907 181252 231760 326944 367800 381871 383801 390012 391184 391644 391945 392019 397304 398461 404032 405056 405687 407627 409080 411734 411829 413520 414071 415579 416974 418746 419043 419326 419435 421850 421931 421976 422161 422193 424032 424048 424481 426384 426864 427076 429888 433297 435512 439677 443817 444413 446022 448793 449089 449622 450649 456589 459658 462911 462932 463235 464036 464408 465309 466384 469107 469276 470096 470617 470919 470989 471415 473143 474954 476138 476228 477337 478748 479985 480680 481873 482755 483472 484205 486188 486409 491111 492986 493042 493840 495481 496614 496726 500789 503828 504175 519360 522888 526216 528142 530308 533409 536923 538498 550137 560153 570782 570842 577372 578492 586917 588647 590633 605709 644271 680646 714476 744749 752767 800541 803146 805429 809648 814754 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brunette mother"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"черноволосая мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (0.90%) |
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.