SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524941 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524941 [ RunTime:0.003722s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281187,907834,460184,204090,663297,338417,331088,809741,752425,388902,918709,625644,455385,942890,512854,115196,894162,28146,80894,387550,56368,761890,300946,72929,136805,839892,636587,584394,711770,778147,574136,433864,75628,288602,881558,548498,851939,142658,288110,329258,1040355,419753,582341,895787,880790,787016,10805,714292,698893,1018320,388182,646283,31166,711485,109967,918812,98239,820654,780901,11867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]