SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000948s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421938 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421938 [ RunTime:0.002496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (328838,995726,781417,701802,904457,281122,803341,903554,587702,943998,356535,436325,72366,764548,377061,367289,825152,132542,730413,17183,254092,120736,140757,247423,762885,914516,143273,412018,351193,171251,259503,400751,859116,70604,238897,230091,922658,132994,432185,403312,80180,171314,92835,141653,561550,683483,675894,150006,703154,1014019,896903,386001,99713,667169,875251,651491,1019815,208628,290285,502015) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421938 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421938 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001411s ]