SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 910941 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 910941 [ RunTime:0.001755s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (557421,133174,764456,391483,968010,532390,398508,87708,271418,1048001,912548,924203,965969,770825,925001,329990,487032,539993,298686,995687,664626,244552,804710,98120,263615,18317,945319,514699,394809,669596,511332,461901,345574,398540,93814,860742,272625,985488,360438,911925,117631,252996,152883,588050,292776,808745,864320,223408,873086,957229,789257,122623,866273,409390,903821,1046921,136074,234107,141407,56908) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 910941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 910941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]