SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415030 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415030 [ RunTime:0.002375s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (958491,960305,95382,142031,880464,604229,730173,684300,416953,763164,441701,983039,867957,143341,76235,190059,45552,747726,77629,420430,946027,979072,775629,263011,201497,496646,948565,109432,546357,1024432,608907,648792,205462,100177,517794,940086,417772,172712,972257,658185,244645,499677,960657,1002375,972577,769512,988047,677778,419168,442135,69757,840321,985892,589587,803765,302549,638384,589794,899215,690429) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415030 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415030 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]