SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804368 LIMIT 1 [ RunTime:0.000512s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804368 [ RunTime:0.002129s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414811,74546,507098,429746,175483,61502,815594,45460,544782,845984,1044914,347118,727700,767506,1032955,464733,552008,428667,257601,918105,863811,206381,239469,548800,677805,530255,893040,99327,371721,504573,271930,180310,385069,80740,786926,169016,4261,86368,755131,837121,753829,173962,63721,409007,830178,9430,198713,787552,107048,599629,926651,491441,639987,133543,452160,744263,133296,109729,328844,954140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804368 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804368 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]