Query Metrics
7
Database Queries
7
Different statements
355.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
204.75 ms (57.61%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
123.94 ms (34.87%) |
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 383961 406377 411814 411838 415148 422525 422529 422566 422572 422625 422631 422894 422896 423007 423026 428577 429116 430239 432122 443301 443467 445269 446793 449135 451531 451890 452068 452221 452434 452441 455908 457164 458302 458992 459202 461747 463846 463862 463920 463963 464256 465351 465819 466177 467142 467166 467380 468473 468597 468638 468647 468703 469550 471777 472431 473094 474656 475451 475799 475828 475981 477074 478052 478933 480293 480295 480415 483734 485355 486424 486426 490139 491518 491566 492111 495214 495267 496724 497517 499774 503418 504376 505106 507005 507649 513289 513704 517778 518032 518771 519002 519249 520421 521128 522628 522844 523389 523705 525100 525681 525956 526841 528761 530532 530632 532644 533522 537893 541324 554428 562068 585143 585210 593975 603493 604160 625003 645004 653547 723580 ] |
||||||||||||||||||||||||||||||
|
18.84 ms (5.30%) |
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 422529 463920 465819 466177 477074 383961 467380 429116 458302 459202 465351 480415 430239 446793 468473 468597 468638 471777 520421 522844 491566 513704 518032 518771 521128 523705 491518 495214 497517 519002 525956 485355 486424 496724 507649 526841 603493 532644 519249 428577 486426 653547 604160 585210 593975 523389 504376 499774 562068 625003 475828 492111 406377 422631 423007 422625 422894 422896 415148 422566 432122 422525 422572 443301 445269 411814 411838 423026 443467 585143 723580 645004 452221 458992 463846 463862 463963 467166 475451 475981 478933 449135 451531 452068 452434 455908 468647 469550 475799 480293 451890 452441 457164 461747 467142 468703 473094 474656 478052 490139 525681 528761 522628 530632 537893 495267 513289 517778 530532 503418 505106 507005 525100 533522 464256 472431 480295 483734 541324 554428 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (0.70%) |
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 383961 406377 411814 411838 415148 422525 422529 422566 422572 422625 422631 422894 422896 423007 423026 428577 429116 430239 432122 443301 443467 445269 446793 449135 451531 451890 452068 452221 452434 452441 455908 457164 458302 458992 459202 461747 463846 463862 463920 463963 464256 465351 465819 466177 467142 467166 467380 468473 468597 468638 468647 468703 469550 471777 472431 473094 474656 475451 475799 475828 475981 477074 478052 478933 480293 480295 480415 483734 485355 486424 486426 490139 491518 491566 492111 495214 495267 496724 497517 499774 503418 504376 505106 507005 507649 513289 513704 517778 518032 518771 519002 519249 520421 521128 522628 522844 523389 523705 525100 525681 525956 526841 528761 530532 530632 532644 533522 537893 541324 554428 562068 585143 585210 593975 603493 604160 625003 645004 653547 723580 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"кастинг мужчины"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.53%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"кастинг мужчин"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.42%) |
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.