SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509698 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509698 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (84120,464310,920918,495850,995280,1000761,421798,466449,732699,660366,200633,468128,776335,105021,972606,325999,209740,795970,823199,420783,722279,1039531,771703,218768,648541,865005,384026,922193,876610,551511,274681,14863,928080,567737,941812,720079,318446,915878,891310,916627,357867,373520,479647,692092,59807,575922,857560,879022,795483,183908,12587,723913,342179,361038,672405,972562,13802,468579,166344,658759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]