SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036313 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036313 [ RunTime:0.001725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (823763,662005,940698,785529,777293,542345,11938,992581,424170,319992,297892,386045,318294,1020058,67803,448141,941318,184806,596975,316321,961267,77896,961354,684669,777862,84029,594857,931874,805377,446583,1021260,532141,417929,427247,577423,889670,601773,1005831,464524,228667,101618,217529,449795,691992,453848,872826,754325,118918,676198,228691,622188,1026445,488543,652982,1020133,653362,211640,490908,400158,543155) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000408s ]