SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 601109 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 601109 [ RunTime:0.002828s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (639505,123379,788867,714785,515600,302023,698635,829659,622965,244553,48395,642743,726966,522696,100105,996436,481264,814978,331370,968640,674382,320024,253564,211739,836436,712051,453214,808551,520668,150803,907543,1025072,154660,869241,247185,615238,809629,1021858,982082,442210,913778,165510,586810,616316,782630,205262,932347,117708,492893,186729,800386,1031616,192559,842015,830471,337651,444736,101498,62270,83436) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 601109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 601109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001034s ]