SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496894 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496894 [ RunTime:0.003182s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (817652,945479,13790,422332,959047,431329,300075,565960,821943,733312,806515,566302,207134,755743,494871,864322,95799,58824,986263,961069,293814,53705,951258,328560,277645,264794,974125,604433,440212,274201,121102,669741,23638,29913,914781,940423,699794,169990,213075,253677,798628,212172,698937,1007187,612266,286111,971265,964085,249125,266300,718602,893261,33331,646295,900973,883003,182216,613602,302057,509577) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]