SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511610 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511610 [ RunTime:0.001484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (867116,115673,547779,389378,365550,1023787,139738,393189,589897,939229,329242,726658,726678,490798,429261,682867,1003534,61891,433421,72369,825920,218815,736383,44446,679175,633583,939835,516819,1009332,919513,555013,884336,551170,9987,888504,700166,167190,981831,806790,597469,755801,554724,458560,864954,169434,858630,708765,583795,260396,494120,957095,403278,81201,233468,954516,879800,458331,29899,298006,48509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]