SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493551 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493551 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (677203,660178,113456,489250,175172,59534,587168,428613,31402,1040926,214223,131741,538135,410152,349030,215658,816198,254000,245572,858423,795745,210882,120342,45000,235106,376381,603242,763604,400531,803975,234782,244533,728795,521659,554416,825020,670746,511710,69372,456810,134849,719763,357515,913088,987165,712997,716095,958688,77127,576497,367761,742099,176914,150375,519590,10541,909860,644379,797516,633506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002419s ]