Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`

[]

SELECT
  `lang_id`,
  `code`,
  `name`,
  `icon`
FROM
  `lang`

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`;

SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1

[
  "assfuck big cock"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 'assfuck big cock' LIMIT 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  592370
  819215
  692485
  712728
  735546
  718948
  593821
  604186
  637173
  609866
  531283
  727837
  14477
  671389
  719376
  604262
  604287
  604349
  790963
  777008
  565344
  759955
  508203
  720651
  464353
  591888
  604373
  720796
  533673
  464705
  464903
  454625
  720421
  561033
  590078
  593620
  604425
  604184
  810905
  420241
  491573
  389771
  468385
  554830
  461556
  520007
  483561
  575744
  579821
  674081
  594467
  604669
  558700
  571133
  590839
  470095
  550672
  464717
  576114
  579799
  604330
  604251
  604357
  510803
  799146
  414089
  454647
  596565
  477588
  526055
  476476
  460879
  461456
  525044
  519251
  678159
  443529
  556778
  541379
  541419
  649134
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?
  )

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`=1 LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=2 WHERE p.post_id IN (592370, 819215, 692485, 712728, 735546, 718948, 593821, 604186, 637173, 609866, 531283, 727837, 14477, 671389, 719376, 604262, 604287, 604349, 790963, 777008, 565344, 759955, 508203, 720651, 464353, 591888, 604373, 720796, 533673, 464705, 464903, 454625, 720421, 561033, 590078, 593620, 604425, 604184, 810905, 420241, 491573, 389771, 468385, 554830, 461556, 520007, 483561, 575744, 579821, 674081, 594467, 604669, 558700, 571133, 590839, 470095, 550672, 464717, 576114, 579799, 604330, 604251, 604357, 510803, 799146, 414089, 454647, 596565, 477588, 526055, 476476, 460879, 461456, 525044, 519251, 678159, 443529, 556778, 541379, 541419, 649134);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  14477
  389771
  414089
  420241
  443529
  454625
  454647
  460879
  461456
  461556
  464353
  464705
  464717
  464903
  468385
  470095
  476476
  477588
  483561
  491573
  508203
  510803
  519251
  520007
  525044
  526055
  531283
  533673
  541379
  541419
  550672
  554830
  556778
  558700
  561033
  565344
  571133
  575744
  576114
  579799
  579821
  590078
  590839
  591888
  592370
  593620
  593821
  594467
  596565
  604184
  604186
  604251
  604262
  604287
  604330
  604349
  604357
  604373
  604425
  604669
  609866
  637173
  649134
  671389
  674081
  678159
  692485
  712728
  718948
  719376
  720421
  720651
  720796
  727837
  735546
  759955
  777008
  790963
  799146
  810905
  819215
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?
  )

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=1 LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=2 WHERE pht.post_id IN (14477, 389771, 414089, 420241, 443529, 454625, 454647, 460879, 461456, 461556, 464353, 464705, 464717, 464903, 468385, 470095, 476476, 477588, 483561, 491573, 508203, 510803, 519251, 520007, 525044, 526055, 531283, 533673, 541379, 541419, 550672, 554830, 556778, 558700, 561033, 565344, 571133, 575744, 576114, 579799, 579821, 590078, 590839, 591888, 592370, 593620, 593821, 594467, 596565, 604184, 604186, 604251, 604262, 604287, 604330, 604349, 604357, 604373, 604425, 604669, 609866, 637173, 649134, 671389, 674081, 678159, 692485, 712728, 718948, 719376, 720421, 720651, 720796, 727837, 735546, 759955, 777008, 790963, 799146, 810905, 819215);

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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  14477
  389771
  414089
  420241
  443529
  454625
  454647
  460879
  461456
  461556
  464353
  464705
  464717
  464903
  468385
  470095
  476476
  477588
  483561
  491573
  508203
  510803
  519251
  520007
  525044
  526055
  531283
  533673
  541379
  541419
  550672
  554830
  556778
  558700
  561033
  565344
  571133
  575744
  576114
  579799
  579821
  590078
  590839
  591888
  592370
  593620
  593821
  594467
  596565
  604184
  604186
  604251
  604262
  604287
  604330
  604349
  604357
  604373
  604425
  604669
  609866
  637173
  649134
  671389
  674081
  678159
  692485
  712728
  718948
  719376
  720421
  720651
  720796
  727837
  735546
  759955
  777008
  790963
  799146
  810905
  819215
]

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 (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?
  )

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=1 LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=2 WHERE phc.post_id IN (14477, 389771, 414089, 420241, 443529, 454625, 454647, 460879, 461456, 461556, 464353, 464705, 464717, 464903, 468385, 470095, 476476, 477588, 483561, 491573, 508203, 510803, 519251, 520007, 525044, 526055, 531283, 533673, 541379, 541419, 550672, 554830, 556778, 558700, 561033, 565344, 571133, 575744, 576114, 579799, 579821, 590078, 590839, 591888, 592370, 593620, 593821, 594467, 596565, 604184, 604186, 604251, 604262, 604287, 604330, 604349, 604357, 604373, 604425, 604669, 609866, 637173, 649134, 671389, 674081, 678159, 692485, 712728, 718948, 719376, 720421, 720651, 720796, 727837, 735546, 759955, 777008, 790963, 799146, 810905, 819215);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "assfuck большие cock"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'assfuck большие cock';

SELECT `trend_id` FROM `trend` WHERE `subject` = ?

[
  "assfuck большие cock"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?

SELECT `trend_id` FROM `trend` WHERE `subject` = 'assfuck большие cock';