SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568033 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568033 [ RunTime:0.001881s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621025,431614,370848,501073,688848,168960,682606,772835,506725,172081,544310,871686,193093,659556,799505,945149,411506,104949,427158,424744,785929,213716,257620,489304,466335,936860,338841,389658,10949,827591,840600,913117,902494,328182,356850,624520,658898,132119,856383,931541,1042953,1009097,579930,874481,918039,112524,95947,435288,843476,26886,98809,196346,766841,550666,361002,567175,809530,139925,222940,698234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568033 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568033 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000753s ]