SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 264522 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 264522 [ RunTime:0.002307s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (561039,76023,427295,703155,521557,364250,180311,47374,291811,40554,413143,740613,526698,668941,688463,222094,932508,229244,654285,311494,402077,222096,329717,589915,123917,976671,989554,774362,745657,313171,955744,986757,840981,119772,506027,644474,930748,150269,253518,560767,188041,336621,397804,740551,347326,401052,448742,409360,652224,989137,330017,454894,756021,945814,624412,1007056,920597,268241,582265,820188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 264522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 264522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]