SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 687812 LIMIT 1 [ RunTime:0.002184s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 687812 [ RunTime:0.002374s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (868534,1015116,111936,240900,342601,451213,951272,1026728,447467,830889,402122,917154,452886,138488,519073,1020099,859290,221410,500039,712318,138826,967001,586865,719847,275290,557103,934592,307707,1032613,761430,753686,553961,528578,411255,784769,712446,1031223,903089,124565,830196,451506,836110,749506,42161,150826,992700,912729,900530,136018,182863,413974,338774,800222,12082,767837,230694,729128,505671,456891,395813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 687812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 687812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]