Query Metrics
7
Database Queries
7
Different statements
158.01 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.36 ms (81.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 263299 383888 392787 395142 395427 395699 398243 399518 400511 407710 411731 411914 413112 413128 414153 418905 421829 421838 421842 421855 422182 424274 425450 428556 428809 428852 429528 435382 442415 442418 443180 443182 443183 443185 443722 446269 446277 446306 446622 448145 449232 450147 452391 453260 455298 457301 458012 458018 459251 460156 460177 460273 460641 461374 462082 462110 463563 464189 464382 464423 464440 464446 464556 464559 465209 465366 467012 467304 470995 471627 474794 486896 496108 513115 513366 513784 515911 516485 516829 522602 523838 524267 524289 526323 526521 527158 528390 531923 532004 532056 532062 534722 542957 544103 548864 549833 549847 550223 552299 554897 557924 561378 562517 563142 563148 565012 565625 576995 579209 609825 633535 662140 663772 663929 663969 665233 714062 739940 782503 793784 ] |
||||||||||||||||||||||||||||||
|
17.33 ms (10.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 392787 400511 413128 526323 411731 782503 739940 633535 793784 421829 421838 421855 523838 526521 263299 446269 465209 448145 515911 463563 557924 549847 563148 565625 609825 464189 421842 424274 425450 422182 443722 516485 516829 383888 395142 395699 395427 398243 399518 428809 428852 429528 411914 414153 407710 442418 413112 428556 435382 442415 443182 443183 443185 418905 443180 450147 452391 453260 462082 464382 465366 470995 474794 446622 455298 459251 460156 461374 464440 464446 464556 464559 467304 486896 446277 446306 449232 457301 458012 458018 460177 460273 460641 464423 471627 513366 513784 522602 524289 532004 532062 534722 528390 527158 531923 496108 513115 524267 532056 462110 467012 544103 548864 562517 576995 542957 552299 554897 579209 549833 550223 561378 563142 565012 663929 665233 714062 662140 663772 663969 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.82%) |
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 263299 383888 392787 395142 395427 395699 398243 399518 400511 407710 411731 411914 413112 413128 414153 418905 421829 421838 421842 421855 422182 424274 425450 428556 428809 428852 429528 435382 442415 442418 443180 443182 443183 443185 443722 446269 446277 446306 446622 448145 449232 450147 452391 453260 455298 457301 458012 458018 459251 460156 460177 460273 460641 461374 462082 462110 463563 464189 464382 464423 464440 464446 464556 464559 465209 465366 467012 467304 470995 471627 474794 486896 496108 513115 513366 513784 515911 516485 516829 522602 523838 524267 524289 526323 526521 527158 528390 531923 532004 532056 532062 534722 542957 544103 548864 549833 549847 550223 552299 554897 557924 561378 562517 563142 563148 565012 565625 576995 579209 609825 633535 662140 663772 663929 663969 665233 714062 739940 782503 793784 ] |
||||||||||||||||||||||||||||||
|
2.34 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass son"
]
|
||||||||||||||||||||||||||||||
|
2.30 ms (1.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп son"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.21%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп son"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.