SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000943s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486097 LIMIT 1 [ RunTime:0.000283s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486097 [ RunTime:0.003114s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (814148,56743,315148,780898,262700,993872,268110,1016923,223803,814582,865056,324442,1023920,605160,496008,919910,366772,1006196,765561,1007745,574684,718752,356289,404909,600843,543951,505897,1017307,741886,466092,353224,616659,438956,159269,793547,450452,508210,152701,514656,481387,66798,98015,712440,759978,972752,547991,179589,798265,219407,283960,773417,854944,649263,565554,104444,913946,1039526,834280,373532,500678) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001616s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]