Skip to content

Instantly share code, notes, and snippets.

@merk
Created September 6, 2012 01:55
Show Gist options
  • Save merk/3649837 to your computer and use it in GitHub Desktop.
Save merk/3649837 to your computer and use it in GitHub Desktop.
Differences in queries logged in symfony and mysql
2 Query INSERT INTO payment_instructions (amount, approved_amount, approving_amount, created_at, credited_amount, crediting_amount, currency, deposited_amount, depositing_amount, extended_data, payment_system_name, reversing_approved_amount, reversing_credited_amount, reversing_deposited_amount, state, updated_at) VALUES ('795.85', '0', '0', '2012-09-06 11:53:34', '0', '0', 'AUD', '0', '0', 'a:5:{s:11:\"expiryMonth\";a:3:{i:0;s:56:\"laYg+WRlzAbOFkEOsjOn5AMoFEVRa0HyONOJDsT77G0LL7qn8TDlUec=\";i:1;b:1;i:2;b:1;}s:10:\"expiryYear\";a:3:{i:0;s:52:\"MWYNfAMqfw3CdHzBkmxxqJvc9Ccg4QXnYxWTDRvOW5kyNmp8gA==\";i:1;b:1;i:2;b:1;}s:14:\"cardHolderName\";a:3:{i:0;s:56:\"03XlAKyOdQogZAOb2aGD4CBftkcZD1NcnedaR2CMRvnFkUbXO/kWVNO+\";i:1;b:1;i:2;b:1;}s:32:\"customer.customerReferenceNumber\";a:3:{i:0;s:68:\"LxeMcU+bcWaJDFbdq6lhxX0jp8GSLO6if2Sb8IHSr0RaHD+vUkYssa6Udn6K+i3XNQO4\";i:1;b:1;i:2;b:1;}s:11:\"censoredPan\";a:3:{i:0;s:76:\"h46otrelevM/ihzNcw3C0kDQRxnggFQ38t4e/wi8Scn4Zvs6BzCX/lf/KB3pOFzSkxvxILZs0IU=\";i:1;b:1;i:2;b:1;}}', 'infinite_payment_payway_api', '0', '0', '0', 4, '2012-09-06 11:53:34')
2 Query INSERT INTO revisions (timestamp, username) VALUES ('2012-09-06 11:53:34', 'tim')
2 Query INSERT INTO payment_instructions_audit (rev, revtype, amount, approved_amount, approving_amount, created_at, credited_amount, crediting_amount, currency, deposited_amount, depositing_amount, extended_data, payment_system_name, reversing_approved_amount, reversing_credited_amount, reversing_deposited_amount, state, updated_at, id) VALUES ('864', 'INS', '795.85', '0', '0', '2012-09-06 11:53:34', '0', '0', 'AUD', '0', '0', 'a:5:{s:11:\"expiryMonth\";a:3:{i:0;s:56:\"25By4MJh54zFcGAfkI5pUmYYKU0aT8gHQDMN98ZfURRKtXI+TY+aXv4=\";i:1;b:1;i:2;b:1;}s:10:\"expiryYear\";a:3:{i:0;s:52:\"JEn+4LNc0Q9Om3iBIiFt+u2hYgSTwVZMdlA0U25NihTzqiGxfg==\";i:1;b:1;i:2;b:1;}s:14:\"cardHolderName\";a:3:{i:0;s:56:\"SLgz8ojKP+LrU6O7U2g86DC877jk/Y+nWvvy3yIGpr44lWqwF7S3lxgE\";i:1;b:1;i:2;b:1;}s:32:\"customer.customerReferenceNumber\";a:3:{i:0;s:68:\"YcV8eV7T6z+x6mZGQ2N5wrPCBeGALtK4J/j3pKQkKyU0T6mkFMwfj301Ag3FWU+m7tdp\";i:1;b:1;i:2;b:1;}s:11:\"censoredPan\";a:3:{i:0;s:76:\"v+Y50k6WpE+dp3xXTlpBjlSzGWzF743rPqvdUUJRtnw1yER2s6Gor4mBzYcFmjWqlnScvl2OwBU=\";i:1;b:1;i:2;b:1;}}', 'infinite_payment_payway_api', '0', '0', '0', 4, '2012-09-06 11:53:34', 9)
INSERT INTO payment_instructions (amount, approved_amount, approving_amount, created_at, credited_amount, crediting_amount, currency, deposited_amount, depositing_amount, extended_data, payment_system_name, reversing_approved_amount, reversing_credited_amount, reversing_deposited_amount, state, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: { 1: 795.85, 2: 0, 3: 0, 4: '2012-09-06 11:53:34', 5: 0, 6: 0, 7: AUD, 8: 0, 9: 0, 10: 'a:9:{s:11:"expiryMonth";a:3:{i:0;s:56:"jlZ1SZcoysVBCpuEOaws1ZlWpOvIVhkczw0Cqt2oPh4RlPOsunwKTIw=";i:1;b:1;i:2;b:1;}s:10:"expiryYear";a:3:{i:0;s:52:"NCONZ8qZxKlewG9CBNgVVkxgqKvyM9x+MaRk4VB4mrPvzw02Vw==";i:1;b:1;i:2;b:1;}s:14:"cardHolderName";a:3:{i:0;s:56:"ZQ2FkPRMGOhqSn3vBiE1sCh2HfENnH4VwbDVoQkNoQPKmJomp2AzCkov";i:1;b:1;i:2;b:1;}s:32:"customer.customerReferenceNumber";a:3:{i:0;s:68:"+dopgLZGtkCGCgsenncljtiVwjpynnHweI1o7bV+u8ILGrwhuX5drgFUCps95MgXHMkX";i:1;b:1;i:2;b:1;}s:11:"censoredPan";a:3:{i:0;s:76:"K+Nz5WjBdsMtOU/HtCVjmdhZGrvY2quCRO7ejf32L8i2kHpvfCN15BdLAwLlyzoaI6mtJ1ZQ3Ig=";i:1;b:1;i:2;b:1;}s:9:"receiptNo";a:3:{i:0;s:64:"BD/Hr9mEMxPpIppW/4ZNh+u4MRoNta4XXyOUDdsM2SDZ0Oah9V5qX1PAovNCd8hJ";i:1;b:1;i:2;b:1;}s:12:"responseCode";a:3:{i:0;s:56:"BBeN+FkJBZk4kNXIrrKlOzo8Z9qfKrClQDlKf9+PKHZjIxSzF2B/j6I=";i:1;b:1;i:2;b:1;}s:14:"settlementDate";a:3:{i:0;s:64:"53KiiW0YoPOuodVOeeevch1fPxBZSlJJttH3aIfdBVClGp/3mEEkgR/45ysJaZQ=";i:1;b:1;i:2;b:1;}s:15:"transactionDate";a:3:{i:0;s:80:"cO8pj+s2ZSLhNdsXYvpuPLsx/QIS+5iAH0KaZ2cJ0DwSi331EGIM74OWdHzPSPIZntJc74frMDVdghHy";i:1;b:1;i:2;b:1;}}', 11: infinite_payment_payway_api, 12: 0, 13: 0, 14: 0, 15: 4, 16: '2012-09-06 11:53:34' }
Time: 0.31 ms
INSERT INTO revisions (timestamp, username) VALUES (?, ?)
Parameters: ['2012-09-06 11:53:34', tim]
Time: 0.19 ms
INSERT INTO payment_instructions_audit (rev, revtype, amount, approved_amount, approving_amount, created_at, credited_amount, crediting_amount, currency, deposited_amount, depositing_amount, extended_data, payment_system_name, reversing_approved_amount, reversing_credited_amount, reversing_deposited_amount, state, updated_at, id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: ['864', INS, 795.85, 0, 0, '2012-09-06 11:53:34', 0, 0, AUD, 0, 0, 'a:9:{s:11:"expiryMonth";a:3:{i:0;s:56:"0Z1PxoZHmZavuXC/IbOdeOUevwRuwgstRqS8xnZ08v/kSC0bnN9VplY=";i:1;b:1;i:2;b:1;}s:10:"expiryYear";a:3:{i:0;s:52:"gtAc2PN8arn808YGVZkE12XSklnNWOy8cC2x3EEU77ilf9U2JQ==";i:1;b:1;i:2;b:1;}s:14:"cardHolderName";a:3:{i:0;s:56:"cfFuWwC6b+A/5sXj1vi5ddVc0iL+A6UeZ5nGaUYQfyRmwihJz0V0EaIB";i:1;b:1;i:2;b:1;}s:32:"customer.customerReferenceNumber";a:3:{i:0;s:68:"gfguSiLO8aomuxFTrhHXrJPQoOFSzQxH0wlcmsJQ6sJKWewu9cnPLKVJM9ug0hCfhqFN";i:1;b:1;i:2;b:1;}s:11:"censoredPan";a:3:{i:0;s:76:"QvWYX7+O99VJXh8y9ornANlWYqOZWJN5PfwTC0tmghSJ17j0wZVPY4dGwFLoWAEdtWSKebVslOg=";i:1;b:1;i:2;b:1;}s:9:"receiptNo";a:3:{i:0;s:64:"tLXWq6JuXZ1kTf+6Wj95x9Cptluutd7sFwYXALNw10lVa2noyqHKyMvWKqaMOgt+";i:1;b:1;i:2;b:1;}s:12:"responseCode";a:3:{i:0;s:56:"LRzFBipFx5Zjh6bTyyf8BxZC7dBDk694ZeninCG4Ulja25+HGdT+38I=";i:1;b:1;i:2;b:1;}s:14:"settlementDate";a:3:{i:0;s:64:"u0R8vorhHXD1weJgqoDCjjto2NTEOThbmu3jqzOyrM7h4+gggVQyBpQL/548MQE=";i:1;b:1;i:2;b:1;}s:15:"transactionDate";a:3:{i:0;s:80:"POpyn13Sgnm9Q7Wg5X9sNBZF9z7obkIUw4Hy1JnhTjmV8N46pHrk7EujU1YPheL7rbIsoLD7WDE/FBj+";i:1;b:1;i:2;b:1;}}', infinite_payment_payway_api, 0, 0, 0, 4, '2012-09-06 11:53:34', 9]
Time: 1.26 ms
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment