SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001410s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 705281 LIMIT 1 [ RunTime:0.002348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 705281 [ RunTime:0.003963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (214509,778811,7996,874325,857580,689789,300788,106768,607143,616051,111295,385309,619770,659597,572340,409543,992225,905988,401583,257850,65575,709080,675295,360724,1025195,143827,458214,965788,340018,560371,743192,656959,654476,839509,52136,424387,192272,548959,182933,73339,211301,34718,630578,118166,406151,393796,957987,526713,525591,252461,676678,54900,230178,895457,658393,917880,512273,972946,191858,966812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 705281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 705281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001119s ]