SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001595s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488740 LIMIT 1 [ RunTime:0.000852s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488740 [ RunTime:0.003307s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (707127,631622,978967,734551,660008,978061,180012,340476,983307,474141,396213,188580,760221,123369,65083,881417,228712,673152,100010,845253,437300,878912,325154,831362,742864,441364,592753,854555,249226,916165,582405,948158,485792,518057,811197,269032,659191,827470,133186,365429,56722,258748,265700,481016,973309,486726,65666,868126,317654,751234,677084,741957,107548,863972,330721,742913,911282,1033817,734672,272856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]