SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447880 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447880 [ RunTime:0.001651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (64343,927825,176901,437469,869314,297901,535794,195592,985675,485365,356856,87181,1014725,301596,519412,833955,892156,158954,685589,619101,124844,552475,846116,11291,408538,655432,560750,303705,874383,195523,378595,652185,895059,485757,198593,722065,347115,17393,248784,344975,969465,573568,413204,145720,46122,964515,1003422,690432,951322,324001,522723,933358,627167,912740,412193,587588,433636,942761,91415,58931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]