SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105222 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105222 [ RunTime:0.003294s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (910639,681104,960381,739520,143409,1023037,785186,135097,889210,686161,850273,448037,746689,1019119,11386,362301,34474,653430,875107,942055,702972,927004,687323,469582,123412,895329,43927,804000,585245,692844,453316,946447,823196,492232,217779,460574,233783,812209,314887,221335,44024,474584,378177,345634,800470,499512,806452,1007150,1044260,137589,400840,481755,904644,856303,162700,301474,844599,742215,663338,665321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]