SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415038 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415038 [ RunTime:0.001739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (53128,691228,856864,922643,253208,267858,672686,419124,277429,511065,549883,371872,220959,122120,419339,121576,284028,334415,583360,136840,405943,194727,882658,829740,876036,306490,726193,105690,737446,389495,520700,582315,597129,809876,525502,518476,174125,128664,784653,77108,606825,70795,214871,346899,531802,146584,235368,236213,717530,877899,285852,961808,547878,452283,372922,415671,116148,563060,528963,214461) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]