SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511807 LIMIT 1 [ RunTime:0.000684s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511807 [ RunTime:0.001443s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (865154,383445,809377,795645,945366,189977,43321,538083,29455,844649,747094,787300,17667,822955,94721,542034,175854,113959,775915,682430,816899,843005,736028,1043620,739318,224550,918955,317496,803761,897471,34135,1025440,52710,142977,665696,84849,524987,918753,334951,689961,16723,727660,197785,338228,850441,347046,172737,654236,236635,738494,940261,363223,450538,555172,139506,498909,903536,943672,475859,55154) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]