SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681545 LIMIT 1 [ RunTime:0.000671s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681545 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (678280,982402,515092,642693,35874,2844,320597,803806,137756,753518,528041,249659,508965,523508,744961,7295,737560,492863,622811,604720,144336,728675,957303,104992,39158,245176,1012362,965635,915005,262843,145080,343889,385056,539438,127228,266475,815669,3216,644986,538896,244818,37798,521782,605819,1030444,1016388,491164,861973,484022,52730,204117,1010156,543255,651171,826036,370936,848846,1039830,127772,282089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000850s ]