SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002744s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491718 LIMIT 1 [ RunTime:0.004312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491718 [ RunTime:0.008496s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (943670,773277,409838,207689,671888,123780,1039685,682074,239166,1015912,277333,349090,20767,885444,928666,302427,252108,953506,183476,821784,1016525,282380,518860,703060,1012474,766051,695152,388276,959225,98160,134591,621006,247086,939107,727341,485945,218699,232634,272847,60524,459082,498431,866966,398187,62418,686906,802634,122910,19361,814114,497475,226837,376936,431866,82716,511167,324869,344027,674268,898175) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000995s ]