Query Metrics
7
Database Queries
7
Different statements
163.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.82 ms (84.10%) |
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 383888 392787 395142 395427 395699 398243 399518 400511 403003 407710 411914 413112 414153 415598 418905 421821 421838 421858 421877 422165 424032 424118 428547 428556 428804 428809 428822 428844 428852 429528 435382 437322 439802 439809 442415 442418 443180 443182 443183 443185 446277 446284 446306 446622 448955 449232 450147 452391 453260 455298 455307 457301 458012 458018 459251 459254 460156 460177 460273 460641 461374 462082 462110 464382 464403 464423 464440 464446 464556 464559 465366 467012 467304 470995 471627 472164 472166 472295 474794 477104 484052 486896 493195 505973 513115 513366 513722 513784 513852 518267 518859 521391 522602 523836 523838 523849 524267 524289 524876 526226 526323 527158 528390 531923 532004 532056 532062 534722 535050 542957 544103 548864 549823 549832 549848 562517 576995 600651 716324 720602 ] |
||||||||||||||||||||||||||||||
|
15.01 ms (9.16%) |
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 716324 720602 428844 446284 428804 459254 428822 437322 392787 400511 526323 422165 600651 403003 428547 464403 484052 472166 472295 513852 535050 472164 424032 421877 424118 439809 415598 477104 455307 518267 523849 524876 523836 526226 505973 518859 521391 421821 448955 513722 493195 549848 421838 523838 549823 549832 439802 421858 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 513115 524267 532056 462110 467012 544103 548864 562517 576995 542957 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.84%) |
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 383888 392787 395142 395427 395699 398243 399518 400511 403003 407710 411914 413112 414153 415598 418905 421821 421838 421858 421877 422165 424032 424118 428547 428556 428804 428809 428822 428844 428852 429528 435382 437322 439802 439809 442415 442418 443180 443182 443183 443185 446277 446284 446306 446622 448955 449232 450147 452391 453260 455298 455307 457301 458012 458018 459251 459254 460156 460177 460273 460641 461374 462082 462110 464382 464403 464423 464440 464446 464556 464559 465366 467012 467304 470995 471627 472164 472166 472295 474794 477104 484052 486896 493195 505973 513115 513366 513722 513784 513852 518267 518859 521391 522602 523836 523838 523849 524267 524289 524876 526226 526323 527158 528390 531923 532004 532056 532062 534722 535050 542957 544103 548864 549823 549832 549848 562517 576995 600651 716324 720602 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп son"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass son"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие жоп son"
]
|
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.