SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012058 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012058 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (231799,854917,796652,653454,211262,316606,70071,800032,292633,297002,192753,970623,192832,278567,126338,228120,416067,450790,82087,522268,1011750,119501,39327,393514,602065,730847,166230,258503,697263,553405,7535,433404,489701,540521,461572,153487,524409,782801,638600,537371,446204,248026,551225,258728,968883,874653,580986,886044,146955,717099,105772,7334,731047,889447,369514,87727,320054,270004,928429,349101) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]