SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520684 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520684 [ RunTime:0.005345s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (745948,846846,23822,135516,257780,344625,618001,567454,879733,847604,187926,932315,399880,909807,414385,594999,241214,942602,88907,831987,830833,249231,408593,522725,491161,691631,575779,47403,821992,624562,124274,776167,884252,1000715,742642,840732,67009,194866,540878,428142,1014635,691347,564425,296620,692208,596641,771858,148262,508066,484798,84941,528067,340657,1004031,1032128,151496,874448,762828,414350,755123) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002578s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520684 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520684 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]