SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534152 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534152 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (538950,240665,862378,275453,977492,5264,137981,305780,83351,267028,920890,680949,1005503,811071,117901,1041917,116641,909354,330285,169410,732110,560186,492421,840035,979162,303550,306055,39012,21208,218757,607757,508609,295277,192079,769217,45303,883807,884393,707363,537137,944983,174694,988794,838898,211845,723183,205886,1005560,361470,830621,858810,571731,504870,8634,189595,982492,282568,187283,736918,1003137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534152 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534152 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]