SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003928 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003928 [ RunTime:0.003851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (762591,369937,739197,215615,31322,257111,323311,502700,757380,745164,363349,146523,159739,978945,951907,143454,859351,837303,940935,973701,90339,425816,954236,744518,916216,39465,519242,554909,532992,340021,87485,444369,636308,955320,565944,379390,547995,301866,986298,728836,534560,856054,273025,758399,644724,470435,1019296,638385,815122,92312,908897,233850,574232,155413,198296,232405,559996,857805,257881,405133) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]