Query Metrics
5
Database Queries
2
Different statements
4.16 ms
Query time
19
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.00 ms |
SET time_zone = 'America/Chicago'
Parameters:
[] |
| 2 | 3.53 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4, t0.approved AS approved_5, t0.commission AS commission_6, t0.enable_customizations AS enable_customizations_7, t0.non_profit AS non_profit_8, t0.service_fees_cap AS service_fees_cap_9, t0.total_service_fees AS total_service_fees_10, t0.total_service_fees_capped AS total_service_fees_capped_11, t0.plan_renewal_amount AS plan_renewal_amount_12, t0.tin AS tin_13, t0.url_editable_until AS url_editable_until_14, t0.created_at AS created_at_15, t0.admin_org AS admin_org_16, t0.stripe_address_check AS stripe_address_check_17, t0.mandrill_subaccount AS mandrill_subaccount_18, t0.currency AS currency_19, t0.phone AS phone_20, t0.contact_name AS contact_name_21, t0.contact_email AS contact_email_22, t0.notes AS notes_23, t0.no_payment_gateway_required AS no_payment_gateway_required_24, t0.kindful_token AS kindful_token_25, t0.stripe_subscription_id AS stripe_subscription_id_26, t0.web_address AS web_address_27, t0.organization_type AS organization_type_28, t0.non_profit_approved AS non_profit_approved_29, t0.flight_simulator_status AS flight_simulator_status_30, t0.org_theme_primary_color AS org_theme_primary_color_31, t0.org_theme_secondary_color AS org_theme_secondary_color_32, t0.org_theme_tertiary_color AS org_theme_tertiary_color_33, t0.org_theme_background_color AS org_theme_background_color_34, t0.org_theme_name AS org_theme_name_35, t0.address1 AS address1_36, t0.address2 AS address2_37, t0.city AS city_38, t0.state AS state_39, t0.country AS country_40, t0.zip AS zip_41, t0.banner_image_id AS banner_image_id_42, t0.logo_image_id AS logo_image_id_43, t0.card_id AS card_id_44, t0.twilio_account AS twilio_account_45, t0.tax_certificate_id AS tax_certificate_id_46 FROM organizations t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"contact"
]
|
| 3 | 0.35 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4, t0.approved AS approved_5, t0.commission AS commission_6, t0.enable_customizations AS enable_customizations_7, t0.non_profit AS non_profit_8, t0.service_fees_cap AS service_fees_cap_9, t0.total_service_fees AS total_service_fees_10, t0.total_service_fees_capped AS total_service_fees_capped_11, t0.plan_renewal_amount AS plan_renewal_amount_12, t0.tin AS tin_13, t0.url_editable_until AS url_editable_until_14, t0.created_at AS created_at_15, t0.admin_org AS admin_org_16, t0.stripe_address_check AS stripe_address_check_17, t0.mandrill_subaccount AS mandrill_subaccount_18, t0.currency AS currency_19, t0.phone AS phone_20, t0.contact_name AS contact_name_21, t0.contact_email AS contact_email_22, t0.notes AS notes_23, t0.no_payment_gateway_required AS no_payment_gateway_required_24, t0.kindful_token AS kindful_token_25, t0.stripe_subscription_id AS stripe_subscription_id_26, t0.web_address AS web_address_27, t0.organization_type AS organization_type_28, t0.non_profit_approved AS non_profit_approved_29, t0.flight_simulator_status AS flight_simulator_status_30, t0.org_theme_primary_color AS org_theme_primary_color_31, t0.org_theme_secondary_color AS org_theme_secondary_color_32, t0.org_theme_tertiary_color AS org_theme_tertiary_color_33, t0.org_theme_background_color AS org_theme_background_color_34, t0.org_theme_name AS org_theme_name_35, t0.address1 AS address1_36, t0.address2 AS address2_37, t0.city AS city_38, t0.state AS state_39, t0.country AS country_40, t0.zip AS zip_41, t0.banner_image_id AS banner_image_id_42, t0.logo_image_id AS logo_image_id_43, t0.card_id AS card_id_44, t0.twilio_account AS twilio_account_45, t0.tax_certificate_id AS tax_certificate_id_46 FROM organizations t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"contact"
]
|
| 4 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.active AS active_4, t0.approved AS approved_5, t0.commission AS commission_6, t0.enable_customizations AS enable_customizations_7, t0.non_profit AS non_profit_8, t0.service_fees_cap AS service_fees_cap_9, t0.total_service_fees AS total_service_fees_10, t0.total_service_fees_capped AS total_service_fees_capped_11, t0.plan_renewal_amount AS plan_renewal_amount_12, t0.tin AS tin_13, t0.url_editable_until AS url_editable_until_14, t0.created_at AS created_at_15, t0.admin_org AS admin_org_16, t0.stripe_address_check AS stripe_address_check_17, t0.mandrill_subaccount AS mandrill_subaccount_18, t0.currency AS currency_19, t0.phone AS phone_20, t0.contact_name AS contact_name_21, t0.contact_email AS contact_email_22, t0.notes AS notes_23, t0.no_payment_gateway_required AS no_payment_gateway_required_24, t0.kindful_token AS kindful_token_25, t0.stripe_subscription_id AS stripe_subscription_id_26, t0.web_address AS web_address_27, t0.organization_type AS organization_type_28, t0.non_profit_approved AS non_profit_approved_29, t0.flight_simulator_status AS flight_simulator_status_30, t0.org_theme_primary_color AS org_theme_primary_color_31, t0.org_theme_secondary_color AS org_theme_secondary_color_32, t0.org_theme_tertiary_color AS org_theme_tertiary_color_33, t0.org_theme_background_color AS org_theme_background_color_34, t0.org_theme_name AS org_theme_name_35, t0.address1 AS address1_36, t0.address2 AS address2_37, t0.city AS city_38, t0.state AS state_39, t0.country AS country_40, t0.zip AS zip_41, t0.banner_image_id AS banner_image_id_42, t0.logo_image_id AS logo_image_id_43, t0.card_id AS card_id_44, t0.twilio_account AS twilio_account_45, t0.tax_certificate_id AS tax_certificate_id_46 FROM organizations t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"contact"
]
|
| 5 | 0.00 ms |
SET time_zone = 'America/Chicago'
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
| Class | Mapping errors |
|---|---|
| Bidcoz\Bundle\CoreBundle\Entity\Theme |
|
| Bidcoz\Bundle\CoreBundle\Entity\Address | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Organization | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Image | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\CreditCard | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\TwilioAccount | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\TaxCertificate | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\VideoEmbed | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Campaign |
|
| Bidcoz\Bundle\CoreBundle\Entity\PaymentGateway\Account\OrganizationAccount | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\OrganizationAdmin | No errors. |
| FOS\UserBundle\Model\User | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\User |
|
| Bidcoz\Bundle\CoreBundle\Entity\Auction\Auction | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Auction\Shop | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Auction\FundANeed | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Sponsorship\Sponsorship | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Sponsorship\SponsorshipLevel | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Ticket\SeatingChartImage | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Ticket\Ticket | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Ticket\TicketType | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Registration\Registration | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Purchase\Purchase |
|
| Bidcoz\Bundle\CoreBundle\Entity\Transaction\Transaction | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Donation\CashDonation | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Donation\AbstractLevel | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Donation\DonationLevel | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Procurement\Item | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Donation\MembershipLevel | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Donation\CryptoWallet |
|
| Bidcoz\Bundle\CoreBundle\Entity\Raffle\RaffleType | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Registration\RegistrationType | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\TwilioCampaign | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Contact\CampaignDetail | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Auction\BidNumber | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Ticket\TicketGroup | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Email\Template | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Email\ItemTemplate | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\PaymentGateway\Account\Account | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Auction\WatchListItem | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Email\Email | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Auction\Bid | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Terms\Terms | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Terms\UserTerms | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\PaymentGateway\PaymentGateway | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Contact\Tag | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Contact\Contact | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Contact\CompanyMember | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Log | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Question\Answer\Answer | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Question\Answer\RegistrationAnswer | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Question\Answer\TicketAnswer | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Question\Answer\TicketGroupAnswer | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Question\Answer\DonationAnswer | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Question\Question | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Transaction\CashTransaction | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Transaction\CheckTransaction | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Transaction\FlightSimulatorTransaction | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Transaction\PayoutTransaction | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Transaction\RefundTransaction | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Transaction\CreditTransaction | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Transaction\OfflineCreditCardTransaction | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Transaction\StripeRefundTransaction | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Transaction\StripeTransaction | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Transaction\ExternalTransaction | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Transaction\PayPalTransaction | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\CMS\ContentPage | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Rule | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Volunteer\Assignment | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Volunteer\Task | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\InternalUser | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Raffle\RaffleTicket | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Raffle\RaffleItem | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Raffle\RaffleTypeImage | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Raffle\RaffleItemWinningTicket | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Raffle\RaffleItemImage | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\SMS\CapturedSMS | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\SMS\SMSDraft | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\SMS\SMS |
|
| Bidcoz\Bundle\CoreBundle\Entity\Ticket\TicketQuestion | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Ticket\ReservedSeat | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Queue\Job | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Queue\ItemCloneJob | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Queue\ChargeCreditCardJob | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Queue\KindfulSyncJob | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Queue\SMSJob | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Queue\EmailJob | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\StripeLog | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Group | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Terms\OrganizationTerms | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Donation\StripeCashDonation | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Donation\Interval | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Donation\AbstractQuestion | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Donation\MembershipQuestion | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Donation\DonationQuestion | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Registration\RegistrationQuestion | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\PaymentGateway\Account\StripeAccount | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\PaymentGateway\Account\PayPalAccount | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Email\StandardTemplate | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Email\EmailDraft | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Email\TemplateCustomization | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\LoginLink | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Config | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Discount\RegistrationTypeDiscount | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Discount\TicketTypeDiscount | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\DisplayFeed\DisplayFeed | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\DisplayFeed\DisplayFeedSegment | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\DisplayFeed\DisplayFeedQuery | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\DisplayFeed\DisplayFeedTemplate | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Stripe\StripeObject | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Stripe\Charge | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Stripe\Card | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Stripe\ApplicationFee | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Stripe\BalanceTransaction | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Notification | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\GroupMember | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Procurement\ItemImage | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Contact\Company | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Tutorial\TutorialCategory | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Tutorial\Tutorial | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Link\Link | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Report | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Auction\ItemCondition | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Auction\AuctionVenue | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Auction\ItemImage | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Auction\MaxBid | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Auction\Item |
|
| Bidcoz\Bundle\CoreBundle\Entity\Auction\ItemType | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Auction\ItemCategory | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Auction\ItemSaleType | No errors. |
| Bidcoz\Bundle\CoreBundle\Entity\Purchase\TicketPurchase |
|
| Bidcoz\Bundle\CoreBundle\Entity\Purchase\InvoicePurchase |
|
| Bidcoz\Bundle\CoreBundle\Entity\Purchase\ItemPurchase |
|
| Bidcoz\Bundle\CoreBundle\Entity\Purchase\DonationItemPurchase |
|
| Bidcoz\Bundle\CoreBundle\Entity\Purchase\BuyItNowItemPurchase |
|
| Bidcoz\Bundle\CoreBundle\Entity\Purchase\SponsorshipPurchase |
|
| Bidcoz\Bundle\CoreBundle\Entity\Purchase\Donation\CashDonationPurchase |
|
| Bidcoz\Bundle\CoreBundle\Entity\Purchase\Donation\MembershipDonationPurchase |
|
| Bidcoz\Bundle\CoreBundle\Entity\Purchase\Donation\PaddleRaiseDonationPurchase |
|
| Bidcoz\Bundle\CoreBundle\Entity\Purchase\Donation\FundDriveDonationPurchase |
|
| Bidcoz\Bundle\CoreBundle\Entity\Purchase\RegistrationPurchase |
|
| Bidcoz\Bundle\CoreBundle\Entity\Purchase\RaffleTicketPurchase |
|
| Bidcoz\Bundle\CoreBundle\Entity\UserTitle | No errors. |
| Vich\UploaderBundle\Entity\File | No errors. |