SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578108 LIMIT 1 [ RunTime:0.000943s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578108 [ RunTime:0.001847s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328894,604570,325860,249961,1044466,956680,47510,278496,73488,58426,357049,274559,468015,482479,653888,134886,571856,222915,147108,1009573,527714,566992,576490,84047,234068,120208,488983,613168,237548,458061,237708,662819,188769,723983,733053,922965,746110,902037,327623,298626,158922,1005030,35294,736368,678559,261764,372512,129135,504005,774765,575133,802254,900859,907160,459012,715608,446214,698525,334394,463334) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.021564s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001870s ]