Capital City Country Club Member Ticket

$40.95
Show Stats
Server Time: 04/04/2025 02:10:50
Session Id: frcpbvpqdllatvimnjhusdqp1e (Expires: 04/04/2025 04:10:49)
Peak Memory: 10.6269 MB
Markers
 
Time (% of Total)
Memory In
Memory Out
Memory +/-
App
0.2549 (100%)
364.766 kB
10.612 MB
10.255 MB
App.Boot
0.0320 (12.55%)
605.266 kB
5.521 MB
4.930 MB
Required.Providers.Init
0.0027 (1.06%)
606.367 kB
1.247 MB
670.922 kB
Profiler.Init
0.0001 (0.04%)
607.141 kB
651.609 kB
44.469 kB
FileSystem.Init
0.0000 (0%)
652.391 kB
739.070 kB
86.680 kB
Log.Init
0.0001 (0.04%)
739.852 kB
763.125 kB
23.273 kB
Cryptography.Init
0.0000 (0%)
793.102 kB
814.227 kB
21.125 kB
CacheEngine.Init
0.0000 (0%)
815.016 kB
837.039 kB
22.023 kB
Cache.Init
0.0001 (0.04%)
846.641 kB
869.875 kB
23.234 kB
Session.Init
0.0000 (0%)
870.977 kB
892.594 kB
21.617 kB
Cron.Init
0.0000 (0%)
894.992 kB
924.109 kB
29.117 kB
Databases.Init
0.0001 (0.04%)
924.852 kB
963.063 kB
38.211 kB
Databases.Data
0.0001 (0.04%)
925.625 kB
962.328 kB
36.703 kB
Queue.Init
0.0000 (0%)
962.734 kB
1.018 MB
79.758 kB
Registry.Init
0.0001 (0.04%)
1.056 MB
1.082 MB
27.023 kB
Module.Init
0.0000 (0%)
1.083 MB
1.104 MB
21.422 kB
PostOffice.Init
0.0001 (0.04%)
1.105 MB
1.213 MB
110.500 kB
I18n.Init
0.0000 (0%)
1.213 MB
1.225 MB
11.742 kB
Tools.Init
0.0001 (0.04%)
1.227 MB
1.247 MB
20.297 kB
Registry.Start
0.0076 (2.98%)
1.243 MB
3.360 MB
2.117 MB
Package.Core.Settings
0.0001 (0.04%)
3.205 MB
3.223 MB
17.445 kB
Package.Render.Settings
0.0000 (0%)
3.223 MB
3.233 MB
10.844 kB
Package.DataManager.Settings
0.0000 (0%)
3.234 MB
3.243 MB
9.125 kB
Package.Menus.Settings
0.0000 (0%)
3.243 MB
3.252 MB
9.117 kB
Package.Administration.Settings
0.0000 (0%)
3.252 MB
3.261 MB
9.125 kB
Package.ImageProcessor.Settings
0.0000 (0%)
3.262 MB
3.271 MB
9.125 kB
Package.FileManager.Settings
0.0000 (0%)
3.271 MB
3.281 MB
9.859 kB
Package.Web.Settings
0.0000 (0%)
3.281 MB
3.290 MB
9.117 kB
Package.Membership.Settings
0.0000 (0%)
3.290 MB
3.299 MB
9.125 kB
Package.Geography.Settings
0.0000 (0%)
3.299 MB
3.308 MB
9.125 kB
Package.Payment.Settings
0.0000 (0%)
3.309 MB
3.319 MB
10.375 kB
Package.Ecommerce.Settings
0.0000 (0%)
3.319 MB
3.330 MB
10.961 kB
Package.HQ.Settings
0.0000 (0%)
3.330 MB
3.341 MB
10.734 kB
Package.FTT.Settings
0.0000 (0%)
3.341 MB
3.350 MB
9.117 kB
Package.SCE.Settings
0.0000 (0%)
3.350 MB
3.359 MB
9.117 kB
Settings.Load
0.0093 (3.65%)
3.395 MB
3.427 MB
33.453 kB
Providers.Init
0.0024 (0.94%)
3.428 MB
4.645 MB
1.217 MB
TemplateEngine.Init
0.0001 (0.04%)
3.429 MB
3.453 MB
25.156 kB
View.Init
0.0001 (0.04%)
3.453 MB
3.551 MB
99.836 kB
Assets.Init
0.0001 (0.04%)
3.551 MB
3.575 MB
24.367 kB
Notification.Init
0.0000 (0%)
3.576 MB
3.596 MB
21.328 kB
DataManager.Init
0.0001 (0.04%)
3.597 MB
3.629 MB
32.633 kB
AuditLog.Init
0.0000 (0%)
3.629 MB
3.649 MB
20.898 kB
Menu.Init
0.0000 (0%)
3.650 MB
3.679 MB
30.188 kB
Admin.Init
0.0001 (0.04%)
3.680 MB
3.772 MB
94.516 kB
Onboard.Init
0.0000 (0%)
3.772 MB
3.795 MB
23.008 kB
ImageProcessor.Init
0.0000 (0%)
3.795 MB
3.816 MB
21.492 kB
Import.Init
0.0000 (0%)
3.816 MB
3.838 MB
22.609 kB
Theme.Init
0.0005 (0.2%)
3.839 MB
3.863 MB
25.125 kB
FrontEnd.Init
0.0000 (0%)
3.864 MB
3.875 MB
11.961 kB
Pages.Init
0.0000 (0%)
3.876 MB
3.915 MB
40.648 kB
Widget.Init
0.0000 (0%)
3.916 MB
3.936 MB
20.930 kB
Membership.Init
0.0000 (0%)
3.937 MB
4.033 MB
99.195 kB
Geography.Init
0.0001 (0.04%)
4.034 MB
4.053 MB
19.266 kB
Payment.Init
0.0002 (0.08%)
4.053 MB
4.213 MB
163.555 kB
Taxes.Init
0.0000 (0%)
4.213 MB
4.228 MB
15.102 kB
Shipping.Init
0.0000 (0%)
4.228 MB
4.241 MB
12.953 kB
GiftCards.Init
0.0000 (0%)
4.241 MB
4.255 MB
13.938 kB
Promotions.Init
0.0001 (0.04%)
4.255 MB
4.283 MB
28.047 kB
Marketplaces.Init
0.0000 (0%)
4.283 MB
4.369 MB
88.211 kB
Suppliers.Init
0.0000 (0%)
4.369 MB
4.394 MB
25.000 kB
Ecommerce.Init
0.0001 (0.04%)
4.394 MB
4.432 MB
39.016 kB
ShoppingCart.Init
0.0001 (0.04%)
4.433 MB
4.543 MB
113.211 kB
Fulfillment.Init
0.0000 (0%)
4.544 MB
4.577 MB
34.203 kB
HQ.Init
0.0001 (0.04%)
4.577 MB
4.607 MB
30.898 kB
CateringEvents.Init
0.0000 (0%)
4.608 MB
4.620 MB
12.313 kB
Venues.Init
0.0000 (0%)
4.620 MB
4.632 MB
12.281 kB
Weddings.Init
0.0000 (0%)
4.633 MB
4.645 MB
12.297 kB
Customapp.Boot
0.0000 (0%)
4.663 MB
4.664 MB
752.000 B
App.OnAppBoot
0.0019 (0.75%)
4.665 MB
4.934 MB
275.961 kB
View.Init
0.0011 (0.43%)
4.742 MB
4.905 MB
167.117 kB
View.Init.SetTheme
0.0000 (0%)
4.855 MB
4.873 MB
19.063 kB
View.Init.SetLayout
0.0001 (0.04%)
4.874 MB
4.903 MB
30.336 kB
App.InitAPIs
0.0010 (0.39%)
4.935 MB
4.935 MB
752.000 B
App.InitRoutes
0.0003 (0.12%)
4.936 MB
4.936 MB
752.000 B
App.InitExtensions
0.0040 (1.57%)
4.937 MB
5.520 MB
597.461 kB
Package.Core
0.0000 (0%)
4.938 MB
4.938 MB
792.000 B
Package.Render
0.0000 (0%)
4.939 MB
4.939 MB
792.000 B
Package.DataManager
0.0000 (0%)
4.940 MB
4.941 MB
800.000 B
Package.Menus
0.0000 (0%)
4.941 MB
4.942 MB
792.000 B
Package.Administration
0.0000 (0%)
4.942 MB
4.943 MB
800.000 B
Package.ImageProcessor
0.0000 (0%)
4.943 MB
4.944 MB
800.000 B
Package.FileManager
0.0000 (0%)
4.944 MB
4.945 MB
800.000 B
Package.Web
0.0000 (0%)
4.945 MB
4.946 MB
792.000 B
Package.Membership
0.0000 (0%)
4.946 MB
4.947 MB
800.000 B
Package.Geography
0.0000 (0%)
4.948 MB
4.948 MB
800.000 B
Package.Payment
0.0000 (0%)
4.949 MB
4.949 MB
792.000 B
Package.Ecommerce
0.0000 (0%)
4.950 MB
4.951 MB
800.000 B
Package.HQ
0.0000 (0%)
4.951 MB
4.952 MB
792.000 B
Package.FTT
0.0000 (0%)
4.952 MB
4.953 MB
792.000 B
Package.SCE
0.0000 (0%)
4.953 MB
4.956 MB
2.625 kB
Provider.Profiler
0.0000 (0%)
4.956 MB
4.957 MB
800.000 B
Provider.Cryptography
0.0000 (0%)
4.957 MB
4.958 MB
800.000 B
Provider.CacheEngine
0.0000 (0%)
4.958 MB
4.959 MB
800.000 B
Provider.Cache
0.0000 (0%)
4.959 MB
4.960 MB
792.000 B
Provider.Cron
0.0000 (0%)
4.961 MB
4.961 MB
792.000 B
Provider.FileSystem
0.0000 (0%)
4.962 MB
4.962 MB
800.000 B
Provider.Queue
0.0000 (0%)
4.963 MB
4.965 MB
1.891 kB
Provider.Log
0.0000 (0%)
4.965 MB
4.966 MB
792.000 B
Provider.Registry
0.0000 (0%)
4.966 MB
4.967 MB
800.000 B
Provider.Module
0.0000 (0%)
4.967 MB
4.968 MB
792.000 B
Provider.PostOffice
0.0000 (0%)
4.968 MB
4.969 MB
800.000 B
Provider.Session
0.0000 (0%)
4.969 MB
4.970 MB
800.000 B
Provider.I18n
0.0000 (0%)
4.971 MB
4.972 MB
1.820 kB
Provider.Tools
0.0000 (0%)
4.973 MB
4.974 MB
792.000 B
Provider.TemplateEngine
0.0000 (0%)
4.974 MB
4.975 MB
800.000 B
Provider.View
0.0000 (0%)
4.975 MB
4.978 MB
2.625 kB
Provider.Assets
0.0000 (0%)
4.978 MB
4.979 MB
792.000 B
Provider.Notification
0.0000 (0%)
4.979 MB
4.980 MB
800.000 B
Provider.DataManager
0.0000 (0%)
4.980 MB
4.981 MB
800.000 B
Provider.AuditLog
0.0000 (0%)
4.981 MB
4.982 MB
800.000 B
Provider.Menu
0.0001 (0.04%)
4.982 MB
4.989 MB
6.469 kB
Provider.Admin
0.0000 (0%)
4.989 MB
4.991 MB
1.594 kB
Provider.Onboard
0.0000 (0%)
4.991 MB
4.992 MB
800.000 B
Provider.ImageProcessor
0.0000 (0%)
4.992 MB
4.993 MB
800.000 B
Provider.Import
0.0000 (0%)
4.993 MB
4.994 MB
792.000 B
Provider.Theme
0.0000 (0%)
4.994 MB
5.001 MB
6.945 kB
Provider.FrontEnd
0.0000 (0%)
5.001 MB
5.003 MB
1.898 kB
Provider.Pages
0.0000 (0%)
5.004 MB
5.008 MB
4.195 kB
Provider.Widget
0.0000 (0%)
5.008 MB
5.010 MB
1.594 kB
Provider.Membership
0.0023 (0.9%)
5.010 MB
5.012 MB
2.453 kB
Provider.Geography
0.0000 (0%)
5.013 MB
5.014 MB
800.000 B
Provider.Payment
0.0000 (0%)
5.014 MB
5.015 MB
808.000 B
Provider.Taxes
0.0000 (0%)
5.015 MB
5.016 MB
792.000 B
Provider.Shipping
0.0000 (0%)
5.016 MB
5.017 MB
800.000 B
Provider.GiftCards
0.0000 (0%)
5.017 MB
5.020 MB
2.273 kB
Provider.Promotions
0.0000 (0%)
5.020 MB
5.036 MB
16.852 kB
Provider.Marketplaces
0.0000 (0%)
5.037 MB
5.037 MB
800.000 B
Provider.Suppliers
0.0000 (0%)
5.038 MB
5.046 MB
8.148 kB
Provider.Ecommerce
0.0004 (0.16%)
5.046 MB
5.056 MB
10.117 kB
Provider.ShoppingCart
0.0000 (0%)
5.056 MB
5.059 MB
2.758 kB
Provider.Fulfillment
0.0000 (0%)
5.059 MB
5.062 MB
2.281 kB
Provider.HQ
0.0000 (0%)
5.062 MB
5.063 MB
800.000 B
Provider.CateringEvents
0.0000 (0%)
5.063 MB
5.065 MB
2.281 kB
Provider.Venues
0.0000 (0%)
5.066 MB
5.069 MB
3.391 kB
Provider.Weddings
0.0000 (0%)
5.069 MB
5.072 MB
3.031 kB
Customapp.OnAppRun
0.0000 (0%)
5.073 MB
5.073 MB
752.000 B
Module.Controls
0.0001 (0.04%)
5.074 MB
5.186 MB
114.727 kB
Module.Notes
0.0000 (0%)
5.186 MB
5.196 MB
9.844 kB
Module.Taxonomy
0.0000 (0%)
5.196 MB
5.206 MB
9.844 kB
Module.FileManager
0.0000 (0%)
5.206 MB
5.217 MB
10.930 kB
Module.Attachments
0.0000 (0%)
5.217 MB
5.227 MB
9.875 kB
Module.Images
0.0000 (0%)
5.227 MB
5.237 MB
9.859 kB
Module.Manufacturers
0.0000 (0%)
5.237 MB
5.247 MB
10.305 kB
Module.ProductReviews
0.0000 (0%)
5.248 MB
5.258 MB
10.570 kB
Module.ProductWaitlist
0.0000 (0%)
5.258 MB
5.270 MB
12.313 kB
Widget.PageBody
0.0001 (0.04%)
5.271 MB
5.298 MB
27.563 kB
Widget.Billboard
0.0000 (0%)
5.298 MB
5.308 MB
10.500 kB
Widget.Channels
0.0000 (0%)
5.309 MB
5.319 MB
10.492 kB
Widget.ChannelPages
0.0000 (0%)
5.319 MB
5.329 MB
10.508 kB
Widget.Code
0.0000 (0%)
5.330 MB
5.339 MB
9.867 kB
Widget.ContactForm
0.0000 (0%)
5.340 MB
5.350 MB
10.516 kB
Widget.ImageGallery
0.0000 (0%)
5.350 MB
5.361 MB
10.508 kB
Widget.Share
0.0000 (0%)
5.361 MB
5.371 MB
10.492 kB
Widget.Menu
0.0000 (0%)
5.372 MB
5.382 MB
10.492 kB
Widget.Popup
0.0000 (0%)
5.382 MB
5.392 MB
10.492 kB
Widget.RichEdit
0.0000 (0%)
5.393 MB
5.466 MB
74.492 kB
Widget.RichEditBlocks
0.0000 (0%)
5.466 MB
5.476 MB
10.508 kB
Widget.AccordionRichEdit
0.0000 (0%)
5.477 MB
5.487 MB
10.516 kB
Widget.ProductCarousel
0.0000 (0%)
5.487 MB
5.499 MB
11.758 kB
Widget.SplitScreenRichEdit
0.0000 (0%)
5.499 MB
5.509 MB
10.531 kB
Widget.FullScreenImageGallery
0.0000 (0%)
5.510 MB
5.520 MB
10.531 kB
App.Stack
0.2225 (87.29%)
5.521 MB
10.611 MB
5.090 MB
Router.Matchingroutes
0.0000 (0%)
5.539 MB
5.540 MB
968.000 B
FrontEnd.Call
0.1264 (49.59%)
5.540 MB
8.466 MB
2.926 MB
Render.Theme.Prepare
0.0003 (0.12%)
8.464 MB
8.486 MB
22.016 kB
Render.Blocks
0.0026 (1.02%)
8.562 MB
8.913 MB
359.414 kB
TemplateEngine.Initialize
0.0008 (0.31%)
8.593 MB
8.876 MB
289.703 kB
Render.Layout
0.0044 (1.73%)
8.914 MB
9.607 MB
709.570 kB
Render.Template
0.0828 (32.48%)
9.607 MB
10.564 MB
979.984 kB
Menu.GetMenu.Getentity.Mobile-menu
0.0029 (1.14%)
9.750 MB
9.885 MB
138.836 kB
Menu.GetMenu.Primary-menu
0.0276 (10.83%)
9.886 MB
10.252 MB
375.414 kB
Menu.GetMenu.Getentity.Primary-menu
0.0265 (10.4%)
9.886 MB
10.235 MB
356.906 kB
Menu.Render.Primary-menu
0.0101 (3.96%)
10.252 MB
10.267 MB
15.211 kB
Menu.FindCurrentItem.Primary-menu
0.0030 (1.18%)
10.266 MB
10.268 MB
1.781 kB
Menu.GetMenu.Footer-menu-1
0.0201 (7.89%)
10.260 MB
10.449 MB
193.227 kB
Menu.GetMenu.Getentity.Footer-menu-1
0.0178 (6.98%)
10.261 MB
10.440 MB
183.414 kB
Menu.Render.Footer-menu-1
0.0004 (0.16%)
10.449 MB
10.454 MB
4.977 kB
Menu.FindCurrentItem.Footer-menu-1
0.0000 (0%)
10.455 MB
10.456 MB
1.148 kB
Menu.GetMenu.Footer-menu-2
0.0128 (5.02%)
10.468 MB
10.588 MB
122.930 kB
Menu.GetMenu.Getentity.Footer-menu-2
0.0121 (4.75%)
10.468 MB
10.582 MB
116.742 kB
Menu.Render.Footer-menu-2
0.0002 (0.08%)
10.588 MB
10.591 MB
3.477 kB
Menu.FindCurrentItem.Footer-menu-2
0.0000 (0%)
10.592 MB
10.593 MB
1.148 kB
Render.Hooks
0.0002 (0.08%)
10.577 MB
10.601 MB
24.734 kB
Opcode Cache
Enabled: Yes
Memory: 122.73 MB / 128.00 MB (5.27 MB wasted)
Hits: 94259943 (99.24%)
Misses: 717967
Scripts: 3383
Cache Engine
Enabled: Yes
Engine: Redis (7.0.7)
Objects: 1093
Memory: 162.21 MB
Hits: 2679600385
Misses: 68501620
Database
Queries: 19 (0.03)

0.0007 (0)


SELECT URL.target_name AS TargetName, URL.path AS Path FROM DM_URLs URL WHERE URL.target_type = 'entity' AND ( URL.target_name = 'MemberHomePage' OR URL.target_name = 'MemberProfilePage' OR URL.target_name = 'MemberSignInPage' OR URL.target_name = 'MemberSignUpPage' OR URL.target_name = 'MemberActivatePage' OR URL.target_name = 'MemberResetPasswordPage' OR URL.target_name = 'MemberForgotPasswordPage');
0.0008 (1)


SELECT URL.url_id AS URLId, URL.path AS Path, URL.target_type AS TargetType, URL.target_name AS TargetName FROM DM_URLs URL WHERE URL.path = 'easter-brunch/capital-city-country-club-member-ticket-1';
0.0010 (1)


SELECT URL.url_id AS "Id", PageURL.page_id AS "PageId", PageURL.path AS "Path", URL.path AS "FullPath", URL.target_type AS "TargetType", URL.target_name AS "TargetName", PageURL.is_default AS "Default", UNIX_TIMESTAMP(PageURL.modified) AS "Modified", URL.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(PageURL.created) AS "Created", URL.created_by AS "CreatedBy", URL.cue_source AS "CueSource", URL.cue_source_id AS "CueSourceId", URL.cue_ver AS "CueVersion" FROM DM_URLs URL JOIN Web_PagesURLs PageURL ON PageURL.url_id = URL.url_id WHERE URL.url_id = '97';
0.0030 (1)


SELECT Page.page_id AS "Id", Page.entity AS "Entity", Page.title AS "Title", Page.subtitle AS "Subtitle", Page.title_tag AS "TitleTag", Page.body_class AS "BodyClass", Page.meta_description AS "MetaDescription", Page.meta_robots AS "MetaRobots", Page.canonical_url AS "CanonicalURL", Page.body AS "Body", Page.excerpt AS "Excerpt", Page.search_public_keywords AS "PublicSearchKeywords", Page.javascript AS "JavaScript", Page.stylesheet AS "StyleSheet", Page.exclude_sitemap AS "ExcludeSitemap", Page.exclude_widgets AS "ExcludeWidgets", Page.exclude_search AS "ExcludeSearch", Page.require_ssl AS "RequireSSL", Page.require_signin AS "RequireSignIn", Page.can_cache AS "CanCache", Page.is_system_page AS "IsSystemPage", Page.sort_order AS "SortOrder", Page.image_id AS "Image", Page.author_id AS "Author", Page.status_id AS "Status", UNIX_TIMESTAMP(Page.status_date) AS "StatusDate", Page.channel_id AS "Channel", DefaultLayout.layout_code AS "DefaultLayout", DefaultURL.url_id AS "DefaultURLId", DefaultURL.path AS "DefaultURL", DefaultFullURL.path AS "DefaultFullURL", LOWER(CONCAT('Product/', Page.page_id)) AS "Permalink", UNIX_TIMESTAMP(Page.modified) AS "Modified", Page.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(Page.created) AS "Created", Page.created_by AS "CreatedBy", Page.cue_source AS "CueSource", Page.cue_source_id AS "CueSourceId", Page.cue_ver AS "CueVersion", Product.product_id AS "ProductId", Product.manufacturer_id AS "Manufacturer", Product.sku AS "SKU", Product.part_no AS "PartNo", Product.barcode AS "Barcode", Product.serial_no AS "SerialNo", Product.product_type AS "ProductType", Product.physical_condition AS "Condition", Product.regular_price AS "RegularPrice", Product.sale_price AS "SalePrice", (SELECT MAX(adjusted_cost) FROM Ecom_SuppliersProducts WHERE product_id = Page.page_id AND is_active = 1) AS "MinimumPrice", Product.msrp_price AS "MSRP", Product.map_price AS "MAPPrice", (SELECT IF(SUM(quantity) = 0, MAX(cost_price), SUM(cost_price * quantity) / SUM(quantity)) FROM Ecom_SuppliersProducts WHERE product_id = Page.page_id AND is_active = 1) AS "Cost", Product.is_taxable AS "Taxable", Product.tax_class_id AS "TaxClass", Product.dimension_width AS "DimensionWidth", Product.dimension_width_unit AS "DimensionWidthUnit", Product.dimension_length AS "DimensionLength", Product.dimension_length_unit AS "DimensionLengthUnit", Product.dimension_height AS "DimensionHeight", Product.dimension_height_unit AS "DimensionHeightUnit", Product.weight AS "Weight", Product.weight_unit AS "WeightUnit", Product.shipping_fee AS "ShippingFee", Product.shipping_value AS "ShippingValue", Product.track_inventory AS "TrackInventory", Product.track_variant_inventory AS "TrackVariantInventory", (SELECT SUM(quantity) FROM Ecom_SuppliersProducts WHERE product_id = Page.page_id AND is_active = 1 GROUP BY product_id) AS "QuantityOnHand", (SELECT SUM(quantity) FROM Ecom_ProductsAllocations WHERE product_id = Page.page_id GROUP BY product_id) AS "QuantityAllocated", (

SELECT SUM(SupplierProduct.quantity) - IF(Allocation.quantity IS NULL, 0, Allocation.quantity) FROM Ecom_SuppliersProducts SupplierProduct LEFT JOIN (

SELECT product_id, SUM(quantity) AS quantity FROM Ecom_ProductsAllocations GROUP BY product_id ) Allocation ON Allocation.product_id = SupplierProduct.product_id WHERE SupplierProduct.product_id = Page.page_id AND SupplierProduct.is_active = 1 GROUP BY SupplierProduct.product_id ) AS "Quantity", Product.location_bin AS "LocationBin", Product.review_count AS "ReviewCount", Product.average_rating AS "AverageRating", Product.allow_backorders AS "AllowBackorders", Product.availability AS "Availability", Product.sales_rank AS "SalesRank", Product.is_new AS "New", Product.is_coming_soon AS "ComingSoon", Product.is_exclusive AS "Exclusive", Product.is_featured AS "Featured", Product.custom_flag_1 AS "CustomFlag1", Product.custom_flag_2 AS "CustomFlag2", Product.custom_flag_3 AS "CustomFlag3", Product.custom_flag_4 AS "CustomFlag4", Product.custom_flag_5 AS "CustomFlag5", Product.custom_field_1 AS "CustomField1", Product.custom_field_2 AS "CustomField2", Product.custom_field_3 AS "CustomField3", Product.custom_field_4 AS "CustomField4", Product.custom_field_5 AS "CustomField5", Product.custom_field_6 AS "CustomField6", Product.custom_field_7 AS "CustomField7", Product.custom_field_8 AS "CustomField8", Product.custom_field_9 AS "CustomField9", Product.custom_field_10 AS "CustomField10", (SELECT COUNT(1) FROM Ecom_ProductsVariants WHERE product_id = Page.page_id AND is_active = 1) AS "VariantCount" FROM Web_Pages Page LEFT JOIN Web_PagesLayouts DefaultLayout ON DefaultLayout.page_id = Page.page_id AND DefaultLayout.is_default = 1 LEFT JOIN Web_PagesURLs DefaultURL ON DefaultURL.page_id = Page.page_id AND DefaultURL.is_default = 1 LEFT JOIN DM_URLs DefaultFullURL ON DefaultFullURL.url_id = DefaultURL.url_id JOIN Ecom_Products Product ON Product.page_id = Page.page_id LEFT JOIN DM_Statuses Status ON Status.status_id = Page.status_id WHERE Page.page_id = 120 AND Status.is_public = true AND UNIX_TIMESTAMP(Page.status_date) <= 1743747050;
0.0081 (11)


SELECT DISTINCT Widget.widget_id AS "Id", Widget.widget_code AS "Code", Widget.admin_title AS "Title", Widget.default_region AS "DefaultRegion", Widget.properties AS "Properties", UNIX_TIMESTAMP(Widget.effective_on) AS "EffectiveOn", UNIX_TIMESTAMP(Widget.expires_on) AS "ExpiresOn", Widget.show_not_signed_in AS "ShowNotSignedIn", Widget.show_signed_in AS "ShowSignedIn", Widget.can_cache AS "CanCache", Widget.is_active AS "Active", UNIX_TIMESTAMP(Widget.modified) AS "Modified", Widget.modified_by AS "ModifiedBy.Id", UNIX_TIMESTAMP(Widget.created) AS "Created", Widget.created_by AS "CreatedBy.Id", Widget.cue_source AS "CueSource", Widget.cue_source_id AS "CueSourceId", Widget.cue_ver AS "CueVersion", WidgetPage.region AS "Region" FROM Web_WidgetsPages WidgetPage JOIN Web_Widgets Widget ON Widget.widget_id = WidgetPage.widget_id WHERE ( Widget.widget_id IN (SELECT widget_id FROM Web_WidgetsChannels WHERE channel_id = '115') OR Widget.widget_id IN (SELECT widget_id FROM Web_WidgetsEntities WHERE entity_name = 'Product') OR WidgetPage.page_id = '120' ) AND ( Widget.widget_id NOT IN (SELECT widget_id FROM Web_WidgetsPages WHERE page_id = '120' AND excluded = 1) ) ORDER BY WidgetPage.sort_order ASC;

SELECT MediaFile.media_file_id AS "Id", MediaFile.media_type AS "MediaType", MediaFile.title AS "Title", MediaFile.version AS "Version", MediaFile.description AS "Description", MediaFile.filename AS "Filename", MediaFile.path AS "Path", MediaFile.target_file AS "File", MediaFile.file_bytes AS "FileBytes", CONCAT(MediaFile.path, MediaFile.target_file) AS "FileURL", MediaFile.hash AS "Hash", MediaFile.mime_type AS "MimeType", MediaFile.show_in_media AS "ShowInMedia", UNIX_TIMESTAMP(MediaFile.status_date) AS "StatusDate", MediaFile.status_id AS "Status", UNIX_TIMESTAMP(MediaFile.modified) AS "Modified", MediaFile.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(MediaFile.created) AS "Created", MediaFile.created_by AS "CreatedBy", MediaFile.cue_source AS "CueSource", MediaFile.cue_source_id AS "CueSourceId", MediaFile.cue_ver AS "CueVersion", ImageFile.alt_text AS "AltText", ImageFile.source_width AS "SourceWidth", ImageFile.source_height AS "SourceHeight", ImageFile.micro_filename AS "MicroFilename", ImageFile.micro_width AS "MicroWidth", ImageFile.micro_height AS "MicroHeight", ImageFile.micro_bytes AS "MicroBytes", CONCAT(MediaFile.path, ImageFile.micro_filename) AS "MicroURL", ImageFile.thumbnail_filename AS "ThumbnailFilename", ImageFile.thumbnail_width AS "ThumbnailWidth", ImageFile.thumbnail_height AS "ThumbnailHeight", ImageFile.thumbnail_bytes AS "ThumbnailBytes", CONCAT(MediaFile.path, ImageFile.thumbnail_filename) AS "ThumbnailURL", ImageFile.small_filename AS "SmallFilename", ImageFile.small_width AS "SmallWidth", ImageFile.small_height AS "SmallHeight", ImageFile.small_bytes AS "SmallBytes", CONCAT(MediaFile.path, ImageFile.small_filename) AS "SmallURL", ImageFile.medium_filename AS "MediumFilename", ImageFile.medium_width AS "MediumWidth", ImageFile.medium_height AS "MediumHeight", ImageFile.medium_bytes AS "MediumBytes", CONCAT(MediaFile.path, ImageFile.medium_filename) AS "MediumURL", ImageFile.large_filename AS "LargeFilename", ImageFile.large_width AS "LargeWidth", ImageFile.large_height AS "LargeHeight", ImageFile.large_bytes AS "LargeBytes", CONCAT(MediaFile.path, ImageFile.large_filename) AS "LargeURL" FROM FM_MediaFiles MediaFile LEFT JOIN FM_ImageFiles ImageFile ON ImageFile.media_file_id = MediaFile.media_file_id WHERE MediaFile.media_file_id = '340';

SELECT Status.status_id AS "Id", Status.entity_name AS "Entity", Status.label AS "Label", Status.is_entity_active AS "EntityIsActive", Status.is_entity_inactive AS "EntityIsInactive", Status.is_default AS "Default", Status.is_public AS "Public", Status.is_active AS "Active", Status.sort_order AS "SortOrder", Status.modified AS "Modified", Status.modified_by AS "ModifiedBy", Status.created AS "Created", Status.created_by AS "CreatedBy", Status.cue_source AS "CueSource", Status.cue_source_id AS "CueSourceId", Status.cue_ver AS "CueVersion" FROM DM_Statuses Status WHERE Status.status_id = '27';

SELECT ChannelLite.page_id AS "Id", ChannelLite.channel_id AS "ChannelId", ChannelLite.title AS "Title", webGetPageHierarchy(Channel.page_id, 'title') AS "FullTitle", ChannelStatus.is_public AS "Public", ChannelDefaultURL.path AS "DefaultURL", DefaultFullURL.path AS "DefaultFullURL", Channel.page_entity AS "PageEntity", Channel.default_page_layout AS "DefaultPageLayout", Channel.sort_property AS "SortProperty", Channel.pages_per_index AS "PagesPerIndex", Channel.show_full_content AS "ShowFullContent", Channel.words_per_excerpt AS "WordsPerExcerpt", CONCAT_WS('/', MediaFile.path, ImageFile.thumbnail_filename) AS "ImageThumbnailURL", CONCAT_WS('/', MediaFile.path, ImageFile.small_filename) AS "ImageSmallURL", CONCAT_WS('/', MediaFile.path, ImageFile.medium_filename) AS "ImageMediumURL", CONCAT_WS('/', MediaFile.path, ImageFile.large_filename) AS "ImageLargeURL" FROM Web_Pages ChannelLite JOIN DM_Statuses ChannelStatus ON ChannelStatus.status_id = ChannelLite.status_id LEFT JOIN Web_PagesURLs ChannelDefaultURL ON ChannelDefaultURL.page_id = ChannelLite.page_id AND ChannelDefaultURL.is_default = 1 LEFT JOIN DM_URLs DefaultFullURL ON DefaultFullURL.url_id = ChannelDefaultURL.url_id JOIN Web_Channels Channel ON Channel.page_id = ChannelLite.page_id LEFT JOIN FM_MediaFiles MediaFile ON MediaFile.media_file_id = ChannelLite.image_id LEFT JOIN FM_ImageFiles ImageFile ON ImageFile.media_file_id = ChannelLite.image_id WHERE ChannelLite.page_id = '115';

SELECT PageAttachment.page_attachment_id AS "Id", PageAttachment.page_id AS "PageId", PageAttachment.media_file_id AS "MediaFileId", PageAttachment.tag_class AS "TagClass", PageAttachment.sort_order AS "SortOrder", MediaFile.media_type AS "MediaType", MediaFile.title AS "Title", MediaFile.version AS "Version", MediaFile.description AS "Description", MediaFile.filename AS "Filename", MediaFile.path AS "Path", MediaFile.target_file AS "File", MediaFile.file_bytes AS "FileBytes", CONCAT(MediaFile.path, MediaFile.target_file) AS "FileURL", MediaFile.mime_type AS "MimeType", UNIX_TIMESTAMP(MediaFile.status_date) AS "StatusDate", MediaFile.status_id AS "Status", UNIX_TIMESTAMP(PageAttachment.modified) AS "Modified", PageAttachment.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(PageAttachment.created) AS "Created", PageAttachment.created_by AS "CreatedBy", PageAttachment.cue_source AS "CueSource", PageAttachment.cue_source_id AS "CueSourceId", PageAttachment.cue_ver AS "CueVersion" FROM Web_PagesAttachments PageAttachment JOIN FM_MediaFiles MediaFile ON MediaFile.media_file_id = PageAttachment.media_file_id WHERE PageAttachment.page_id = 120;

SELECT PageCategory.page_category_id AS "Id", PageCategory.page_id AS "PageId", PageCategory.taxonomy_id AS "TaxonomyId", Taxonomy.label AS "Label", Taxonomy.description AS "Description", UNIX_TIMESTAMP(PageCategory.modified) AS "Modified", PageCategory.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(PageCategory.created) AS "Created", PageCategory.created_by AS "CreatedBy", PageCategory.cue_source AS "CueSource", PageCategory.cue_source_id AS "CueSourceId", PageCategory.cue_ver AS "CueVersion" FROM Web_PagesCategories PageCategory JOIN DM_Taxonomies Taxonomy ON Taxonomy.taxonomy_id = PageCategory.taxonomy_id WHERE PageCategory.page_id = 120 ORDER BY Taxonomy.label ASC;

SELECT PageImage.page_image_id AS "Id", PageImage.page_id AS "PageId", PageImage.media_file_id AS "MediaFileId", PageImage.tag_id AS "TagId", PageImage.tag_class AS "TagClass", PageImage.sort_order AS "SortOrder", MediaFile.media_type AS "MediaType", MediaFile.title AS "Title", MediaFile.version AS "Version", MediaFile.description AS "Description", MediaFile.filename AS "Filename", MediaFile.path AS "Path", MediaFile.target_file AS "File", MediaFile.file_bytes AS "FileBytes", CONCAT(MediaFile.path, MediaFile.target_file) AS "FileURL", MediaFile.mime_type AS "MimeType", ImageFile.alt_text AS "AltText", ImageFile.source_width AS "SourceWidth", ImageFile.source_height AS "SourceHeight", ImageFile.micro_filename AS "MicroFilename", ImageFile.micro_width AS "MicroWidth", ImageFile.micro_height AS "MicroHeight", ImageFile.micro_bytes AS "MicroBytes", CONCAT(MediaFile.path, ImageFile.micro_filename) AS "MicroURL", ImageFile.thumbnail_filename AS "ThumbnailFilename", ImageFile.thumbnail_width AS "ThumbnailWidth", ImageFile.thumbnail_height AS "ThumbnailHeight", ImageFile.thumbnail_bytes AS "ThumbnailBytes", CONCAT(MediaFile.path, ImageFile.thumbnail_filename) AS "ThumbnailURL", ImageFile.small_filename AS "SmallFilename", ImageFile.small_width AS "SmallWidth", ImageFile.small_height AS "SmallHeight", ImageFile.small_bytes AS "SmallBytes", CONCAT(MediaFile.path, ImageFile.small_filename) AS "SmallURL", ImageFile.medium_filename AS "MediumFilename", ImageFile.medium_width AS "MediumWidth", ImageFile.medium_height AS "MediumHeight", ImageFile.medium_bytes AS "MediumBytes", CONCAT(MediaFile.path, ImageFile.medium_filename) AS "MediumURL", ImageFile.large_filename AS "LargeFilename", ImageFile.large_width AS "LargeWidth", ImageFile.large_height AS "LargeHeight", ImageFile.large_bytes AS "LargeBytes", CONCAT(MediaFile.path, ImageFile.large_filename) AS "LargeURL", UNIX_TIMESTAMP(MediaFile.status_date) AS "StatusDate", MediaFile.status_id AS "Status", UNIX_TIMESTAMP(PageImage.modified) AS "Modified", PageImage.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(PageImage.created) AS "Created", PageImage.created_by AS "CreatedBy", PageImage.cue_source AS "CueSource", PageImage.cue_source_id AS "CueSourceId", PageImage.cue_ver AS "CueVersion" FROM Web_PagesImages PageImage LEFT JOIN FM_MediaFiles MediaFile ON MediaFile.media_file_id = PageImage.media_file_id LEFT JOIN FM_ImageFiles ImageFile ON ImageFile.media_file_id = PageImage.media_file_id WHERE PageImage.page_id = 120 ORDER BY PageImage.sort_order ASC;

SELECT PageTag.page_tag_id AS "Id", PageTag.page_id AS "PageId", PageTag.taxonomy_id AS "TaxonomyId", Taxonomy.label AS "Label", Taxonomy.description AS "Description", UNIX_TIMESTAMP(PageTag.modified) AS "Modified", PageTag.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(PageTag.created) AS "Created", PageTag.created_by AS "CreatedBy", PageTag.cue_source AS "CueSource", PageTag.cue_source_id AS "CueSourceId", PageTag.cue_ver AS "CueVersion" FROM Web_PagesTags PageTag JOIN DM_Taxonomies Taxonomy ON Taxonomy.taxonomy_id = PageTag.taxonomy_id WHERE PageTag.page_id = 120 ORDER BY Taxonomy.label ASC;

SELECT URL.url_id AS "Id", PageURL.page_id AS "PageId", PageURL.path AS "Path", URL.path AS "FullPath", URL.target_type AS "TargetType", URL.target_name AS "TargetName", PageURL.is_default AS "Default", UNIX_TIMESTAMP(PageURL.modified) AS "Modified", URL.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(PageURL.created) AS "Created", URL.created_by AS "CreatedBy", URL.cue_source AS "CueSource", URL.cue_source_id AS "CueSourceId", URL.cue_ver AS "CueVersion" FROM DM_URLs URL JOIN Web_PagesURLs PageURL ON PageURL.url_id = URL.url_id WHERE PageURL.page_id = 120 ORDER BY PageURL.is_default DESC;

SELECT Author.admin_user_id AS "Id", Author.first_name AS "FirstName", Author.last_name AS "LastName", Author.email AS "Email", TRIM(CONCAT(Author.first_name, ' ', Author.last_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayFirstLast", TRIM(CONCAT(Author.last_name, ', ', Author.first_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayLastFirst" FROM DM_AdminUsers Author WHERE Author.admin_user_id = '9';

SELECT Author.admin_user_id AS "Id", Author.first_name AS "FirstName", Author.last_name AS "LastName", Author.email AS "Email", TRIM(CONCAT(Author.first_name, ' ', Author.last_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayFirstLast", TRIM(CONCAT(Author.last_name, ', ', Author.first_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayLastFirst" FROM DM_AdminUsers Author WHERE Author.admin_user_id = '9';

SELECT Manufacturer.page_id AS "Id", Manufacturer.title AS "Title", Status.Label AS "Status", UNIX_TIMESTAMP(Manufacturer.modified) AS "Modified", UNIX_TIMESTAMP(Manufacturer.created) AS "Created", CONCAT('page/', Manufacturer.page_id) AS "Permalink", DefaultURL.path AS "DefaultURL", DefaultFullURL.path AS "DefaultFullURL" FROM Web_Pages Manufacturer JOIN DM_Statuses Status ON Status.status_id = Manufacturer.status_id LEFT JOIN Web_PagesURLs DefaultURL ON DefaultURL.page_id = Manufacturer.page_id AND DefaultURL.is_default = 1 JOIN DM_URLs DefaultFullURL ON DefaultFullURL.url_id = DefaultURL.url_id WHERE Manufacturer.page_id = '85';

SELECT TaxClass.tax_class_id AS "Id", TaxClass.class_type AS "ClassType", TaxClass.name AS "Name", TaxClass.is_taxable AS "Taxable", TaxClass.is_default AS "Default", TaxClass.is_active AS "Active", UNIX_TIMESTAMP(TaxClass.modified) AS "Modified", TaxClass.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(TaxClass.created) AS "Created", TaxClass.created_by AS "CreatedBy", TaxClass.cue_source AS "CueSource", TaxClass.cue_source_id AS "CueSourceId", TaxClass.cue_ver AS "CueVersion" FROM Ecom_TaxClasses TaxClass WHERE TaxClass.tax_class_id = '7';

SELECT ProductFeature.product_feature_id AS "Id", ProductFeature.product_id AS "ProductId", ProductFeature.feature AS "Feature", ProductFeature.sort_order AS "SortOrder", UNIX_TIMESTAMP(ProductFeature.modified) AS "Modified", ProductFeature.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(ProductFeature.created) AS "Created", ProductFeature.created_by AS "CreatedBy", ProductFeature.cue_source AS "CueSource", ProductFeature.cue_source_id AS "CueSourceId", ProductFeature.cue_ver AS "CueVersion" FROM Ecom_ProductsFeatures ProductFeature WHERE ProductFeature.product_id = 120 ORDER BY ProductFeature.sort_order ASC;

SELECT ProductOption.product_option_id AS "Id", ProductOption.product_id AS "ProductId", ProductOption.product_option_label_id AS "ProductOptionLabelId", ProductOptionLabel.label AS "Label", GROUP_CONCAT(CONCAT(ProductOptionValue.product_option_value_id, '=', ProductOptionValue.value) ORDER BY POLV.sort_order SEPARATOR '|') AS "Values", ProductOption.sort_order AS "SortOrder", UNIX_TIMESTAMP(ProductOption.modified) AS "Modified", ProductOption.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(ProductOption.created) AS "Created", ProductOption.created_by AS "CreatedBy", ProductOption.cue_source AS "CueSource", ProductOption.cue_source_id AS "CueSourceId", ProductOption.cue_ver AS "CueVersion" FROM Ecom_ProductsOptions ProductOption LEFT JOIN Ecom_ProductOptionLabels ProductOptionLabel ON ProductOptionLabel.product_option_label_id = ProductOption.product_option_label_id LEFT JOIN Ecom_ProductsOptionsLabelsValues POLV ON POLV.product_option_label_id = ProductOption.product_option_label_id AND POLV.product_id = ProductOption.product_id LEFT JOIN Ecom_ProductOptionValues ProductOptionValue ON ProductOptionValue.product_option_value_id = POLV.product_option_value_id WHERE ProductOption.product_id = 120 GROUP BY ProductOption.product_option_label_id ORDER BY ProductOption.sort_order ASC, ProductOption.sort_order ASC;

SELECT RelatedProduct.product_related_id AS "Id", RelatedProduct.product_id AS "ProductId", RelatedProduct.related_product_id AS "RelatedProductId", RelPage.title AS "Title", RelProduct.sku AS "SKU", RelatedProduct.sort_order AS "SortOrder", CONCAT(MediaFile.path, ImageFile.thumbnail_filename) AS "ThumbnailURL", UNIX_TIMESTAMP(RelatedProduct.modified) AS "Modified", RelatedProduct.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(RelatedProduct.created) AS "Created", RelatedProduct.created_by AS "CreatedBy", RelatedProduct.cue_source AS "CueSource", RelatedProduct.cue_source_id AS "CueSourceId", RelatedProduct.cue_ver AS "CueVersion" FROM Ecom_ProductsRelated RelatedProduct JOIN Web_Pages RelPage ON RelPage.page_id = RelatedProduct.related_product_id LEFT JOIN FM_MediaFiles MediaFile ON MediaFile.media_file_id = RelPage.image_id LEFT JOIN FM_ImageFiles ImageFile ON ImageFile.media_file_id = RelPage.image_id JOIN Ecom_Products RelProduct ON RelProduct.page_id = RelatedProduct.related_product_id WHERE RelatedProduct.product_id = 120 ORDER BY RelatedProduct.sort_order ASC;

SELECT ProductReview.product_review_id AS "Id", ProductReview.product_id AS "ProductId", Page.title AS "ProductTitle", Product.sku AS "ProductSKU", ProductReview.rating AS "Rating", ProductReview.customer_name AS "CustomerName", ProductReview.customer_email AS "CustomerEmail", ProductReview.subject AS "Subject", ProductReview.body AS "Body", ProductReview.is_active AS "Active", UNIX_TIMESTAMP(ProductReview.modified) AS "Modified", ProductReview.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(ProductReview.created) AS "Created", ProductReview.created_by AS "CreatedBy", ProductReview.cue_source AS "CueSource", ProductReview.cue_source_id AS "CueSourceId", ProductReview.cue_ver AS "CueVersion" FROM Ecom_ProductsReviews ProductReview JOIN Web_Pages Page ON Page.page_id = ProductReview.product_id JOIN Ecom_Products Product ON Product.page_id = ProductReview.product_id WHERE ProductReview.product_id = 120 ORDER BY ProductReview.created DESC;

SELECT ProductSpecification.product_specification_id AS "Id", ProductSpecification.product_id AS "ProductId", ProductSpecification.product_attribute_id AS "ProductAttributeId", ProductSpecification.product_attribute_value_id AS "ProductAttributeValueId", ProductAttribute.label AS "Label", ProductAttributeValue.value AS "Value", ProductSpecification.sort_order AS "SortOrder", ProductAttribute.sort_order AS "AttributeSortOrder", UNIX_TIMESTAMP(ProductSpecification.modified) AS "Modified", ProductSpecification.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(ProductSpecification.created) AS "Created", ProductSpecification.created_by AS "CreatedBy", ProductSpecification.cue_source AS "CueSource", ProductSpecification.cue_source_id AS "CueSourceId", ProductSpecification.cue_ver AS "CueVersion" FROM Ecom_ProductsSpecifications ProductSpecification JOIN Ecom_ProductAttributes ProductAttribute ON ProductAttribute.product_attribute_id = ProductSpecification.product_attribute_id JOIN Ecom_ProductAttributesValues ProductAttributeValue ON ProductAttributeValue.product_attribute_value_id = ProductSpecification.product_attribute_value_id WHERE ProductSpecification.product_id = 120 ORDER BY ProductSpecification.sort_order ASC;
0.0031 (5)


SELECT SQL_CALC_FOUND_ROWS ProductVariant.product_variant_id AS "Id", ProductVariant.product_id AS "ProductId", ProductVariant.title AS "Title", ProductVariant.sku AS "SKU", ProductVariant.part_no AS "PartNo", ProductVariant.barcode AS "Barcode", ProductVariant.use_default_pricing AS "UseDefaultPricing", ProductVariant.regular_price_type AS "RegularPriceType", ProductVariant.regular_price_modifier AS "RegularPriceModifier", ProductVariant.regular_price AS "RegularPrice", Product.regular_price AS "ProductRegularPrice", ProductVariant.sale_price_type AS "SalePriceType", ProductVariant.sale_price_modifier AS "SalePriceModifier", ProductVariant.sale_price AS "SalePrice", Product.sale_price AS "ProductSalePrice", ProductVariant.msrp_type AS "MSRPType", ProductVariant.msrp_modifier AS "MSRPModifier", ProductVariant.msrp_price AS "MSRP", Product.msrp_price AS "ProductMSRP", ProductVariant.cost_type AS "CostType", ProductVariant.cost_modifier AS "CostModifier", ProductVariant.cost_price AS "Cost", (SELECT IF(quantity = 0, MAX(cost_price), SUM(cost_price * quantity) / SUM(quantity)) FROM Ecom_SuppliersProducts WHERE product_id = Product.page_id AND is_active = 1) AS "ProductCost", ProductVariant.use_default_shipping AS "UseDefaultShipping", ProductVariant.dimension_width AS "DimensionWidth", ProductVariant.dimension_width_unit AS "DimensionWidthUnit", Product.dimension_width AS "ProductDimensionWidth", Product.dimension_width_unit AS "ProductDimensionWidthUnit", ProductVariant.dimension_length AS "DimensionLength", ProductVariant.dimension_length_unit AS "DimensionLengthUnit", Product.dimension_length AS "ProductDimensionLength", Product.dimension_length_unit AS "ProductDimensionLengthUnit", ProductVariant.dimension_height AS "DimensionHeight", ProductVariant.dimension_height_unit AS "DimensionHeightUnit", Product.dimension_height AS "ProductDimensionHeight", Product.dimension_height_unit AS "ProductDimensionHeightUnit", ProductVariant.weight AS "Weight", ProductVariant.weight_unit AS "WeightUnit", Product.weight AS "ProductWeight", Product.weight_unit AS "ProductWeightUnit", ProductVariant.shipping_fee AS "ShippingFee", ProductVariant.shipping_value AS "ShippingValue", Product.shipping_fee AS "ProductShippingFee", Product.shipping_value AS "ProductShippingValue", Product.track_variant_inventory AS "ProductTrackVariantInventory", (SELECT SUM(quantity) FROM Ecom_SuppliersProducts WHERE product_variant_id = ProductVariant.product_variant_id AND is_active = 1 GROUP BY product_variant_id) AS "QuantityOnHand", (SELECT SUM(quantity) FROM Ecom_ProductsAllocations WHERE product_variant_id = ProductVariant.product_variant_id GROUP BY product_variant_id) AS "QuantityAllocated", (

SELECT SUM(SupplierProduct.quantity) - IF(Allocation.quantity IS NULL, 0, Allocation.quantity) FROM Ecom_SuppliersProducts SupplierProduct LEFT JOIN (

SELECT product_variant_id, SUM(quantity) AS quantity FROM Ecom_ProductsAllocations GROUP BY product_variant_id ) Allocation ON Allocation.product_variant_id = SupplierProduct.product_variant_id WHERE SupplierProduct.product_variant_id = ProductVariant.product_variant_id AND SupplierProduct.is_active = 1 GROUP BY SupplierProduct.product_variant_id ) AS "Quantity", ProductVariant.image_id AS "Image", ProductVariant.sort_order AS "SortOrder", ProductVariant.is_active AS "Active", ProductVariant.settings AS "Settings", UNIX_TIMESTAMP(ProductVariant.modified) AS "Modified", ProductVariant.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(ProductVariant.created) AS "Created", ProductVariant.created_by AS "CreatedBy", ProductVariant.cue_source AS "CueSource", ProductVariant.cue_source_id AS "CueSourceId", ProductVariant.cue_ver AS "CueVersion" FROM Ecom_ProductsVariants ProductVariant JOIN Ecom_Products Product ON Product.page_id = ProductVariant.product_id WHERE ProductVariant.product_id = 120 AND ProductVariant.is_active = true;

SELECT FOUND_ROWS() AS `Rows`;
0.0014 (2)


SELECT MediaFile.media_file_id AS "Id", MediaFile.media_type AS "MediaType", MediaFile.title AS "Title", MediaFile.version AS "Version", MediaFile.description AS "Description", MediaFile.filename AS "Filename", MediaFile.path AS "Path", MediaFile.target_file AS "File", MediaFile.file_bytes AS "FileBytes", CONCAT(MediaFile.path, MediaFile.target_file) AS "FileURL", MediaFile.hash AS "Hash", MediaFile.mime_type AS "MimeType", MediaFile.show_in_media AS "ShowInMedia", UNIX_TIMESTAMP(MediaFile.status_date) AS "StatusDate", MediaFile.status_id AS "Status", UNIX_TIMESTAMP(MediaFile.modified) AS "Modified", MediaFile.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(MediaFile.created) AS "Created", MediaFile.created_by AS "CreatedBy", MediaFile.cue_source AS "CueSource", MediaFile.cue_source_id AS "CueSourceId", MediaFile.cue_ver AS "CueVersion", ImageFile.alt_text AS "AltText", ImageFile.source_width AS "SourceWidth", ImageFile.source_height AS "SourceHeight", ImageFile.micro_filename AS "MicroFilename", ImageFile.micro_width AS "MicroWidth", ImageFile.micro_height AS "MicroHeight", ImageFile.micro_bytes AS "MicroBytes", CONCAT(MediaFile.path, ImageFile.micro_filename) AS "MicroURL", ImageFile.thumbnail_filename AS "ThumbnailFilename", ImageFile.thumbnail_width AS "ThumbnailWidth", ImageFile.thumbnail_height AS "ThumbnailHeight", ImageFile.thumbnail_bytes AS "ThumbnailBytes", CONCAT(MediaFile.path, ImageFile.thumbnail_filename) AS "ThumbnailURL", ImageFile.small_filename AS "SmallFilename", ImageFile.small_width AS "SmallWidth", ImageFile.small_height AS "SmallHeight", ImageFile.small_bytes AS "SmallBytes", CONCAT(MediaFile.path, ImageFile.small_filename) AS "SmallURL", ImageFile.medium_filename AS "MediumFilename", ImageFile.medium_width AS "MediumWidth", ImageFile.medium_height AS "MediumHeight", ImageFile.medium_bytes AS "MediumBytes", CONCAT(MediaFile.path, ImageFile.medium_filename) AS "MediumURL", ImageFile.large_filename AS "LargeFilename", ImageFile.large_width AS "LargeWidth", ImageFile.large_height AS "LargeHeight", ImageFile.large_bytes AS "LargeBytes", CONCAT(MediaFile.path, ImageFile.large_filename) AS "LargeURL" FROM FM_MediaFiles MediaFile LEFT JOIN FM_ImageFiles ImageFile ON ImageFile.media_file_id = MediaFile.media_file_id WHERE MediaFile.media_file_id = '0';

SELECT ProductVariantOption.product_option_id AS "Id", ProductVariantOption.product_id AS "ProductId", ProductVariantOption.product_variant_id AS "ProductVariantId", ProductVariantOption.product_option_label_id AS "ProductOptionLabelId", ProductVariantOption.product_option_value_id AS "ProductOptionValueId", ProductVariantOption.sort_order AS "SortOrder", Label.label AS "Label", Value.value AS "Value", UNIX_TIMESTAMP(ProductVariantOption.modified) AS "Modified", ProductVariantOption.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(ProductVariantOption.created) AS "Created", ProductVariantOption.created_by AS "CreatedBy", ProductVariantOption.cue_source AS "CueSource", ProductVariantOption.cue_source_id AS "CueSourceId", ProductVariantOption.cue_ver AS "CueVersion" FROM Ecom_ProductsVariantsOptions ProductVariantOption JOIN Ecom_ProductOptionLabels Label ON Label.product_option_label_id = ProductVariantOption.product_option_label_id JOIN Ecom_ProductOptionValues Value ON Value.product_option_value_id = ProductVariantOption.product_option_value_id WHERE ProductVariantOption.product_variant_id = 63 ORDER BY ProductVariantOption.sort_order ASC;

SELECT Author.admin_user_id AS "Id", Author.first_name AS "FirstName", Author.last_name AS "LastName", Author.email AS "Email", TRIM(CONCAT(Author.first_name, ' ', Author.last_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayFirstLast", TRIM(CONCAT(Author.last_name, ', ', Author.first_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayLastFirst" FROM DM_AdminUsers Author WHERE Author.admin_user_id = '0';

SELECT Author.admin_user_id AS "Id", Author.first_name AS "FirstName", Author.last_name AS "LastName", Author.email AS "Email", TRIM(CONCAT(Author.first_name, ' ', Author.last_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayFirstLast", TRIM(CONCAT(Author.last_name, ', ', Author.first_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayLastFirst" FROM DM_AdminUsers Author WHERE Author.admin_user_id = '9';
0.0015 (2)


SELECT MediaFile.media_file_id AS "Id", MediaFile.media_type AS "MediaType", MediaFile.title AS "Title", MediaFile.version AS "Version", MediaFile.description AS "Description", MediaFile.filename AS "Filename", MediaFile.path AS "Path", MediaFile.target_file AS "File", MediaFile.file_bytes AS "FileBytes", CONCAT(MediaFile.path, MediaFile.target_file) AS "FileURL", MediaFile.hash AS "Hash", MediaFile.mime_type AS "MimeType", MediaFile.show_in_media AS "ShowInMedia", UNIX_TIMESTAMP(MediaFile.status_date) AS "StatusDate", MediaFile.status_id AS "Status", UNIX_TIMESTAMP(MediaFile.modified) AS "Modified", MediaFile.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(MediaFile.created) AS "Created", MediaFile.created_by AS "CreatedBy", MediaFile.cue_source AS "CueSource", MediaFile.cue_source_id AS "CueSourceId", MediaFile.cue_ver AS "CueVersion", ImageFile.alt_text AS "AltText", ImageFile.source_width AS "SourceWidth", ImageFile.source_height AS "SourceHeight", ImageFile.micro_filename AS "MicroFilename", ImageFile.micro_width AS "MicroWidth", ImageFile.micro_height AS "MicroHeight", ImageFile.micro_bytes AS "MicroBytes", CONCAT(MediaFile.path, ImageFile.micro_filename) AS "MicroURL", ImageFile.thumbnail_filename AS "ThumbnailFilename", ImageFile.thumbnail_width AS "ThumbnailWidth", ImageFile.thumbnail_height AS "ThumbnailHeight", ImageFile.thumbnail_bytes AS "ThumbnailBytes", CONCAT(MediaFile.path, ImageFile.thumbnail_filename) AS "ThumbnailURL", ImageFile.small_filename AS "SmallFilename", ImageFile.small_width AS "SmallWidth", ImageFile.small_height AS "SmallHeight", ImageFile.small_bytes AS "SmallBytes", CONCAT(MediaFile.path, ImageFile.small_filename) AS "SmallURL", ImageFile.medium_filename AS "MediumFilename", ImageFile.medium_width AS "MediumWidth", ImageFile.medium_height AS "MediumHeight", ImageFile.medium_bytes AS "MediumBytes", CONCAT(MediaFile.path, ImageFile.medium_filename) AS "MediumURL", ImageFile.large_filename AS "LargeFilename", ImageFile.large_width AS "LargeWidth", ImageFile.large_height AS "LargeHeight", ImageFile.large_bytes AS "LargeBytes", CONCAT(MediaFile.path, ImageFile.large_filename) AS "LargeURL" FROM FM_MediaFiles MediaFile LEFT JOIN FM_ImageFiles ImageFile ON ImageFile.media_file_id = MediaFile.media_file_id WHERE MediaFile.media_file_id = '0';

SELECT ProductVariantOption.product_option_id AS "Id", ProductVariantOption.product_id AS "ProductId", ProductVariantOption.product_variant_id AS "ProductVariantId", ProductVariantOption.product_option_label_id AS "ProductOptionLabelId", ProductVariantOption.product_option_value_id AS "ProductOptionValueId", ProductVariantOption.sort_order AS "SortOrder", Label.label AS "Label", Value.value AS "Value", UNIX_TIMESTAMP(ProductVariantOption.modified) AS "Modified", ProductVariantOption.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(ProductVariantOption.created) AS "Created", ProductVariantOption.created_by AS "CreatedBy", ProductVariantOption.cue_source AS "CueSource", ProductVariantOption.cue_source_id AS "CueSourceId", ProductVariantOption.cue_ver AS "CueVersion" FROM Ecom_ProductsVariantsOptions ProductVariantOption JOIN Ecom_ProductOptionLabels Label ON Label.product_option_label_id = ProductVariantOption.product_option_label_id JOIN Ecom_ProductOptionValues Value ON Value.product_option_value_id = ProductVariantOption.product_option_value_id WHERE ProductVariantOption.product_variant_id = 64 ORDER BY ProductVariantOption.sort_order ASC;

SELECT Author.admin_user_id AS "Id", Author.first_name AS "FirstName", Author.last_name AS "LastName", Author.email AS "Email", TRIM(CONCAT(Author.first_name, ' ', Author.last_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayFirstLast", TRIM(CONCAT(Author.last_name, ', ', Author.first_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayLastFirst" FROM DM_AdminUsers Author WHERE Author.admin_user_id = '0';

SELECT Author.admin_user_id AS "Id", Author.first_name AS "FirstName", Author.last_name AS "LastName", Author.email AS "Email", TRIM(CONCAT(Author.first_name, ' ', Author.last_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayFirstLast", TRIM(CONCAT(Author.last_name, ', ', Author.first_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayLastFirst" FROM DM_AdminUsers Author WHERE Author.admin_user_id = '9';
0.0014 (2)


SELECT MediaFile.media_file_id AS "Id", MediaFile.media_type AS "MediaType", MediaFile.title AS "Title", MediaFile.version AS "Version", MediaFile.description AS "Description", MediaFile.filename AS "Filename", MediaFile.path AS "Path", MediaFile.target_file AS "File", MediaFile.file_bytes AS "FileBytes", CONCAT(MediaFile.path, MediaFile.target_file) AS "FileURL", MediaFile.hash AS "Hash", MediaFile.mime_type AS "MimeType", MediaFile.show_in_media AS "ShowInMedia", UNIX_TIMESTAMP(MediaFile.status_date) AS "StatusDate", MediaFile.status_id AS "Status", UNIX_TIMESTAMP(MediaFile.modified) AS "Modified", MediaFile.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(MediaFile.created) AS "Created", MediaFile.created_by AS "CreatedBy", MediaFile.cue_source AS "CueSource", MediaFile.cue_source_id AS "CueSourceId", MediaFile.cue_ver AS "CueVersion", ImageFile.alt_text AS "AltText", ImageFile.source_width AS "SourceWidth", ImageFile.source_height AS "SourceHeight", ImageFile.micro_filename AS "MicroFilename", ImageFile.micro_width AS "MicroWidth", ImageFile.micro_height AS "MicroHeight", ImageFile.micro_bytes AS "MicroBytes", CONCAT(MediaFile.path, ImageFile.micro_filename) AS "MicroURL", ImageFile.thumbnail_filename AS "ThumbnailFilename", ImageFile.thumbnail_width AS "ThumbnailWidth", ImageFile.thumbnail_height AS "ThumbnailHeight", ImageFile.thumbnail_bytes AS "ThumbnailBytes", CONCAT(MediaFile.path, ImageFile.thumbnail_filename) AS "ThumbnailURL", ImageFile.small_filename AS "SmallFilename", ImageFile.small_width AS "SmallWidth", ImageFile.small_height AS "SmallHeight", ImageFile.small_bytes AS "SmallBytes", CONCAT(MediaFile.path, ImageFile.small_filename) AS "SmallURL", ImageFile.medium_filename AS "MediumFilename", ImageFile.medium_width AS "MediumWidth", ImageFile.medium_height AS "MediumHeight", ImageFile.medium_bytes AS "MediumBytes", CONCAT(MediaFile.path, ImageFile.medium_filename) AS "MediumURL", ImageFile.large_filename AS "LargeFilename", ImageFile.large_width AS "LargeWidth", ImageFile.large_height AS "LargeHeight", ImageFile.large_bytes AS "LargeBytes", CONCAT(MediaFile.path, ImageFile.large_filename) AS "LargeURL" FROM FM_MediaFiles MediaFile LEFT JOIN FM_ImageFiles ImageFile ON ImageFile.media_file_id = MediaFile.media_file_id WHERE MediaFile.media_file_id = '0';

SELECT ProductVariantOption.product_option_id AS "Id", ProductVariantOption.product_id AS "ProductId", ProductVariantOption.product_variant_id AS "ProductVariantId", ProductVariantOption.product_option_label_id AS "ProductOptionLabelId", ProductVariantOption.product_option_value_id AS "ProductOptionValueId", ProductVariantOption.sort_order AS "SortOrder", Label.label AS "Label", Value.value AS "Value", UNIX_TIMESTAMP(ProductVariantOption.modified) AS "Modified", ProductVariantOption.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(ProductVariantOption.created) AS "Created", ProductVariantOption.created_by AS "CreatedBy", ProductVariantOption.cue_source AS "CueSource", ProductVariantOption.cue_source_id AS "CueSourceId", ProductVariantOption.cue_ver AS "CueVersion" FROM Ecom_ProductsVariantsOptions ProductVariantOption JOIN Ecom_ProductOptionLabels Label ON Label.product_option_label_id = ProductVariantOption.product_option_label_id JOIN Ecom_ProductOptionValues Value ON Value.product_option_value_id = ProductVariantOption.product_option_value_id WHERE ProductVariantOption.product_variant_id = 65 ORDER BY ProductVariantOption.sort_order ASC;

SELECT Author.admin_user_id AS "Id", Author.first_name AS "FirstName", Author.last_name AS "LastName", Author.email AS "Email", TRIM(CONCAT(Author.first_name, ' ', Author.last_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayFirstLast", TRIM(CONCAT(Author.last_name, ', ', Author.first_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayLastFirst" FROM DM_AdminUsers Author WHERE Author.admin_user_id = '0';

SELECT Author.admin_user_id AS "Id", Author.first_name AS "FirstName", Author.last_name AS "LastName", Author.email AS "Email", TRIM(CONCAT(Author.first_name, ' ', Author.last_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayFirstLast", TRIM(CONCAT(Author.last_name, ', ', Author.first_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayLastFirst" FROM DM_AdminUsers Author WHERE Author.admin_user_id = '9';
0.0013 (2)


SELECT MediaFile.media_file_id AS "Id", MediaFile.media_type AS "MediaType", MediaFile.title AS "Title", MediaFile.version AS "Version", MediaFile.description AS "Description", MediaFile.filename AS "Filename", MediaFile.path AS "Path", MediaFile.target_file AS "File", MediaFile.file_bytes AS "FileBytes", CONCAT(MediaFile.path, MediaFile.target_file) AS "FileURL", MediaFile.hash AS "Hash", MediaFile.mime_type AS "MimeType", MediaFile.show_in_media AS "ShowInMedia", UNIX_TIMESTAMP(MediaFile.status_date) AS "StatusDate", MediaFile.status_id AS "Status", UNIX_TIMESTAMP(MediaFile.modified) AS "Modified", MediaFile.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(MediaFile.created) AS "Created", MediaFile.created_by AS "CreatedBy", MediaFile.cue_source AS "CueSource", MediaFile.cue_source_id AS "CueSourceId", MediaFile.cue_ver AS "CueVersion", ImageFile.alt_text AS "AltText", ImageFile.source_width AS "SourceWidth", ImageFile.source_height AS "SourceHeight", ImageFile.micro_filename AS "MicroFilename", ImageFile.micro_width AS "MicroWidth", ImageFile.micro_height AS "MicroHeight", ImageFile.micro_bytes AS "MicroBytes", CONCAT(MediaFile.path, ImageFile.micro_filename) AS "MicroURL", ImageFile.thumbnail_filename AS "ThumbnailFilename", ImageFile.thumbnail_width AS "ThumbnailWidth", ImageFile.thumbnail_height AS "ThumbnailHeight", ImageFile.thumbnail_bytes AS "ThumbnailBytes", CONCAT(MediaFile.path, ImageFile.thumbnail_filename) AS "ThumbnailURL", ImageFile.small_filename AS "SmallFilename", ImageFile.small_width AS "SmallWidth", ImageFile.small_height AS "SmallHeight", ImageFile.small_bytes AS "SmallBytes", CONCAT(MediaFile.path, ImageFile.small_filename) AS "SmallURL", ImageFile.medium_filename AS "MediumFilename", ImageFile.medium_width AS "MediumWidth", ImageFile.medium_height AS "MediumHeight", ImageFile.medium_bytes AS "MediumBytes", CONCAT(MediaFile.path, ImageFile.medium_filename) AS "MediumURL", ImageFile.large_filename AS "LargeFilename", ImageFile.large_width AS "LargeWidth", ImageFile.large_height AS "LargeHeight", ImageFile.large_bytes AS "LargeBytes", CONCAT(MediaFile.path, ImageFile.large_filename) AS "LargeURL" FROM FM_MediaFiles MediaFile LEFT JOIN FM_ImageFiles ImageFile ON ImageFile.media_file_id = MediaFile.media_file_id WHERE MediaFile.media_file_id = '0';

SELECT ProductVariantOption.product_option_id AS "Id", ProductVariantOption.product_id AS "ProductId", ProductVariantOption.product_variant_id AS "ProductVariantId", ProductVariantOption.product_option_label_id AS "ProductOptionLabelId", ProductVariantOption.product_option_value_id AS "ProductOptionValueId", ProductVariantOption.sort_order AS "SortOrder", Label.label AS "Label", Value.value AS "Value", UNIX_TIMESTAMP(ProductVariantOption.modified) AS "Modified", ProductVariantOption.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(ProductVariantOption.created) AS "Created", ProductVariantOption.created_by AS "CreatedBy", ProductVariantOption.cue_source AS "CueSource", ProductVariantOption.cue_source_id AS "CueSourceId", ProductVariantOption.cue_ver AS "CueVersion" FROM Ecom_ProductsVariantsOptions ProductVariantOption JOIN Ecom_ProductOptionLabels Label ON Label.product_option_label_id = ProductVariantOption.product_option_label_id JOIN Ecom_ProductOptionValues Value ON Value.product_option_value_id = ProductVariantOption.product_option_value_id WHERE ProductVariantOption.product_variant_id = 66 ORDER BY ProductVariantOption.sort_order ASC;

SELECT Author.admin_user_id AS "Id", Author.first_name AS "FirstName", Author.last_name AS "LastName", Author.email AS "Email", TRIM(CONCAT(Author.first_name, ' ', Author.last_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayFirstLast", TRIM(CONCAT(Author.last_name, ', ', Author.first_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayLastFirst" FROM DM_AdminUsers Author WHERE Author.admin_user_id = '0';

SELECT Author.admin_user_id AS "Id", Author.first_name AS "FirstName", Author.last_name AS "LastName", Author.email AS "Email", TRIM(CONCAT(Author.first_name, ' ', Author.last_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayFirstLast", TRIM(CONCAT(Author.last_name, ', ', Author.first_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayLastFirst" FROM DM_AdminUsers Author WHERE Author.admin_user_id = '9';
0.0018 (4)


SELECT c.label AS "Label", d.value AS "Value", SUM(e.quantity) - IF(f.quantity IS NULL, 0, f.quantity) AS "quantity" FROM Ecom_ProductsVariantsOptions a JOIN Ecom_ProductsOptions b ON b.product_id = a.product_id AND b.product_option_label_id = a.product_option_label_id JOIN Ecom_ProductOptionLabels c ON c.product_option_label_id = a.product_option_label_id JOIN Ecom_ProductOptionValues d ON d.product_option_value_id = a.product_option_value_id JOIN Ecom_SuppliersProducts e ON e.product_variant_id = a.product_variant_id AND e.is_active = 1 left join Ecom_ProductsAllocations f ON f.product_variant_id = a.product_variant_id WHERE a.product_id = 120 GROUP BY c.label, d.value ORDER BY b.sort_order ASC;
0.0011 (0)


SELECT Promotion.promotion_id AS "Id", Promotion.promotion_type AS "PromotionType", Promotion.banner_html AS "BannerHTML", Promotion.meta AS "Meta", Promotion.maximum_uses AS "MaximumUses", Promotion.used_count AS "UsedCount" FROM Ecom_Promotions Promotion WHERE UNIX_TIMESTAMP(Promotion.effective_on) <= 1743747050 AND UNIX_TIMESTAMP(Promotion.expires_on) >= 1743747050 AND Promotion.banner_html <> '\'\'' AND Promotion.is_active = true;
0.0006 (0)


SELECT Menu.menu_id AS "Id", Menu.name AS "Name", Menu.title AS "Title", Menu.tag_id AS "TagId", Menu.tag_class AS "TagClass", Menu.icon_class AS "IconClass", Menu.is_auto_events_enabled AS "EnableAutoEvents", Menu.is_admin AS "Admin", Menu.is_visible AS "Visible", Menu.show_children AS "ShowChildren", Menu.is_active AS "Active", UNIX_TIMESTAMP(Menu.modified) AS "Modified", Menu.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(Menu.created) AS "Created", Menu.created_by AS "CreatedBy", Menu.cue_source AS "CueSource", Menu.cue_source_id AS "CueSourceId", Menu.cue_ver AS "CueVersion" FROM Menu_Menus Menu WHERE Menu.tag_id = 'mobile-menu' AND Menu.is_active = 1;
0.0007 (1)


SELECT Menu.menu_id AS "Id", Menu.name AS "Name", Menu.title AS "Title", Menu.tag_id AS "TagId", Menu.tag_class AS "TagClass", Menu.icon_class AS "IconClass", Menu.is_auto_events_enabled AS "EnableAutoEvents", Menu.is_admin AS "Admin", Menu.is_visible AS "Visible", Menu.show_children AS "ShowChildren", Menu.is_active AS "Active", UNIX_TIMESTAMP(Menu.modified) AS "Modified", Menu.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(Menu.created) AS "Created", Menu.created_by AS "CreatedBy", Menu.cue_source AS "CueSource", Menu.cue_source_id AS "CueSourceId", Menu.cue_ver AS "CueVersion" FROM Menu_Menus Menu WHERE Menu.tag_id = 'primary-menu' AND Menu.is_active = 1;
0.0007 (12)


SELECT MenuItem.menu_item_id AS "Id", MenuItem.menu_id AS "MenuId", MenuItem.name AS "Name", MenuItem.item_type AS "ItemType", MenuItem.tag_id AS "TagId", MenuItem.tag_class AS "TagClass", MenuItem.link_to AS "LinkTo", MenuItem.url_id AS "URLId", MenuItem.tag_url AS "TagURL", MenuItem.tag_title AS "TagTitle", MenuItem.tag_target_blank AS "TagTargetBlank", MenuItem.icon_class AS "IconClass", MenuItem.onclick_event AS "OnClickEvent", MenuItem.html AS "HTML", MenuItem.is_visible AS "Visible", MenuItem.show_children AS "ShowChildren", MenuItem.sort_order AS "SortOrder", MenuItem.depth AS "Depth", MenuItem.allowed_roles AS "AllowedRoles", MenuItem.is_active AS "Active", UNIX_TIMESTAMP(MenuItem.modified) AS "Modified", MenuItem.modified_by AS "ModifiedBy.Id", UNIX_TIMESTAMP(MenuItem.created) AS "Created", MenuItem.created_by AS "CreatedBy.Id", MenuItem.cue_source AS "CueSource", MenuItem.cue_source_id AS "CueSourceId", MenuItem.cue_ver AS "CueVersion", URL.path AS "ContentURL" FROM Menu_MenusItems MenuItem LEFT JOIN DM_URLs URL ON URL.url_id = MenuItem.url_id LEFT JOIN DM_AdminUsers ModifiedBy ON ModifiedBy.admin_user_id = MenuItem.modified_by LEFT JOIN DM_AdminUsers CreatedBy ON CreatedBy.admin_user_id = MenuItem.created_by WHERE MenuItem.menu_id = 2 ORDER BY MenuItem.sort_order ASC, MenuItem.sort_order;
0.0007 (1)


SELECT Menu.menu_id AS "Id", Menu.name AS "Name", Menu.title AS "Title", Menu.tag_id AS "TagId", Menu.tag_class AS "TagClass", Menu.icon_class AS "IconClass", Menu.is_auto_events_enabled AS "EnableAutoEvents", Menu.is_admin AS "Admin", Menu.is_visible AS "Visible", Menu.show_children AS "ShowChildren", Menu.is_active AS "Active", UNIX_TIMESTAMP(Menu.modified) AS "Modified", Menu.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(Menu.created) AS "Created", Menu.created_by AS "CreatedBy", Menu.cue_source AS "CueSource", Menu.cue_source_id AS "CueSourceId", Menu.cue_ver AS "CueVersion" FROM Menu_Menus Menu WHERE Menu.tag_id = 'footer-menu-1' AND Menu.is_active = 1;
0.0007 (6)


SELECT MenuItem.menu_item_id AS "Id", MenuItem.menu_id AS "MenuId", MenuItem.name AS "Name", MenuItem.item_type AS "ItemType", MenuItem.tag_id AS "TagId", MenuItem.tag_class AS "TagClass", MenuItem.link_to AS "LinkTo", MenuItem.url_id AS "URLId", MenuItem.tag_url AS "TagURL", MenuItem.tag_title AS "TagTitle", MenuItem.tag_target_blank AS "TagTargetBlank", MenuItem.icon_class AS "IconClass", MenuItem.onclick_event AS "OnClickEvent", MenuItem.html AS "HTML", MenuItem.is_visible AS "Visible", MenuItem.show_children AS "ShowChildren", MenuItem.sort_order AS "SortOrder", MenuItem.depth AS "Depth", MenuItem.allowed_roles AS "AllowedRoles", MenuItem.is_active AS "Active", UNIX_TIMESTAMP(MenuItem.modified) AS "Modified", MenuItem.modified_by AS "ModifiedBy.Id", UNIX_TIMESTAMP(MenuItem.created) AS "Created", MenuItem.created_by AS "CreatedBy.Id", MenuItem.cue_source AS "CueSource", MenuItem.cue_source_id AS "CueSourceId", MenuItem.cue_ver AS "CueVersion", URL.path AS "ContentURL" FROM Menu_MenusItems MenuItem LEFT JOIN DM_URLs URL ON URL.url_id = MenuItem.url_id LEFT JOIN DM_AdminUsers ModifiedBy ON ModifiedBy.admin_user_id = MenuItem.modified_by LEFT JOIN DM_AdminUsers CreatedBy ON CreatedBy.admin_user_id = MenuItem.created_by WHERE MenuItem.menu_id = 3 ORDER BY MenuItem.sort_order ASC, MenuItem.sort_order;
0.0007 (1)


SELECT Menu.menu_id AS "Id", Menu.name AS "Name", Menu.title AS "Title", Menu.tag_id AS "TagId", Menu.tag_class AS "TagClass", Menu.icon_class AS "IconClass", Menu.is_auto_events_enabled AS "EnableAutoEvents", Menu.is_admin AS "Admin", Menu.is_visible AS "Visible", Menu.show_children AS "ShowChildren", Menu.is_active AS "Active", UNIX_TIMESTAMP(Menu.modified) AS "Modified", Menu.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(Menu.created) AS "Created", Menu.created_by AS "CreatedBy", Menu.cue_source AS "CueSource", Menu.cue_source_id AS "CueSourceId", Menu.cue_ver AS "CueVersion" FROM Menu_Menus Menu WHERE Menu.tag_id = 'footer-menu-2' AND Menu.is_active = 1;
0.0007 (4)


SELECT MenuItem.menu_item_id AS "Id", MenuItem.menu_id AS "MenuId", MenuItem.name AS "Name", MenuItem.item_type AS "ItemType", MenuItem.tag_id AS "TagId", MenuItem.tag_class AS "TagClass", MenuItem.link_to AS "LinkTo", MenuItem.url_id AS "URLId", MenuItem.tag_url AS "TagURL", MenuItem.tag_title AS "TagTitle", MenuItem.tag_target_blank AS "TagTargetBlank", MenuItem.icon_class AS "IconClass", MenuItem.onclick_event AS "OnClickEvent", MenuItem.html AS "HTML", MenuItem.is_visible AS "Visible", MenuItem.show_children AS "ShowChildren", MenuItem.sort_order AS "SortOrder", MenuItem.depth AS "Depth", MenuItem.allowed_roles AS "AllowedRoles", MenuItem.is_active AS "Active", UNIX_TIMESTAMP(MenuItem.modified) AS "Modified", MenuItem.modified_by AS "ModifiedBy.Id", UNIX_TIMESTAMP(MenuItem.created) AS "Created", MenuItem.created_by AS "CreatedBy.Id", MenuItem.cue_source AS "CueSource", MenuItem.cue_source_id AS "CueSourceId", MenuItem.cue_ver AS "CueVersion", URL.path AS "ContentURL" FROM Menu_MenusItems MenuItem LEFT JOIN DM_URLs URL ON URL.url_id = MenuItem.url_id LEFT JOIN DM_AdminUsers ModifiedBy ON ModifiedBy.admin_user_id = MenuItem.modified_by LEFT JOIN DM_AdminUsers CreatedBy ON CreatedBy.admin_user_id = MenuItem.created_by WHERE MenuItem.menu_id = 4 ORDER BY MenuItem.sort_order ASC, MenuItem.sort_order;
Recent URLs
/robots.txt
Request
URL: /easter-brunch/capital-city-country-club-member-ticket-1
Referer: