SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511019 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511019 [ RunTime:0.001921s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (112214,336269,397687,438589,1007624,305263,601594,542685,378851,989542,204960,890014,913805,494500,277324,116903,217823,117527,389634,587252,852391,220378,401569,778875,395310,601381,935166,1026855,137033,313170,58918,817123,62808,168865,609655,321258,94715,81594,213483,562109,423017,372916,773299,903059,929017,817246,265444,296199,84492,92922,198447,1032956,742076,501260,768747,99082,841454,310886,997104,842184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]