SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455215 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455215 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (574410,601749,660062,486259,123013,787518,967398,837094,588382,409815,8002,900930,453064,181855,644484,680234,94155,578240,70884,403691,921768,261754,44388,912709,712470,809816,249145,191549,123555,125595,714401,868263,651626,972584,453680,548383,267784,648488,476227,288147,803639,530862,1048244,4967,98863,38709,219784,344000,605642,346044,981129,540615,211686,392340,856771,246157,1025604,430568,813198,353485) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455215 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455215 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]