SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031811 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031811 [ RunTime:0.001817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141309,902475,754991,260869,851701,424425,879712,449935,300236,51097,115614,115293,685651,785845,378847,1025500,365410,377739,873258,643625,183989,602206,161231,787109,431082,273836,362268,494158,359940,1000442,879378,850324,910221,55263,78146,793632,715529,419073,310694,829589,1048676,578935,829732,538040,711105,544257,143627,107001,404401,939415,1039314,633277,269455,644420,1043809,939568,158015,551553,256546,819339) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000452s ]