SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 57309 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 57309 [ RunTime:0.001841s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5041,129540,271578,396569,831573,72431,23651,799862,48514,933616,886816,420762,79129,5469,412601,853638,1044192,841025,807458,993627,1018057,199501,381036,989317,1012408,254042,721721,544850,109162,973183,216907,697767,219640,153820,338780,343470,359763,446617,430599,547473,12224,146116,704952,614530,260038,486436,401452,102182,264014,171176,302114,207576,285042,271387,336809,293355,416357,21204,868643,20521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 57309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 57309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]